wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes ejbCreate, ejbPostCreate and ejbStore called but no rows are inserted Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "ejbCreate, ejbPostCreate and ejbStore called but no rows are inserted" Watch "ejbCreate, ejbPostCreate and ejbStore called but no rows are inserted" New topic
Author

ejbCreate, ejbPostCreate and ejbStore called but no rows are inserted

Timothy Toe
Ranch Hand

Joined: Oct 19, 2002
Posts: 156
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 ]
Roger Chung-Wee
Ranch Hand

Joined: Sep 29, 2002
Posts: 1683
After invoking create(), what do you get if you invoke findByPrimaryKey()?


SCJP 1.4, SCWCD 1.3, SCBCD 1.3
sammaiah kyatham
Ranch Hand

Joined: Aug 03, 2003
Posts: 104
did you commit the record?
Shrinivas Mujumdar
Ranch Hand

Joined: Aug 27, 2004
Posts: 328
Seems to be a DB Locking issue...close SQL Server & open it one more time..same hopeless things happen with Access...

Shrinivas
Timothy Toe
Ranch Hand

Joined: Oct 19, 2002
Posts: 156
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ejbCreate, ejbPostCreate and ejbStore called but no rows are inserted
 
Similar Threads
Doubts in BMP Entity Bean
BMP entity bean - create
Entity Bean ejbCreate method
When EB instance goes into Method Ready State
ejbcreate() and ejbStore()