Re: mapping flat data int list of objects

2010-01-15 Thread Simone Tripodi
Hi Michael, in both iBatis v2 and v3 there are TypeHandlers, well explained in the user guide manuals. If you're using iBatis2, you can find it on page 30; if you're using iBtais3, you can find it on page 13. Hope this helps, Simo On Thu, Jan 14, 2010 at 10:11 PM, Remijan, Michael wrote: > I ha

Calling MySql function using IBatis 3

2010-01-15 Thread JJ Stuart
Having issues calling below function and retrieving the result. Can some help (esp with XML set up ) CREATE FUNCTION test_function (param int) RETURNS int BEGIN RETURN param + 1; END; Thanks -- View this message in context: http://old.nabble.com/Calling-MySql-function-using

Postgre Cursor mapping

2010-01-15 Thread José Renato
Hi All, I am trying to map a Postgre function using Cursor. The problem is how to map those results. Follows: // --- BEGIN; select * from f_search_sources(#one#,#two#, 'total', 'list'); FETCH

Re: Calling MySql function using IBatis 3

2010-01-15 Thread Guy Rouillier
On 1/15/2010 5:51 AM, JJ Stuart wrote: Having issues calling below function and retrieving the result. Can some help (esp with XML set up ) CREATE FUNCTION test_function (param int) RETURNS int BEGIN RETURN param + 1; END; Have you taken a look at the FAQ on stored procs?

auto type conversion in iBATIS 3?

2010-01-15 Thread Jun Yang
Hi all, I have started to use iBATIS 3 and am loving it! Thanks! I have a question regarding how to do automatic type conversion. In iBATIS 2, if I have "select * from bug where id = #id:NUMERIC#", if the value of id is a string, it's converted to an int automatically. In iBATIS 3, I have yet

Re: auto type conversion in iBATIS 3?

2010-01-15 Thread Clinton Begin
No version of iBATIS has ever actively converted types. If it worked in iBATIS 2, it was strictly by luck. It was never a feature though. You shouldn't need to specify the JDBC type in the example you give though, because it's not nullable (that query would be invalid with a null value). You wou