I have a CMP EB. All 3 methods : ejbCreate, ejbPostCreate and ejbStore are called without errors when I call my EB LocalHome's create(Integer i, String s). But when I check the DB, no rows are inserted.
When I try to call the same EB's create() the 2nd time, it throws : javax.ejb.DuplicateKeyException: Entity with primary key 1234 already exists - which is the correct behaviour. But I can't see any rows being inserted.
Anywhere I can check and verify ?
Server : JBoss_4_0_3_SP1 Database : MySQL Server 5.0 EJB : 2.x Java : j2sdk1.4.2_10 J2EE : 1.4
Thanks. [ January 06, 2006: Message edited by: Timothy Toe ]
Seems to be a DB Locking issue...close SQL Server & open it one more time..same hopeless things happen with Access...
Joined: Oct 19, 2002
Thanks for the replies.
In my jbosscmp-jdbc.xml, I have :
When I coded this, I had in mind that the table name in my MySQL DB would be "info_try_eb". I kept on checking on table "info_try_eb" without realising that JBoss had, instead, helped me create a new table by the name of "ebinfoejbname", and inserted the new record there (when I call create).
Why ? Why the new table ?
In fact, I had gotten table "info_try_eb" ready for the CMP EB to use.
Thanks. [ January 12, 2006: Message edited by: Timothy Toe ]