I have installed SchemaSpy and get this error when I try to run it:
This is the command (password not displayed!) SchemaSpyGUI has generated:
java -jar "C:\SchemaSpy\schemaSpy_5.0.0.jar" -dp "C:\Program Files (x86)\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc.jar" -t mssql -db Bancvue -host localhost -port 516345 -u gordon.page -connprops "C:\SchemaSpy\properties\mssql.properties" -o "C:\SchemaSpy\gordon.page_Bancvue_"
java.lang.NullPointerException
at java.util.StringTokenizer.<init>(Unknown Source)
at net.sourceforge.schemaspy.util.DbSpecificConfig.loadOptions(DbSpecificConfig.java:65)
at net.sourceforge.schemaspy.util.DbSpecificConfig.<init>(DbSpecificConfig.java:51)
at net.sourceforge.schemaspy.util.ConnectionURLBuilder.<init>(ConnectionURLBuilder.java:48)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:139)
at net.sourceforge.schemaspy.Main.main(Main.java:42)
E=1I=1
I believe I have PATH set up properly
I got the error message through SchemaSpyGUI, but when I have tried to run it from the command line I get a similar error.
Any ideas?
Somehow it wasn't able to find connectionSpec in mssql.properties (exists inside of the .jar). I really have no clue how that can happen. The only non-standard thing you're doing is specifying -connprops, so there's a slight chance that's somehow involved.
Can you try the latest beta at http://schemaspy.sourceforge.net/schemaSpy.jar and see if that resolves it?
Thanks,
John
Thanks John.
Unfortunately, that had no effect. Here is the error message:
C:\SchemaSpy>java -jar schemaSpy.jar -t mssql -o c:\schemaspy\outdir -host localhost -db BancVue -port 51635 -u gordon.page -p ...
java.lang.NullPointerException
at java.util.StringTokenizer.<init>(Unknown Source)
at net.sourceforge.schemaspy.util.DbSpecificConfig.loadOptions(DbSpecificConfig.java:65)
at net.sourceforge.schemaspy.util.DbSpecificConfig.<init>(DbSpecificConfig.java:51)
at net.sourceforge.schemaspy.util.ConnectionURLBuilder.<init>(ConnectionURLBuilder.java:48)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:136)
at net.sourceforge.schemaspy.Main.main(Main.java:45)
C:\SchemaSpy>
The only thing I can think of is that it's finding a different .properties file. Your c:\SchemaSpy\ directory does not contain a file named mssql or mssql.properties, right? If it does then SchemaSpy is attempt to use it instead of what's in the .jar.
John