Take a look in the ibator documentation here: http://svn.apache.org/repos/asf/ibatis/trunk/java/tools/ibator/core/htmldoc/generatedobjects/extendingExampleClass.html I describe exactly how to extend the generated example classes to add this functionality.
Jeff Butler On Thu, Jul 31, 2008 at 5:09 PM, Robert Glover <[EMAIL PROTECTED]>wrote: > Disclaimer: I really, really like Ibator and use it in all my > projects. > > A programmer has inherited one of my projects that uses Ibator. He > needs to use Ibator to do some name comparisons on people's names. For > example, a database column might contain a value of "John .J. Hancock". He > wants to use Ibator to do a "LIKE" compare against "%HANCOCK%". > Unfortunately it is Oracle 10i, not MySql. So, no match results because > Oracle is case sensitive. (MySql is not case sensitive). > Short of modifying the java code that Ibator generates, is there any > way using Ibator to do the "LIKE" as if the column in the database > contained "JOHN J. HANCOCK" instead of "John .J. Hancock"? > I realize that one solution would be to create a VIEW of the TABLE > that had the column value upper-cased and then run the VIEW into an IBATOR > generation, but he would prefer not to have to do that. > > Thanks in advance, > Robert (a bit Ibator fan) >