Specifically I was trying to run the basic-connection samples modified to query a table from a Postgresql database.
I initially encountered a number of problems that it turns out were because I am using JSDK 1.4 but I added the appropriate jars to the endorsed directory and the samples ran without any unhandled exceptions.
My problem is that I get a "No suitable driver" message returned. I've tried two different Postgresql JDBC drivers that both work with a small java program that I wrote to test them. The JARs are explicitly in the classpath so I'm not too sure why they aren't found.
Is there something blindingly obvious that I am not picking up on? I am running the "java org.apache.xalan.xslt.Process -in dbinfo.xml -xsl dbtest-cinfo.xsl -out import1.html"
example with dbinfo.xml containing the following depending on whether or not it is either pgjdbc2.jar or jxDBCon-jdbc3-0.9z.jar (both jar files are in my CLASSPATH) that I wish to use:
<dbtest>
<description>This file contains information required to make a connection to the DBMS</description>
<DBINFO> <dbdriver>org.postgresql.Driver</dbdriver> <dburl>jdbc:postgresql://localhost:5432/pcullum</dburl> <user>pcullum</user> <password/> </DBINFO>
</dbtest>
OR
<dbtest>
<description>This file contains information required to make a connection to the DBMS</description>
<DBINFO> <dbdriver>org.sourceforge.jxdbcon.JXDBConDriver</dbdriver> <dburl>jdbc:postgresql:net//localhost:5432/pcullum</dburl> <user>pcullum</user> <password/> </DBINFO>
</dbtest>
||
