[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jboss-user
Subject:    [JBoss-user] [EJB/JBoss] - Oracle Connection problem
From:       a_gabril <do-not-reply () jboss ! com>
Date:       2005-09-30 20:00:57
Message-ID: 8512249.1128110457357.JavaMail.jboss () colo-br-02 ! atl ! jboss ! com
[Download RAW message or body]

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.


View the original post : \
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3898318#3898318

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3898318



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user


[prev in list] [next in list] [prev in thread] [next in thread]