Re: Problem updating driver to 42.0.0

Hi Bogdan

How would websphere find it if was in c:\driver

I'm sort of clue free here ?

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 3 March 2017 at 04:40, Bogdan Daniliuc <bdaniliuc(at)montran(dot)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(BaseDa
> taSource.java:79)
> at org.postgresql.ds.PGConnectionPoolDataSource.getPooledConnec
> tion(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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>