1 Reply Latest reply on Jun 14, 2006 4:32 PM by Andrew Boyd

    Cannot aquire datasource for database. Upgrading 3.2.6 to 4.

    Andrew Boyd Novice

      Hi All,
      I'm getting an exception when I start up JBoss 4.0.4:

      FATAL [SystemAlerts] Cannot aquire datasource for database. Exception was: MercuryDB not bound
      FATAL [DBCallEngineService] Cannot create DBCallEngine because it cannot lookup datasource with jndi name=java:/MercuryDB
      WARN [ServiceController] Problem starting service mercury:service=DBCallEngine
      net.mercury.db.DBCallException: Cannot create DBCallEngine because it cannot lookup datasource with jndi name=java:/MercuryDB

      My -ds.xml is the same as I used in 3.2.6.:


      <local-tx-datasource>
      <jndi-name>MercuryDB</jndi-name>
      <connection-url>jdbc:oracle:oci:@OZERO</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>user</user-name>
      pwrd
      <check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
      <!-- Checks the Oracle error codes and messages for fatal errors --> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      </local-tx-datasource>



      Any help is greatly appreciated.

      Thanks,

      Andrew

        • 1. Re: Cannot aquire datasource for database. Upgrading 3.2.6 t
          Andrew Boyd Novice

          After the stack trace from above it seems that the datasource is getting bound:

          <snip prior stacktrace>

          [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:name=MercuryDB,service=DataSourceBinding' to JNDI name 'java:MercuryDB'
          ERROR [MessageBodyServlet] javax.naming.NameNotFoundException: MercuryDBCallEngine not bound
          ERROR [[/MercuryDataService]] Servlet /MercuryDataService threw load() exception
          javax.naming.NameNotFoundException: MercuryDBCallEngine not bound