RE: Using Ibats with Group By and sums, etc

2008-04-29 Thread Tracey Annison
Ah, right... that helps! Cheers Tracey Annison _ From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: 28 April 2008 16:39 To: user-java@ibatis.apache.org Subject: RE: Using Ibats with Group By and sums, etc Hi, First, you're using both the resultClass and resultMap attributes

Using Ibats with Group By and sums, etc

2008-04-28 Thread Tracey Annison
do that with the library value... Anyone have a clue what's going on here, or how I shoud proceed for the best? I'm hoping to do all this work in the SQL, rather than with embedded resultMaps and other specific Ibatis features, as this

RE: Data type mismatch with queryForObject, on String property with String value!

2008-02-20 Thread Tracey Annison
Thanks very much for your help! We're hoping we can change the CCSID... :) Cheers Tracey Annison -Original Message- From: j-lists [mailto:[EMAIL PROTECTED] Sent: 20 February 2008 01:47 To: user-java@ibatis.apache.org Subject: Re: Data type mismatch with queryForObject, on S

RE: Data type mismatch with queryForObject, on String property with String value!

2008-02-19 Thread Tracey Annison
y info about so far... Cheers Tracey Annison -Original Message- From: j-lists [mailto:[EMAIL PROTECTED] Sent: 19 February 2008 09:10 To: user-java@ibatis.apache.org Subject: Re: Data type mismatch with queryForObject, on String property with String value! I have encountered something

RE: Data type mismatch with queryForObject, on String property with String value!

2008-02-19 Thread Tracey Annison
r CCSID on a given table? Googling isn't giving me anything... Cheer Tracey Annison _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 February 2008 15:37 To: user-java@ibatis.apache.org Subject: Re: Data type mismatch with queryForObject, on String property with String

RE: Data type mismatch with queryForObject, on String property with String value!

2008-02-15 Thread Tracey Annison
Hiya Thanks for that! I have no clue why it'd throw a wobbly on this file and not all the other near-identical ones, but that gives me somewhere to look... brilliant. Much appreciated! Cheers Tracey Annison _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 February 20

Data type mismatch with queryForObject, on String property with String value!

2008-02-15 Thread Tracey Annison
. I tried adding a definition for the java type and JDBC type in the #transactionCodename#, but it had no effect. Why is it throwing me a NumberFormatException on a field that's a String everywhere? On a file that looks perfectly normal and like all the others? I'm very confused...

RE: Spring, Ibatis, and DBCP commons pooling

2007-09-17 Thread Tracey Annison
xy.jav a:161) at $Proxy52.close(Unknown Source) Cheers Tracey Annison _ From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: 14 September 2007 12:07 To: user-java@ibatis.apache.org Subject: Re: Spring, Ibatis, and DBCP commons pooling If you're using JNDI datasources, then it's

RE: Spring, Ibatis, and DBCP commons pooling

2007-09-14 Thread Tracey Annison
roblem seems to be that when I try to use the database after the AS/400 job dies, the SQLMapClient is still there, tries to use that connection, rejects it, and finds it already closed and an error is thrown... Cheers Tracey Annison -Original Message- From: Meindert [mailto:[EMAIL PROT

RE: Spring, Ibatis, and DBCP commons pooling

2007-09-14 Thread Tracey Annison
100 testOnBorrow true validationQuery select 1 Which is giving the bad results that we see... Cheers Tracey Annison -Original Message- From: charlie

RE: Spring, Ibatis, and DBCP commons pooling

2007-09-13 Thread Tracey Annison
same problems... it seemed to us that having pool settings here, and in the context.xml for apache, was a mistake... ? Cheers Tracey Annison _ From: Meindert [mailto:[EMAIL PROTECTED] Sent: 13 September 2007 15:06 To: user-java@ibatis.apache.org Subject: RE: Spring, Ibatis, and DBCP commons po

Spring, Ibatis, and DBCP commons pooling

2007-09-13 Thread Tracey Annison
veMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java :397) at etc, etc, etc at java.lang.Thread.run(

RE: Problem with using generic and specific custom TypeHandlers

2006-05-17 Thread Tracey Annison
here to denote other lines, "uk." used to denote full path) Take note of the presence & absence of quotes & spaces, and the exact syntax in the TypeHanndler lines in this - THEY ARE IMPORTANT, and it won't work without it being

RE: Problem with using generic and specific custom TypeHandlers

2006-05-15 Thread Tracey Annison
ation about this available? Or any manuals for this product? 'cos now I'm completely stuck, and so is our project... Cheers Tracey Annison -Original Message- From: Tracey Annison [mailto:[EMAIL PROTECTED] Sent: 15 May 2006 08:32 To: user-java@ibatis.apache.org Subject: RE: Proble

RE: Problem with using generic and specific custom TypeHandlers

2006-05-15 Thread Tracey Annison
want to make work on just one field doesn't even get called... Cheers Tracey Annison -Original Message- From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: 15 May 2006 08:32 To: user-java@ibatis.apache.org Subject: RE: Problem with using generic and specific custom TypeHandlers Are

RE: Problem with using generic and specific custom TypeHandlers

2006-05-15 Thread Tracey Annison
ve to re-send. And actually I think you should send them onlist. I've only done that one type handler and it was last year. There are much more experienced folks on the list than me, so you have a better chance of getting help with more eyes. b Tracey Annison wrote: > Hiya, Ben > > Thank y

RE: Problem with using generic and specific custom TypeHandlers

2006-05-12 Thread Tracey Annison
a look at my files & tell me where I'm going wrong, if I sent them to you personally? I'll owe you a favour, if so! Cheers Tracey Annison -Original Message- From: Ben Munat [mailto:[EMAIL PROTECTED] Sent: 11 May 2006 17:01 To: user-java@ibatis.apache.org Subject: Re: Proble

Problem with using generic and specific custom TypeHandlers

2006-05-11 Thread Tracey Annison
as far as I can see, but the TypeHandler doesn't ever get invoked. Is there some special syntax I should be using? Generic TypeHandler in the sql-map-config.xml- And in the thing.xml I can define a ResultMap like this -                 Cheers Tracey Anni