Re: Problem using SelectByExample with TypeHandlerCallback

2008-07-31 Thread Jeff Butler
Try this column override in your (i)abatorConfig: This will cause (i)abator to generate code that explicitly calls the type handler. I'm fairly certain this will solve the problem. Without this, then we're possibly dealing with a limitation in iBATIS. The ByExample dynamic SQL is very

Re: Is there a way using Ibator to do a case-insensitive LIKE compare

2008-07-31 Thread Jeff Butler
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:0

RE: Is there a way using Ibator to do a case-insensitive LIKE compare

2008-07-31 Thread Chris O'Connell
What about a query with something like Select * from table where upper(NAME_COLUMN) like '%input_variable%' From: Robert Glover [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2008 5:10 PM To: user-java@ibatis.apache.org Subject: Is there a way using Ibator to do a case-insensitive L

Is there a way using Ibator to do a case-insensitive LIKE compare

2008-07-31 Thread Robert Glover
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

Problem using SelectByExample with TypeHandlerCallback

2008-07-31 Thread Doug Flex
Hi, I have a problem with Null Pointer Exception when trying to use SelectByExample with enum criteria. I have done the following to seek for answer but have no success yet. Please help! - google - looked through iBatis FAQ - looked through iBatis WIKI - looked thought iBatis mailing archive