You could try using p6spy to see what query(s) iBatis is sending along and if it's what you expect.
http://www.p6spy.com/ -ed On 7/21/05, Greg Day <[EMAIL PROTECTED]> wrote: > > > Hi all > > I have a strange problem, we are using ibatis as our data access layer, and > everything generally goes fine. > I recently added a query, which essentially does a "select * from X where > primary_key = ?" > > This query is very fast (300ms) when run externally through a database > console, or using jdbc, or using direct jdbc inside jboss. even using the > same connection as ibatis. But... when I run it using ibatis, it takes 4-5 > seconds... > > now, I stepped through the ibatis code, and everything is fast up to the > point of ps.execute (where the prepared statement is executed), then > everything stops for 4-5 seconds while the query is executed. > > Huh? Im doing exactly the same, executing a prepared statement with my jdbc > version, so what is going on? Im very confused, I don't even know where to > start looking. If anyone has any ideas.... they would be gratefully > received. > > Thanks! > Greg
