Statements we execute against the database are VERY SLOW INDEED.
The sql is generated by Hibernate. The application server is Webshpere Community Edition. The database is Sql Server 2005. The database driver is the jTDS driver.
If we take the sql generated by hibernate and execute it directly against the database, the query flies along. If we take the sql and execute it as a prepared statement through a jdbc connection, again it flies along. When we use the service that ultimately calls the Hibernate classes, we are waiting in excess of 60 seconds for the query to complete.
Does anyone have any pointers that can help remedy this?