1 Reply Latest reply on Dec 22, 2004 8:49 PM by Adrian Brock

    How to configure connection pool for getting OracleConnectio

    andrew bykov Newbie

      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