Re: Trying to use HashMap as a param object for an UPDATE - getting an exception

2008-12-15 Thread Rick
On Sun, Dec 14, 2008 at 11:02 AM, Larry Meadors larry.mead...@gmail.com wrote: On Sat, Dec 13, 2008 at 8:09 PM, Clinton Begin clinton.be...@gmail.com wrote: That said, (to further argue with myself), I actually prefer the flexibility of not typing the statement. It's a sort of duck typing for

Re: Trying to use HashMap as a param object for an UPDATE - getting an exception

2008-12-15 Thread Larry Meadors
No, I meant I almost never have a parameterClass or parameterMap in my mapped statements. I use Map objects a lot for reads, but not often for writes. Larry On Mon, Dec 15, 2008 at 7:38 AM, Rick ric...@gmail.com wrote: On Sun, Dec 14, 2008 at 11:02 AM, Larry Meadors larry.mead...@gmail.com

Array List of Java beans to Stored Procedure

2008-12-15 Thread Naveen Mansur (nmansur)
Hi I require to pass array list of java beans to stored proc If I send ArrayList with primitive data type it works but fails when send objects in arrayList. Error : java.sql.SQLException: Fail to convert to internal representation Any Help pointers appreciated Type Handler

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Corrado Alesso
In data 14 dicembre 2008 alle ore 15:33:40, Corrado Alesso co.ale...@fastwebnet.it ha scritto: Hello everyone, I'm facing a problem with iBatis. [cut] Do you think that this should be filed as an iBatis issue?

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Jeff Butler
No - I have tests running that show this is not an issue. iBATIS will use the order returned from the database. Make sure your SQL has an order by clause containing both id and tag. Jeff Butler On Mon, Dec 15, 2008 at 11:03 AM, Corrado Alesso co.ale...@fastwebnet.it wrote: In data 14

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Corrado Alesso
Thanks for your reply. Yes, the query has an 'order by' on just those two columns. ORDER BY t1.id ASC, t2.tag ASC I can provide some more information to track down the problem... The query has a LIKE clause defined as WHERE LOWER(tag) LIKE LOWER('%$value$%') With pgAdmin I always get the

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Jeff Butler
If you turn on logging, then you can verify exactly what's coming back from the DB. My guess is that something's not quite right in your Service class. groupBy works best when there is a very simple getter/setter for the list. For example, in your Service class you should have something like

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Corrado Alesso
In data 15 dicembre 2008 alle ore 19:07:58, Jeff Butler jeffgbut...@gmail.com ha scritto: If you turn on logging, then you can verify exactly what's coming back from the DB. I will perform some deeper debugging, also in the driver code. My guess is that something's not quite right in your

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Larry Meadors
You may have said this already, I took a quick scan and didn't see - what version of ibatis? If not the latest, can you try it? Larry

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Corrado Alesso
In data 15 dicembre 2008 alle ore 20:29:29, Larry Meadors larry.mead...@gmail.com ha scritto: You may have said this already, I took a quick scan and didn't see - what version of ibatis? If not the latest, can you try it? Larry I'm using iBatis version 2.3.0.677 I'll try the latest

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Nathan Maves
you have yet to give us your complete SQL for this select. That might really help us to help you :) On Dec 15, 2008, at 12:40 PM, Corrado Alesso wrote: In data 15 dicembre 2008 alle ore 20:29:29, Larry Meadors larry.mead...@gmail.com ha scritto: You may have said this already, I took a

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Corrado Alesso
In data 15 dicembre 2008 alle ore 20:45:07, Nathan Maves nathan.ma...@gmail.com ha scritto: you have yet to give us your complete SQL for this select. That might really help us to help you :) Ok, thanks. Actually I trimmed the query because many parts are irrelevant, but this was a

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Larry Meadors
Blargh - CURSE YOU IBM!! It IS an ibatis thing that contributes to it - ibatis strips line feeds from the SQL... Larry On Mon, Dec 15, 2008 at 1:44 PM, Corrado Alesso co.ale...@fastwebnet.it wrote: THE COMMENT. It was the comment in the query. It looks like pgAdmin can digest the comment

Re: iBatis Maven - please update

2008-12-15 Thread Jeff Butler
The newest version is already there: http://repo1.maven.org/maven2/org/apache/ibatis/ibatis-sqlmap/2.3.4.726/ Jeff Butler 2008/12/15 Ondřej Žižka on...@dynawest.cz: Hi, Maven central repository has very old version of iBATIS. Could someone privileged put new version there? Thanks a lot,