Re: [SLE] schemaSpy [Trimmed]

4 Dec 2005

      On Saturday 03 December 2005 21:50, Randall R Schulz wrote:
...
Hi,
Is it worse to re-post with proper trimming than it is to leave just the
under-trimmed message?
On Saturday 03 December 2005 13:17, Phil Burness wrote:
...
...
Randall - I haven't a chance!
Interested to read through your notes but I'm not good with Java and
don't know how to proceed....
Sorry. It's actually simple enough, if you cut to the chase instead of
getting the blow-by-blow that I gave you.
Try this: Create an "sspy" script (be sure to "chmod +x sspy"):
-==--==--==--==--==--==--==--==--==--==--==--==--==--==--==--==-
#!/bin/bash --norc
classPath="/usr/share/java/mysql-connector-java.jar"
export  CLASSPATH="$classPath"
exec \
        java \
            -jar /acquisitions/schemaSpy_2.1.0.jar \
            -t mysql \
            -cp "$classPath" \
            "$@"
-==--==--==--==--==--==--==--==--==--==--==--==--==--==--==--==-
(For whatever funky reason, you need the Connector/J JAR both in the
Java class path _and_ in the -cp argument to schemaSpy itself.)
Be sure to correct the path names for your system.
Based on my experience, I recommend you use 3.1.12 of Connector/J. The
one you have should be OK or you can install the latest
mysql-connector-java package from the Packman repository
(mysql-connector-java-3.1.12-0.pm.0).
If you want to see the pretty graphical database diagrams, install this
RPM:
<http://www.graphviz.org/pub/graphviz/ARCHIVE/graphviz-2.6-1.fc4.i386.rpm>
Now invoke it like this:
% sspy -db tract -o library -u phil -p X -host localhost -s mysql -all
That should do it.
Again, good luck. If you still have problems, feel free to report back.
...
Phil
Randall Schulz
OK, I tried all that (edited the script to use my own locations) but it gave 
me some execution errors :-(
So I did it the long way:-
classPath="/home/pburness/mysql-connector-java-3.1.12/mysql-connector-java-3.1.12.bin.jar"
export CLASSPATH=$classPath
// checkit
echo $CLASSPATH
/home/pburness/mysql-connector-java-3.1.12/mysql-connector-java-3.1.12.bin.jar
// Run the app
java -jar schemaSpy_2.1.0.jar -t mysql -cp "$classPath" -db tract -o library 
-u phil -p mypassword -host localhost -s mysql -all 
// Result
Using database properties:
    [schemaSpy_2.1.0.jar]/net/sourceforge/schemaspy/dbTypes/mysql.properties

Failed to load driver [com.mysql.jdbc.Driver] from classpath []

Use -t [databaseType] to specify what drivers to use
or modify one of the .properties from the jar, put it on your file
system and point to it with -t [databasePropertiesFile].

For many people it's easiest to use the -cp option to directly specify
where the database drivers exist (usually in a .jar or .zip/.Z).

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)

What I did notice however (I downloaded mysql-connector-java-3.1.12 again) and 
as I unzipped/untarred I got a zero block error. This also happened when I 
downloaded and unzipped/tarred the 3.0.7 version too.

I'm going to try using the packman version later today.

The package looks good and is great for what I need - if only I could get it 
working!!!!

Phil