[jboss-user] [JBoss Seam] - Example: OneToMany & Composite Key

[umk]

Hello: i'm trying to put together a working Seam example showing a OneToMany relationship using a composite primary key. Something like Order & LineItems from the Java EE 5 tutorial. My attempts have been unsuccessful so I'm hoping someone can tell me where I can find a Seam deployable example that actually works. 

I have tried the Java EE 5 tutorial code (\javaeetutorial5\examples\ejb\order) and it fails with the following (against an Oracle database):

20:56:11,991 INFO  [STDOUT] Hibernate: insert into EJB_ORDER_ORDER (status, lastUpdate, discount, shipmentInfo, orderId) values (?, ?, ?, ?, ?)
  | 20:56:12,084 INFO  [STDOUT] Hibernate: insert into EJB_ORDER_LINEITEM (ORDERID, VENDORPARTNUMBER, quantity, orderId, itemId) values (?, ?, ?, ?, ?)
  | 20:56:12,240 WARN  [JDBCExceptionReporter] SQL Error: 957, SQLState: 42000
  | 20:56:12,240 ERROR [JDBCExceptionReporter] ORA-00957: duplicate column name
  | 
  | 20:56:12,240 WARN  [JDBCExceptionReporter] SQL Error: 957, SQLState: 42000
  | 20:56:12,240 ERROR [JDBCExceptionReporter] ORA-00957: duplicate column name
  | 
  | 20:56:12,240 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
  | org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
  |         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
  |         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  |         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
  |         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

Notice that orderId is listed twice in the second insert statement above?? The code is available here: http://java.sun.com/javaee/5/docs/tutorial/information/download.html

Please help! I really want to use Seam.


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4041606#4041606

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