We have tried to connect phoenix (on hdp 2.4) from websphere application server (ver 22.214.171.124 ) (JEE6 container) using phoenix jdbc thin and thick client.
The same error occured for both ;
ClassCastException: org.apache.phoenix.queryserver.client.Driver incompatible with javax.sql.ConnectionPoolDataSource ClassCastException: org.apache.phoenix.jdbc.PhoenixDriver incompatible with javax.sql.ConnectionPoolDataSource .
What schould we do ?
Unfortunately, the Phoenix JDBC driver does not implement a connection pool class that can be used with a J2EE Application Server such a WebSphere, Weblogic, etc. Instead, the Phoenix JDBC driver is designed leverage driver managed connections. Please check below links for connection pooling for Phoenix.