Hmmm, i look at this solution, too. there is one big disadvantage: if the databasebase is access via odbc _and_ jboss i run into trouble. i'm looking for a sequence session bean, because my primary-keys in my tables are generated (by default) by sequences (or by stored procedures). So, is there any example, which shows how to access stored sequences/procedures with jboss?
thanx markus p.s. i read the cmp 2.0 manual 3 weeks ago and i couldn'd find any hints concerning primary-key-generation. perhaps this would be a topic for future releases... * Damon Torgerson <[EMAIL PROTECTED]> [2002-06-14 10:10]: > One solution that is database independent is to use Scott Ambler's High > Low solution. In a nutshell: > > - create a table named primary_keys(key_name varchar, next_value > number/varchar) > - populate the table with the names of your tables > - create a stateless session bean that gets the next_value from your > primary_keys table > - have your entity beans call your session bean to get their next key > value > > If you do a search on google for Scott Ambler (www.ronin.com) you should > find the solution *somewhat* clearer. > > Damon > > On Thu, 2002-06-13 at 08:26, Javier A. Soltero wrote: > > 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 > -- > Ranksix Solutions Inc. > [EMAIL PROTECTED] > 250.514.6616 > > _______________________________________________________________ > > 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
