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