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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...