Love pgsql. But facing this weird problem (detailed below) for past couple of days with pgsql jdbc41 driver with tomcat 8 connection pooling on on jvm1.8 (all on x64 windows 8) with no resolution in sight for casting a jdbc db tomcat pooled connection to PGConnection hitting the wall.
I am sure not sure if I am doing something silly or it is the limitation of pgsql jdbc41 driver. Did any one face any such issue? Does any one know some way out for this?
Problem:
When I try to cast a DB Connection obtained using tomcat jdbc resource (pooled) to org.postgresql.PGConnection, of course after unwrapping it, execution is running into exception with the message: (java.lang.ClassCastException) java.lang.ClassCastException: org.postgresql.jdbc4.Jdbc4Connection cannot be cast to org.postgresql.PGConnection
Gotcha
Weird enough, if I do not use a pooled connection but create a single db stand-alone connection in the java code - dbCon = .getConnection(...) and cast this to org.postgresql.PGConnection - to my surprise - it's successful. Feels weird!
Environment
OS : WIndows 8 x64
JRE : java version "1.7.0_51"
Tomcat : 8.0 (x64)
Connection pooling : Tomcat jdbc connection pooling with database as JDBC resource (org.apache.tomcat.jdbc.pool.DataSourceFactory)