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