0030919: can't use DB connection defined as JNDI service

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #30919		[ Back to Issue ]
Summary	0030919: can't use DB connection defined as JNDI service

Revision	2015-09-24 12:38 by alostale
Steps To Reproduce	* Configure Openbravo to use JNDI (removing the rest of direct DB connection settings) [1] removing from Openbravo.properties settings to use direct DB connection * Start Tomcat [1] follow documentation in http://wiki.openbravo.com/wiki/Projects:JNDI_Service/Technical_Documentation [^] until 0030918 is fixed

Revision	2015-09-24 12:38 by alostale
Description	It is not possible to use DB connection defined as JNDI service because even having it configured, direct connection is tried to be created in some places. The behavior is different depending on OB version: * 3.0RC4-current pi (pre PR15Q4), this error is risen: [main] ERROR org.openbravo.database.ConnectionProviderImpl - Error getting connection java.sql.SQLException: No suitable driver found for null/null at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:270) at org.openbravo.database.OpenbravoDriverManagerConnectionFactory.createConnection(OpenbravoDriverManagerConnectionFactory.java:55) * current pi (pre PR15Q4), in same place a ClassCastException is thrown trying to cast JNDIConnectionProvider to ConnectionProviderImpl Additionally, when it is combined with JdbcExternalConnectionPool: * it tries to create two pools: one for DAL and another one for xsql connections * DAL connections try to use direct DB connection rather than JNDI resulting in NPE if those properties are not set

Revision	2015-09-24 12:36 by alostale
Steps To Reproduce	* Configure Openbravo to use JNDI (removing the rest of direct DB connection settings) [1] * Start Tomcat [1] follow documentation in http://wiki.openbravo.com/wiki/Projects:JNDI_Service/Technical_Documentation [^] until 0030918 is fixed

Revision	2015-09-24 12:35 by alostale
Steps To Reproduce	-

Revision	2015-09-24 12:35 by alostale
Description	It is not possible to use DB connection defined as JNDI service because even having it configured, direct connection is tried to be created in some places. The behavior is different depending on OB version: * 3.0RC4-current pi (pre PR15Q4), this error is risen: [main] ERROR org.openbravo.database.ConnectionProviderImpl - Error getting connection java.sql.SQLException: No suitable driver found for null/null at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:270) at org.openbravo.database.OpenbravoDriverManagerConnectionFactory.createConnection(OpenbravoDriverManagerConnectionFactory.java:55) * current pi (pre PR15Q4), in same place a ClassCastException is thrown trying to cast JNDIConnectionProvider to ConnectionProviderImpl Additionally, when it is combined with JdbcExternalConnectionPool, it tries to create two pools: one for DAL and another one for xsql connections.

Revision	2015-09-24 12:28 by alostale
Description	It is not possible to use DB connection defined as JNDI service because even having it configured, direct connection is tried to be created in some places.