Queries JBOSS 323 and Windows Server 2003

[sponiza]

Hi All,

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.

Sponiza

[sponiza]

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.