You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ojb-user@db.apache.org by Gary <gl...@yahoo.com> on 2004/02/20 19:21:59 UTC

SequenceManagerNextValImpl, buildSequence and Managed Connections

We are using WebSphere JTA for managed connection
support with Oracle.

When an insert occurs and the sequence doesn't exist,
the sequence manager code tries to build a sequence on
the database.  However, a commit is done implicitly
after any DDL statement (such as CREATE SEQUENCE). 
This then fails with the following SQLException from
Oracle:

COMMIT is not allowed in a subordinate session

Any way around this (except for creating the sequence
in advance)?

Gary


__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org