RE: IBatis 3 Exceptions

2009-12-05 Thread Thijs
We use it. We use an oracle database with some business logic/rules in the SQL triggers. We have defined custom SQL exceptions that are thrown when certain rules fail. Based on the exception code we let the business logic from the application decide if it should show an error or automatically ret

how to prevent hard parses in oracle

2008-02-18 Thread Thijs
Our dba pointed out to me that query's fired by ibatis are constantly being hard parsed by oracle. Even tough the queries that I'm using are constantly the same. An example SELECT a.channel_id, a.object_id, a.name, a.description FROM IndexObject a where a.obj