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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
