Hi all,
I'm not sure, but it seems as if though (at least while using Oracle as a
XADatasource) executing DDL within the context of a transaction is not
allowed.
Upon deployment of CMP Beans, I get the following:
[JAWS] java.sql.SQLException: ORA-02089: COMMIT is not allowed in a
subordinate session
[JAWS]
[JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
[JAWS] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
[JAWS] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code)
[JAWS] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java, Compiled
Code)
[JAWS] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
[JAWS] at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java,
Compiled Code)
[JAWS] at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
[JAWS] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1900)
[JAWS] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:363)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleR
esult(JDBCUpdateCommand.java:49)
The tables are created correctly when I comment the code in
org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.java that begins a
transaction before creating a table associated with a CMP Entity Bean (I
additionally have to comment the code that commits the transaction).
Any ideas or comments?
Thanks in advance,
Aakash
p.s. My apologies if this mail is suppose to go the JAWS mailing list, I am
copying it as well.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
