Re: [SLE] schemaSpy [Trimmed]

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




--
Check the headers for your unsubscription address
For additional commands send e-mail to suse-linux-e-help@xxxxxxxx
Also check the archives at http://lists.suse.com
Please read the FAQs: suse-linux-e-faq@xxxxxxxx

Relevant Pages

  • Re: [SLE] Kat and libpoppler
    ... Randall R Schulz wrote: ... > So I tried scanning a directory disjoint from its working directory. ...
    (SuSE)
  • Re: [SLE] Doubt about SMPs and parallel jobs
    ... On Wednesday 14 September 2005 17.05, Randall R Schulz wrote: ... >> Chaitanya. ... I have found that running calculations and image processing and other CPU ...
    (SuSE)
  • Re: Jeff Duntemann Reviews AoA
    ... If Duntemann or any one else has any questions or comments, ... Query the database (here, I tend to think of databases ... Randall Hyde's or Betov's, include genuine applications ... And there are a lot of possible practical samples that can be ...
    (alt.lang.asm)
  • Re: [SLE] Where suse will be ?
    ... > Randall R Schulz wrote: ... >>Randall Schulz ... Linux and other open-source softwae. ... you can contribute immensely by writing some documentation ...
    (SuSE)
  • Re: [SLE] Recommendations on Wireless LAN Equipment
    ... On September Saturday 10 2005 10:24 am, Randall R Schulz wrote: ... >> Jos van Kan ... "nanny cams" installed they actually show most of the house, ...
    (SuSE)
Loading