My application runs using JBOSS323. I have JBOSS323 installed on Linux and on a Windows Server 2003. On linux when an entity is searched one SQL query is executed. On the Windows Server 2003 for each searched entity several SQL queries are executed: one for each cmp-field.
The standardjbosscmp-jdbc.xml are in both instances equal.
Is there any other parameter I need to set and may have overlooked on the Windows Server 2003? A simple query does take a lot of time when every cmp-field is retrieved separately.
Thanks for an answer of for a link so that I can investigate further.
Solved the issue myself by setting the commit-option to D in the jboss.xml descriptor. Still curious about what caused the strange behaviour, but I am glad everything runs smoothly now.