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>


||




Reply via email to