Hi!
The problem: I need to get a pooled OracleConnection instance (not javax.sql.Connection) from stateless session EJB (for BLOB performing)
App server JBoss 3.2.6
...
OracleDataSource ods = (OracleDataSource) jndiContext.lookup("java:jdbc/staffDB");
...
at line looks like
(OracleConnection)ods.getConnection();
I catch exception without any messages.
Datasource configuration:
<local-tx-datasource>
<jndi-name>jdbc/staffDB</jndi-name>
<connection-url>jdbc:oracle:thin:@192.168.60.60:1521:asm2</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>appowner</user-name>
appowner
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
I think the cause is incorrect datasource configuration, but how to configure it correctly...
Help me please
Thanks in advance
Andrew Bykov
Moderated: USE SEARCH