Hi,

I have an entity bean that has a table behind it with only ~1400 records. A normaly 
command line SQL query on this table takes no time to get all the rows back. JBoss 
3.2.3 on Win2000 times out on a 20 minute transaction, however.

The table has a two-part key and no relationships. JBoss keeps putting out the 
following query over and over again to get the data:

SELECT ... FROM ... WHERE (key1 = ? AND key2 = ?) || (key1 = ? AND key2 = ?) ...

Should I tweek a configuration somewhere?

Thanks,
Chad

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3829651#3829651

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3829651


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to