I have an J2EE application with the next configuration:
JBoss 3.2.4 - Oracle
The oracle driver used in JBoss is "jbosscmp-jdbc3.0". Related with
JBoss configuration we have the next settings:
Commit option type "A": Only JBoss can modify the DB
Methods get are in "read only" status
With this configuration the response after a query is 1 sec/row
As you can see this is a lot, because I´ve about 200 rows, so It´s
taking a lot of time. Could you please say to me how can I improve
(I have installed also JBoss cache but I don´t know exactly how to
manage this one)
Try not using the "read only" status. There have been discussions that this does more bad than good in recent versions.
If that does not work, enable debug logging so you can see the executed SQL statements.