Hi,
[EMAIL PROTECTED] wrote:
> I am currently working on getting a fairly complex set of EJB's working in
> JBOSS in fact approx 30 beans (initially) a mixture of BMP and session
> (stateful and stateless).
>
> I am trying to use transaction 'Required' on all the beans and I have 5
> database conection pools setup to a single instance of Oracle 8.1.7 I am
> using the Oracle thin jdbc driver i.e. classes12.zip.
5 database connection pools for the same db?
Why not just use a single pool?
> I have configured the jboss.conf and jboss.properties and jboss.jcml as per
> the JBOSS manual using jboss.xa.xidclass=oracle.jdbc.xa.OracleXid and
> starting the server and deploying my app looks completely clean.
Yes, this seems to be what the 8.1.7 THIN
driver wants.
> What I am getting is all sorts of rollback errors on the JBOSS logs but more
> importantly I am getting some fairly nasty errors in the Oracle .trc files.
The current TM marks a transaction for
rollbackOnly when an XAResource fails
in an unexpected way. XAResource failure
is probably the reason for these
rollback errors.
With the above setup, Jean-Michel
DELSAUX just identified a problem that
occurs when the ninth db connection
is opened in the same transaction.
I suspect this is due to a internal
driver limit being hit because we do
not do a JTA optimization that made
the 8.1.6 driver hang. If you are in
hacking mode and using recent CVS, try
changing org.jboss.tm.TxCapsule line
610 from "if (xidConstructor == null)"
to "if (true)", and see if it helps.
> QUESTION #1: Does anyone out there have a similar config using BMP to the
> 8.1.7 database with the thin driver ?
Your config seems very similar to
Jean-Michel's.
> QUESTION #2: Has anyone had a JBOSS config + app that has caused errors on an
> oracle 8i database i.e. in the .trc files ?
I Don't know.
What kind of errors do you get in
your .trc files?
Best Regards,
Ole Husgaard.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
