Re: Ibatis Mysql Sql error but sql runs fine

2010-04-12 Thread Nate Weiss
I am creating a table dynamically. CREATE TABLE #tableName# ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Hi-- Try $tableName$ rather than #tableName# See page 32 here for more: http://svn.apache.org/repos/asf/ibatis/java/ibatis-2/trunk/ibatis-2-docs/en/iBATIS-SqlMaps-2

Re: how to pass two different types of values to query in IBATIS

2010-04-12 Thread Nate Weiss
On 4/12/2010 10:24 AM, mukhi wrote: Thanks, but the parameter 'entryrefno' is of numeric type in my table. How can i pass two different types of values to Map at the same time? Please reply me. I am struck at this point. If you added that numeric value to your map before you passed it in, li

Re: how to pass two different types of values to query in IBATIS

2010-04-11 Thread Nate Weiss
Hi mukhi-- I'm pretty new to this list, but I believe the general solution is to make a HashMap and pass that in: Map params = new HashMap(); params.entryRefno= myEntryRefno; params.someList = someList; getSqlMapClientTemplate().insert("insertChoice", params); In iBatis 3 you also have the op

Re: Auto-provision of jdbcType for "nullable parameters" case

2010-04-09 Thread Nate Weiss
On 4/9/2010 8:22 PM, Clinton Begin wrote: I've improved this in the next release. While it's not officially released yet, try this: http://people.apache.org/builds/ibatis/ibatis-3-core/ibatis-core-3.0.0-bundle.zip Wow, thank you, I just tested it out and it seems to be working perfectly so fa

Auto-provision of jdbcType for "nullable parameters" case

2010-04-09 Thread Nate Weiss
Hi-- First, really enjoying iBatis 3. Thanks to all who have obviously thought and worked hard on this lovely framework. I am using it in combination with Guice 2.0 at the moment and enjoying it. The only item that is a bit of a nuisance for me right now are situations that result in "JDBC