Jeff Boes <jboes@nexcerpt.com> wrote: > > Jeff Boes wrote: > > I'm hoping there's someone here with experience in building the Visual > > Explain tool from Red Hat. > > Thanks to some patient hand-holding by Fernando Nasser > (fnasser@redhat.com), I managed to make this work. > > Details, for those following my bread-crumb trail: > > My OS is Whitebox 3.0. I installed the Java SDK RPM, but until I did this: > > $ export CLASSPATH=/usr/java/j2sdk1.4.2_04/jre/lib/rt.jar > > I couldn't get "ant" to build the package. I don't know about the "Whitebox" (whatever that is) OS, but on my Sparc Solaris boxes, anything placed in $JAVA_HOME/jre/lib/ext/ is automatically added to CLASSPATH when a Java app is started-up. > > After I built it, some further messing around was necessary to discover > that I needed the JDBC, and that I needed to edit CLASSPATH some more. I > ended up with this incantation: > > > $ export > CLASSPATH=/usr/java/j2sdk1.4.2_04/jre/lib/rt.jar:/home/jboes/downloads/pg74.213.jdbc3.jar:. I decided to build on how Java works on my Sun boxes, by mimicking its "default CLASSPATH add-ons" directory in /usr/local. Then I wrote a "java_profile" script that automatically adds any jarfile it finds there into the CLASSPATH environment variable. It gets run by, say, /etc/profile, so all users get it. > [remainder snipped] > -- Jim Seymour | Spammers sue anti-spammers: jseymour@LinxNet.com | http://www.LinxNet.com/misc/spam/slapp.php http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund: | http://www.spamcon.org/legalfund/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html