I have Connection problem in Web Service (stateless bean):
java.sql.SQLException: Table not found: DUAL in statement [select 'ABC123' from dual]
STACKTRACE shows problem in
org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:321)
ejb-jar.xml :
....
Web Service
<ejb-name>LoadWS</ejb-name>
<service-endpoint>...
<ejb-class>...
<session-type>Stateless</session-type>
<transaction-type>Container</transaction-type>
<resource-ref>
<res-ref-name>jdbc/OracleDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Application</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
jboss.xml :
....
<ejb-name>LoadWS</ejb-name>
<jndi-name>...</jndi-name>
<resource-ref>
<res-ref-name>jdbc/OracleDB</res-ref-name>
<resource-name>java:/OracleDS</resource-name>
</resource-ref>
oracle-ds.xml:
....
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@IP_ADDRESS:1528:SID</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>USER</user-name>
PASWWORD
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<type-mapping>Oracle8</type-mapping>
</local-tx-datasource>
During Server start-up there is no error. Console shows OracleDS running.
Thanks.