Do you or anyone else on this list have any suggestions about handling this problem effectively (and portably for different DBs) in 3.0?
Any suggestions would be appreciated. Currently, I'm guessing the only way to accomplish this is to have a separate class which can look up the next value in the sequence. thanks. -javier Dain Sundstrom wrote: > That won't work with CMP. It does work with BMP if you are going that > route. Unknown primary keys are are at the top of the new features > list, so it will be at least a month. > > -dain > > Arthur Wang wrote: > >> I am using auto_increment function of MySql database for primary key of >> entity bean , so I don't need to set pk in ejbCreate, mysql will >> populate pk >> field in the datatbase automatically, but it has following exceptions. >> >> -----Original Message----- >> From: Dain Sundstrom [mailto:[EMAIL PROTECTED]] >> Sent: Friday, June 07, 2002 4:35 PM >> To: [EMAIL PROTECTED] >> Subject: Re: [JBoss-user] Using auto increment of mysql for PK >> >> >> You need to be more specific. What exactly did you try? >> >> -dain >> >> Arthur Wang wrote: >> >> >>> Hi, >>> I tried to use auto_increment for primary key when I create a new entity >>> bean, but there are following exception: >>> >>> --------------------- >>> HTTP ERROR: 500 removing bean lock and it has tx set!; nested exception >>> >> is: >> >>> java.lang.IllegalStateException: removing bean lock and it has tx set! >>> Embedded Exception removing bean lock and it has tx set!; nested >>> exception >>> is: java.lang.IllegalStateException: removing bean lock and it has tx >>> >> set!; >> >>> nested exception is: javax.ejb.TransactionRolledbackLocalException: >>> >> removing >> >>> bean lock and it has tx set!; nested exception is: >>> java.lang.IllegalStateException: removing bean lock and it has tx set! >>> Embedded Exception removing bean lock and it has tx set!; nested >>> exception >>> is: java.lang.IllegalStateException: removing bean lock and it has tx >>> set! >>> ---------------- >>> >>> Any reply would be highly appreciated. >>> thanks >>> >>> >>> Arthur Wang >>> Ensemble Systems Inc. >>> Tel: (604)232-7954 Fax: (604)231-9545 >>> www.ensemble-systems.com >>> >>> >>> >>> _______________________________________________________________ >>> >>> Don't miss the 2002 Sprint PCS Application Developer's Conference >>> August 25-28 in Las Vegas - >>> >> http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink >> >>> _______________________________________________ >>> JBoss-user mailing list >>> [EMAIL PROTECTED] >>> https://lists.sourceforge.net/lists/listinfo/jboss-user >>> >>> >> >> >> >> _______________________________________________________________ >> >> Don't miss the 2002 Sprint PCS Application Developer's Conference >> August 25-28 in Las Vegas - >> http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink >> >> _______________________________________________ >> JBoss-user mailing list >> [EMAIL PROTECTED] >> https://lists.sourceforge.net/lists/listinfo/jboss-user >> >> _______________________________________________________________ >> >> Don't miss the 2002 Sprint PCS Application Developer's Conference >> August 25-28 in Las Vegas - >> http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink >> >> _______________________________________________ >> JBoss-user mailing list >> [EMAIL PROTECTED] >> https://lists.sourceforge.net/lists/listinfo/jboss-user >> > > > > _______________________________________________________________ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas - > http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
