How to avoid the select before insert with JDBCPkSqlCreateCo

gchazalon Aug 16, 2004 8:05 AM

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

1. Re: How to avoid the select before insert with JDBCPkSqlCrea

aloubyansky Aug 17, 2004 5:18 AM (in response to gchazalon)
Try to add this attribute
<attribute name="SQLExceptionProcessor">jboss.jdbc:service=SQLExceptionProcessor</attribute>
Actions
2. Re: How to avoid the select before insert with JDBCPkSqlCrea

gchazalon Aug 17, 2004 6:01 AM (in response to gchazalon)

It works perfectly, thanks for your valuable advice Alexey :-)

Best regards

Gregory
Actions

Go to original post