[jboss-user] [EJB 3.0] - Oracle insert with SELECT missing

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); | anonymous wrote : | 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: anonymous wrote : | 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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3961904#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...