Re: how to prevent hard parses in oracle

2008-02-18 Thread Larry Meadors
Hmm, I think that may include both hard and soft parses. If an application is using bind variables, then only the first execution is a hard parse, and subsequent executions are soft parses. This page shows a (gnarly) SQL statement to show this (I think): http://www.oracle.com/technology/oramag/c

Re: Is there a way to make MyClassExample searches from Abator case insensitive?

2008-02-18 Thread Jeff Butler
It is possible with the 1.0 version, but you have to modify the generated example classes (e.g. to get rid of the private constructor). It's far easier with the version in SVN. The version in SVN is very stable and is better than 1.0 - you can use it without fear. No version past 1.0 has been re

Re: Is there a way to make MyClassExample searches from Abator case insensitive?

2008-02-18 Thread jcblitz
Is it possible to do with the 1.0 version? I see the Criteria class has a private default constructor so I couldn't override it. I haven't done really any inner class overriding before. Also, the 1.1.0 fairly stable? I tried to use http://svn.apache.org/repos/asf/ibatis/trunk/java/mapper/mapper

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

Re: Abator superclass per table

2008-02-18 Thread Zach Visagie
On Fri, 2008-02-15 at 08:11 -0600, Jeff Butler wrote: > The ability to do this was very recently added to Abator (last week > sometime). If you build Abator from the source in SVN you'll be able > to specify the rootClass property on each table element. > Thanks will have a look!