On Saturday 03 December 2005 16:06, Randall R Schulz wrote:
Phil,
On Saturday 03 December 2005 05:59, Phil Burness wrote:
Anybody using schemaSpy successfully on SuSE 9.3 or above?
I was unaware of this project, but I tracked it down (first thinking it my by an XML thing) but see that in fact "schema" refers to relational database schemas. Both could be useful in my work, actually.
So I downloaded the binary JAR (I already have MySQL's Connector/J installed) and gave it a try.
it keeps giving me an error with java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:199) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:187) at java.lang.ClassLoader.loadClass(ClassLoader.java:289) at java.lang.ClassLoader.loadClass(ClassLoader.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:219) at net.sourceforge.schemaspy.Main.getConnection(Main.java:429) at net.sourceforge.schemaspy.Main.main(Main.java:122)
I've downloaded the mysql connector/J class from MySQL and installed it. I've tried defining $CLASSPATH to point to the install directory, and I've tried running schemaSpy with java -jar -cp path-to-connector/J-directory but it still gives the same error.
I mostly just get diagnostics when I run it, not really knowing how to invoke it properly (fixed-width font and no line wrap best):
% java -cp /home/JT/mysql/mysql-connector-java-3.1.11/mysql-connector-java-3.1.11-bin. jar \ -jar /acquisitions/schemaSpy_2.1.0.jar \ -t mysql -o . -u root -p '*********' -h localhost -s mysql -all Usage: java -jar /acquisitions/schemaSpy_2.1.0.jar [options] -t databaseType type of database - defaults to ora use -dbhelp for a list of built-in types -u user connect to the database with this user id -s schema defaults to the specified user -p password defaults to no password -o outputDirectory directory to place the generated output in -css styleSheet.css defaults to schemaSpy.css -cp pathToDrivers optional - looks for drivers here before looking in driverPath in [databaseType].properties -dbthreads max concurrent threads when accessing metadata defaults to -1 (no limit) use 1 if you get 'already closed' type errors -x columnNamesRegex exclude matching columns from analysis e.g.: -x "(book.isbn)|(borrower.address)" -nohtml defaults to generate html -noimplied defaults to generate implied relationships -all analyze all "user" schemas in the specified database -schemaSpec used with -all to specify "user" schemas overrides schemaSpec in .properties file see db2.properties for more details -help detailed help -dbhelp display databaseType-specific help
Go to http://schemaspy.sourceforge.net for more details or the latest version.
java -jar /acquisitions/schemaSpy_2.1.0.jar -help to display more detailed help
For starters, why don't you state the specific invocation you used?
Phil
Randall Schulz My specific invocation was :- java -cp /home/pburness/mysql-connector-java-3.0.17/mysql-connector-java-3.0.17-ga-bin.jar -jar schemaSpy_2.1.0.jar -t mysql -db tract -o library -u phil -p xxxx -host localhost -s mysql -all
I notice your using a different version of connector - I tried 3.1.12 and that didn't work either. Did you get the 3.1.11 from the mysql website? Phil