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

[srbox]

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:
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#3961904

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3961904