#2 failed to connect to instance (beta version)

open
John Currier
None
5
2010-10-11
2010-10-11
Tim
No

tim@linuxbox:~$ java -jar schemaspy/schemaSpy.jar -t mssql05-jtds-instance -host
kang -port 1433 -instance=myinstance -db mydb -s dbo -o public_html/te
st/ -u sa -pfp -noimplied -dp schemaspy/jtds/jtds-1.2.5.jar
Using database properties:
[schemaspy/schemaSpy.jar]/net/sourceforge/schemaspy/dbTypes/mssql05-jtds-insta
nce.properties
Password:

Failed to connect to database URL [jdbc:jtds:sqlserver://myserver:1433/mydb;
instance=myinstance]

java.sql.SQLException: Server myserver has no instance named myinstance.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java
:281)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java
:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at net.sourceforge.schemaspy.SchemaAnalyzer.getConnection(SchemaAnalyzer
.java:598)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:
157)
at net.sourceforge.schemaspy.Main.main(Main.java:42)

Discussion

  • Tim
    Tim
    2010-10-11

    sorry didn't mean to post that without a description, caught the enter key on my way to the mouse :)

    The instance version you've done for me is working great on my windows box, but I thought i'd give it a try on a handy linux server so i could schedule it and share it with apache. Oddly it doesn't run on the linux box. I don't know why.

    Some version info:
    #64-Ubuntu SMP Wed Aug 18 22:43:50 UTC 2010
    Ubuntu 9.04 \n \l
    java version "1.6.0_18"
    OpenJDK Runtime Environment (IcedTea6 1.8.1) (6b18-1.8.1-0ubuntu1~9.04.1)
    OpenJDK 64-Bit Server VM (build 16.0-b13, mixed mode)

     
  • John Currier
    John Currier
    2010-10-11

    • assigned_to: nobody --> johncurrier
     
  • John Currier
    John Currier
    2010-10-11

    The only thing I can think of is that the Linux version is somehow more case sensitive than Windows.

    Does anything look suspect in the database URL?

    John

     
  • John Currier
    John Currier
    2011-07-06

    I finally configured this section to disallow anonymous postings.