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)
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)
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
I finally configured this section to disallow anonymous postings.