I have a question about JBoss performance in querying a database. I have an simple demo application deployed in jboss. There is a simple stateless session bean, that queries a sybase database server and returns an arraylist of primery key - objects.
This arraylist is taken by another stateless session bean, that instantiates entity beans from the arraylist's primerykey - objects. This session bean generates an xml DOM and returns it to a jsp, which transforms it into html.
The Problem is, that querying 25 primarykey - objects into the arraylist takes a average time of 10 seconds. That slows my webapplication down.
Could this be a transaction problem ?
Could be a lot of things. I suggest you start by reading the server logs carefully, and if that doesn't help use a profiler.