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.