We are using 8.1.6. Here are the relevant sections from the various config files.
JBOSS.Properties
================
jdbc.drivers=org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,oracle.jdbc.xa.OracleXid
JBOSS.conf
==========
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="OracleDB">
<ARG TYPE="java.lang.String" VALUE="oracle.jdbc.xa.client.OracleXADataSource">
</MLET>
JBOSS.jcml
==========
<mbean name="DefaultDomain:service=XADataSource,name=OracleDB">
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:oracle:thin:@atiadb:1521:lom</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">xxxx</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">xxxx</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
classes12.zip has been placed in the lib/ext directory of JBOSS
Here is my ejb-jar.xml file
<?xml version="1.0"?>
<ejb-jar>
<description>ITC</description>
<display-name>ITC Beans</display-name>
<enterprise-beans>
<session>
<display-name>TaskList</display-name>
<ejb-name>TaskList</ejb-name>
<home>mil.army.atsc.atia.itc.ejb.interfaces.TaskListHome</home>
<remote>mil.army.atsc.atia.itc.ejb.interfaces.TaskList</remote>
<ejb-class>mil.army.atsc.atia.itc.ejb.TaskListBean</ejb-class>
<session-type>Stateful</session-type>
<transaction-type>Bean</transaction-type>
<ejb-ref>
<ejb-ref-name>Task</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<home>mil.army.atsc.atia.itc.ejb.interfaces.TaskHome</home>
<remote>mil.army.atsc.atia.itc.ejb.interfaces.Task</remote>
<ejb-link>Task</ejb-link>
</ejb-ref>
<resource-ref>
<res-ref-name>java:/OracleDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</session>
<session>
<display-name>CourseList</display-name>
<ejb-name>CourseList</ejb-name>
<home>mil.army.atsc.atia.itc.ejb.CourseListHome</home>
<remote>mil.army.atsc.atia.itc.ejb.CourseList</remote>
<ejb-class>mil.army.atsc.atia.itc.ejb.CourseListBean</ejb-class>
<session-type>Stateful</session-type>
<transaction-type>Bean</transaction-type>
<resource-ref>
<res-ref-name>java:/OracleDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</session>
<entity>
<display-name>Task</display-name>
<ejb-name>Task</ejb-name>
<home>mil.army.atsc.atia.itc.ejb.interfaces.TaskHome</home>
<remote>mil.army.atsc.atia.itc.ejb.interfaces.Task</remote>
<ejb-class>mil.army.atsc.atia.itc.ejb.TaskBean</ejb-class>
<persistence-type>Bean</persistence-type>
<prim-key-class>mil.army.atsc.atia.itc.ejb.TaskPK</prim-key-class>
<reentrant>False</reentrant>
<primkey-field>taskId</primkey-field>
<resource-ref>
<res-ref-name>java:/OracleDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</entity>
</enterprise-beans>
</ejb-jar>
Here is my JBOSS.XML file that is packaged in the ejb jar
<?xml version="1.0" encoding="Cp1252"?>
<jboss>
<resource-managers>
<resource-manager res-class="org.jboss.ejb.deployment.JDBCResource">
<res-name>java:/OracleDB</res-name>
<res-jndi-name>OracleDB</res-jndi-name>
</resource-manager>
</resource-managers>
<enterprise-beans>
<entity>
<ejb-name>Task</ejb-name>
<jndi-name>Task</jndi-name>
</entity>
<secure>false</secure>
</enterprise-beans>
</jboss>
Here is my JAWS.XML file that is packaged in the ejb jar
<?xml version="1.0" encoding="UTF-8"?>
<jaws>
<datasource>OracleDB</datasource>
<type-mapping>Oracle</type-mapping>
<default-entity>
<create-table>false</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
</default-entity>
<type-mappings>
<type-mapping>
<name>Oracle</name>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(256)</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.sql.TimeStamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>FLOAT</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>JAVA_OBJECT</sql-type>
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
</type-mapping>
</type-mappings>
</jaws>
Any ideas
Dave Bolt
ATSC/SPAWAR ASAT Team
Bolt's Law of Bandwidth - There is always plenty of network bandwidth, just none for you.
-----Original Message-----
From: Aaron Mulder [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 10:49 PM
To: jBoss
Subject: Re: [jBoss-User] Problem with Oracle Connection Pool in BMP
entity bean
This stack trace is caused by an uncaught exception within Oracle,
which is pretty frightening. It looks like you're using the native Oracle
XA implementation. Are you sure you're using the Oracle Xid as well
(setting in jboss.properties)? What version of Oracle and the JDBC
drivers are you using?
Aaron
On Thu, 7 Dec 2000, Bolt, Dave wrote:
> I get the following Stack Trace
>
> [Task] java.sql.SQLException: ORA-29532: Java call terminated by uncaught
> Java exception: java.lang.NullPointerException
> ORA-06512: at "SYS.JAVA_XA", line 0
> ORA-06512: at line 1
>
> [Task] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
> [Task] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
> [Task] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
> [Task] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
> [Task] at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
> [Task] at
> oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313
> )
> [Task] at
> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)
> [Task] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1
> 353)
> [Task] at
> oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
> [Task] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
> :1805)
> [Task] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
> ment.java:320)
> [Task] at
> oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.j
> ava:364)
> [Task] at
> oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:102)
> [Task] at org.jboss.tm.TxCapsule.startResource(TxCapsule.java:1020)
> [Task] at org.jboss.tm.TxCapsule.enlistResource(TxCapsule.java:593)
> [Task] at
> org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:114)
> [Task] at
> org.jboss.minerva.factories.XAConnectionFactory.prepareObject(XAConnectionFa
> ctory.java:254)
> [Task] at org.jboss.minerva.pools.ObjectPool.getObject(ObjectPool.java:539)
> [Task] at
> org.jboss.minerva.datasource.XAPoolDataSource.getConnection(XAPoolDataSource
> .java:169)
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
