Cannot aquire datasource for database. Upgrading 3.2.6 to 4.

[andrewboyd]

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

[andrewboyd]

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