Re: [JDBC] Problem updating driver to 42.0.0

On 3 March 2017 at 04:40, Bogdan Daniliuc <bdaniliuc@montran.com> wrote:

Hello,

We are encountering an error when trying to update the driver from postgresql-9.4.1212 to postgresql-42.0.0 in WebSphere 8.5.5

With 42.0.0, we get:

Failed to create a ConnectionPoolDataSource from PostgreSQL JDBC Driver 42.0.0 for testDB at jdbc:postgresql://localhost:5432/testDB: java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/testDB

DSRA8201W: DataSource Configuration: DSRA8040I: Failed to connect to the DataSource DS2.  Encountered java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/testDB DSRA0010E: SQL State = 08001, Error Code = 0.
java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/testDB DSRA0010E: SQL State = 08001, Error Code = 0
    at java.sql.DriverManager.getConnection(DriverManager.java:700)
    at java.sql.DriverManager.getConnection(DriverManager.java:258)
    at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:79)
    at org.postgresql.ds.PGConnectionPoolDataSource.getPooledConnection(PGConnectionPoolDataSource.java:69)


The driver is in a c:\driver directory. It works if the driver is moved in AppServer\java_1.8_64\jre\lib\ext, but this is not recommended by IBM.

9.2.1212 and 1211 all work when placed in the same directory.

Thank you,

Bogdan



--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc