JBoss EAP 6 / problem with ejb 2.0 referencing datasource

290 views
Skip to first unread message

hvu....@gmail.com

unread,
Jun 13, 2013, 5:24:54 AM6/13/13
to jdbcdslo...@googlegroups.com

I encountered a problem by running jboss eap 6.0: Here is my declartion in standalone.xml: <subsystem xmlns="urn:jboss:domain:datasources:1.1">

<datasources>
<datasource jndi-name="java:jboss/datasources/OracleDS" pool-name="OracleDS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@eswdev.corproot.net:1521:eswdev;targetDS=oracle.jdbc.xa.OracleXADataSource</connection-url> <driver>jdbcdslog</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <pool>
<min-pool-size>10</min-pool-size> <max-pool-size>70</max-pool-size> <prefill>true</prefill> <use-strict-min>false</use-strict-min> <flush-strategy>FailingConnectionOnly?</flush-strategy>
</pool> <security>
<user-name>integration</user-name> <password>integration</password>
</security> <timeout>
<set-tx-query-timeout>true</set-tx-query-timeout> <blocking-timeout-millis>10000</blocking-timeout-millis> <idle-timeout-minutes>10</idle-timeout-minutes> <query-timeout>900</query-timeout>
</timeout>
</datasource> <drivers>
<driver name="oracle" module="com.oracle.ojdbc6">
<xa-datasource-class>oracle.jdbc.OracleDriver?</xa-datasource-class>
</driver> <driver name="jdbcdslog" module="org.jdbcdslog">
<xa-datasource-class>org.jdbcdslog.ConnectionPoolXADataSourceProxy</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>

Then in ejb-jar.xml (ejb 2), I declared the resource:

<resource-ref >
<res-ref-name>java:jboss/datasources/OracleDS</res-ref-name> <res-type>javax.sql.DataSource?</res-type> <res-auth>Container</res-auth>
</resource-ref>

When starting jboss, it threw this error: 2013-06-12 10:49:10,362 WARN [org.jboss.as.ee] JBAS011001: Could not resolve resource-env-ref java:jboss/datasources/OracleDS

Meanwhile if i chose the original driver (oracle) then everything works fine. What have I done wrong here ? Please advise. Thanks a lot! Hoang-Vu

Reply all
Reply to author
Forward
0 new messages