Hi, I have been seaching for similar cases in the forums, but found nothing similar. So please consider the following :
I use the JDBCPkSqlCreateCommand entity command for generating the primary keys for one of my CMP entity beans. In fact, the SQL involved here uses an oracle sequence and some others oracle functions to generate a unique key. Since I can guarantee that the generated PKs will always be unique, I'd like to spare the statement "SELECT COUNT(*) FROM table WHERE table.pk = my_new_generated_pk" before the "INSERT" statement. Moreover, the table the bean is mapped on will have many rows (several millions actually) , so I definitely need to avoid this costly and unnecessary check. So here is my question : How can I do this ? Is there a magic attribute to specify to the JDBCPkSqlCreateCommand entity command or do I have to create my own command class to achieve this ? By the way, I'm using JBoss 3.2.3. Thanks for your advice Gregory View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845196#3845196 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845196 ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
