0 Replies Latest reply on Sep 30, 2005 4:00 PM by Albert Gabrilovich

    Oracle Connection problem

    Albert Gabrilovich Newbie

      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.