Hi,

I am using JBoss-2.2.1 with Tomcat-3.2.1 embedded and oracle driver
archive: classes12_01.zip.
I set up connection pooling for oracle as documented in the
documentation page.
in jboss.jcml
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=OracleDS">
    <attribute name="PoolName">OracleDS</attribute>
    <attribute
name="DataSourceClass">oracle.jdbc.xa.client.OracleXADataSource</attribute>

    .......
</mbean>

Getting a connection and doing SQL updates were ok  for normal java
classes, however when I tried to perform SQL update in a stateless
session bean (with container managed transaction, transaction:
Required), the following exception was thrown.

    java.sql.SQLException: ORA-06550: line 1, column 14:
        PLS-00201: identifier 'JAVA_XA.XA_START' must be declared
        ORA-06550: line 1, column 8:
        PL/SQL: Statement ignored

Do I need to specify a resource manager in the ejb deployment .jar file?

I tried setting a jdbc datasource with the following config
  <res-name>OracleDS</res-name>
  <res-jndi-name>java:/OracleDS</res-jndi-name>
in jboss.xml for the ejb, but it did not work.



- Jim -




_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to