Re: No suitable driver...

[Paul Cullum]

Thank you for responding.  I tried moving the jdbc jars to the endorsed 
directory and although verbose output from java shows that they are 
among the first files opened I still get the same error.

Thanks for your help though.
[EMAIL PROTECTED] wrote:
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>
||