Thread: Still No Suitable Driver

Still No Suitable Driver

From
"Jackson Ching"
Date:
Hi,

    Thanks for the answers before.

    But i still have the same problem. i don't know why. i have put jdbc7.0-1.2.jar in /opt/IBMJava2-13/jre/ext and
/opt/IBMJava2-13/jre/libalready and put them in the CLASSPATH=$CLASSPATH:/opt/IBMJava2-13/jre/ext/jdbc7.0-1.2.jar   

    I also have put PATH=$PATH:/opt/IBMJava2-13/bin

    I find it very strange, i was able to create the tables using the same JDBCObjectPool during installation of my
application,but in my servlet, when accessing the DB, i got an No Suitable Driver. very strange behavior.     

    what could be the problem?

jackson


Re: Still No Suitable Driver

From
"Peter Mount"
Date:
If you put them in the jre/ext directory, then you don't put them into
CLASSPATH. The entries in jre/ext are implied to be at the begining of the
CLASSPATH, and as such can't then be removed.

What URL are you passing to JDBC?
Are you calling Class.forName("org.postgresql.Driver") or
Class.forName("postgresql.Driver") [depends on version which you use]?

Peter

--
Peter T Mount  peter@retep.org.uk, me@petermount.com
Homepage: http://www.retep.org.uk Contact details: http://petermount.com
PostgreSQL JDBC: http://www.retep.org.uk/postgres/
Java PDF Generator: http://www.retep.org.uk/pdf/
----- Original Message -----
From: "Jackson Ching" <jching@imvi.com.ph>
To: <pgsql-general@postgresql.org>
Sent: Friday, August 25, 2000 11:18 AM
Subject: [GENERAL] Still No Suitable Driver


> Hi,
>
> Thanks for the answers before.
>
> But i still have the same problem. i don't know why. i have put
jdbc7.0-1.2.jar in /opt/IBMJava2-13/jre/ext and /opt/IBMJava2-13/jre/lib
already and put them in the
CLASSPATH=$CLASSPATH:/opt/IBMJava2-13/jre/ext/jdbc7.0-1.2.jar
>
> I also have put PATH=$PATH:/opt/IBMJava2-13/bin
>
> I find it very strange, i was able to create the tables using the same
JDBCObjectPool during installation of my application, but in my servlet,
when accessing the DB, i got an No Suitable Driver. very strange behavior.
>
> what could be the problem?
>
> jackson
>