Hello to all,

i'm working on some basic examples while using JBoss 4.0.4 with EJB3.0 and Oracle 10g as database. With a simple statement such as

 Location tmpLoc = new Location(street, number);
 em.persist(tmpLoc);

From the client I'm getting this error:

Exception in thread "main" java.lang.RuntimeException: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=maric/25, BranchQual=, localId=25] status=STATUS_NO_TRANSACTION; - nested throwable: (javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update)
at org.jboss.aspects.tx.TxPolicy.handleEndTransactionException(TxPolicy.java:198)
at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:180)
at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)
at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:197)

And on the server side this:

17:06:08,147 WARN [JDBCExceptionReporter] SQL Error: 928, SQLState: 42000
17:06:08,147 ERROR [JDBCExceptionReporter] ORA-00928: missing SELECT keyword

17:06:08,147 WARN [JDBCExceptionReporter] SQL Error: 928, SQLState: 42000
17:06:08,147 ERROR [JDBCExceptionReporter] ORA-00928: missing SELECT keyword

This happened after the em.persist() method, judging by the logs, and object creation is also ok.

Why is there a SELECT keyword missing, when I'm using pure tables and this is a INSERT statment (just guessing, since the container is managing that part)

tnx