I think this is also a JDK 1.4 issue. Putting the jdbc jars under the
endorsed directory or adding them to the bootclasspath might solve the
problem.
Morris Kwan
XSLT Development
IBM Toronto Lab
Tel: (905)413-3729
Email: [EMAIL PROTECTED]
Paul Cullum
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
om> cc:
Subject: No suitable driver...
01/27/2003 11:36
AM
I downloaded xalan-j_2_4_1-bin.tar.gz and was trying to modify some of
the sql extensions sample code.
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>
||
