Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

phoenix jdbc drivers in was jee container

phoenix jdbc drivers in was jee container

New Contributor

Hi all,

We have tried to connect phoenix (on hdp 2.4) from websphere application server (ver 8.5.5.10 ) (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 ?

Thanks,

3 REPLIES 3

Re: phoenix jdbc drivers in was jee container

New Contributor

Halledeceğiz Faruk abi sıkıntı yok :)))

Re: phoenix jdbc drivers in was jee container

New Contributor

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.

https://phoenix.apache.org/faq.html#Should_I_pool_Phoenix_JDBC_Connections

https://issues.apache.org/jira/browse/PHOENIX-2388

Re: phoenix jdbc drivers in was jee container

Super Guru
Don't have an account?
Coming from Hortonworks? Activate your account here