That is true - DDL isn't allowed when you use the Oracle
XADataSource. You can't have JAWS create your tables, you have to
do it manually. This is a limitation of Oracle (you can't rollback a
table create, even in SQL Plus).
Aaron
On Sat, 11 Nov 2000, Aakash Chopra wrote:
> 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]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
