Re: Tomcat JDBC Connection Pool interfaces to PostgreSQL...

On Tue, May 17, 2016 at 2:40 PM, Eric Neron <eneron(at)e-djuster(dot)ca> wrote:

>
> The Tomcat documentation suggests to extract the native connection by
> using the following method:
>
> Connection pgConnection = ((javax.sql.PooledConnection) conn).
> getConnection ( );
>
> Although this does not fail, using a debugger, I can see that pgConnection
> is really an
> org.postgresql.jdbc.PgConnection (not an org.postgresql.PGConnection),
> and there is not way it seems that I can bridge between the two... even by
> using:
>
>
​​​If you get this I'm not sure where the issue is...

org.postgresql.jdbc.PgConnection implements org.postgresql.core.BaseConnect
which extends​

​org.postgresql.PGConnection​ which is the interface that you desire.
​

> pgConnection.unwrap ( PGConnection.class );
>
> ​
Not sure...

David J.