[jboss-user] [JBoss jBPM] - Re: Errors with global transactions on oracle

2007-04-04 Thread freerider
Hi Martin, thanks for your tips. I tried a few drivers 10.2.0.3, 9.2.0.8 and 8.1.7.1. But now it seems that the problem moved a little bit. org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not get table metadata: JBPM_ACTION; bad SQL grammar [???]; nested exception

[jboss-user] [JBoss jBPM] - Re: Errors with global transactions on oracle

2007-04-04 Thread freerider
We just tried it with Oracle 10.2.0.1 and we still get the same error (The jdbc driver has version 10.2.0.3). ORA-02089: COMMIT is not allowed in a subordinate session java.sql.SQLException: ORA-02089: COMMIT is not allowed in a subordinate session Is this still a jdbc driver problem or is

[jboss-user] [JBoss jBPM] - Errors with global transactions on oracle

2007-04-03 Thread freerider
Hi, I'm trying to move an application, which uses jBPM, from Postgres to Oracle 8.1.7. My setup is: JBoss 4.0.3SP1 jBPM 3.1 which uses Hibernate 3.1.2 which is configured by Spring 1.2.7. My problem is, that oracle doens't allow the following SQL in a global transaction: analyze table