I`m using Jboss 2.0 Final , Tomcat 3.2 b7 and Oracle 8.1.7 under redhat 7.0.
And I`m having the most entertaining time trying to get data out of the database.
I have configured an XA Datapool as follows.
Some details (XXXX) changed to protect the innocent.
-----
jboss.jcml
-----
<mbean name="DefaultDomain:service=XADataSource,name=AuRA">
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:oracle:thin:@XXXX:1521:XXXX</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>
------
jboss.conf
------
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar" CODEBASE="../
../lib/ext/">
<ARG TYPE="java.lang.String" Value="AuRA">
<ARG TYPE="java.lang.String" Value="oracle.jdbc.xa.client.OracleXADataSource">
</MLET>
-------
Everything looks good on startup - Pool connects - and in oracle I can see a connection in v$session so Jboss is connecting.
However we have a little bean that simply tries to read a table the database equivilent of hello world ;-)
I`m getting this
------------------->O Snip O<---------------
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.ServerException: Transaction rolled back; nested exception is:
javax.ejb.EJBException: Error Executing SQL SELECT USERID, USER_NAME FROM ENDUSE: java.sql.SQLException: Table not found: ENDUSE in statement [SELECT USERID, USER_NAME FROM ENDUSE]
------------------->O Snip O<---------------
Now this table exists and can be accesed via SQL........
Anyone any ideas ? I`m going grey and my girlfriend has forgotten what I look like.......
Thanks in advance,
Graeme Wilson
