Re: ResultMap composite key problem

2005-05-19 Thread Stuart Piltch
Clinton Begin clinton.begin at gmail.com writes: That is terribly strange. We have a unit test confirming proper parsingI wonder if the space is giving you trouble? Ours looks like this: result property=favouriteLineItem column={orderId=ORD_ID,lineId=ORD_FAVOURITE_LINE}

[HELP] I can't not type sign in my sqlmap xml file

2005-05-19 Thread Pham Anh Tuan
Hi, I can't not type sign in sql definition xml file, I don't know why, plz help me solve this problem :( select id="getNOFBidding" resultClass="int" parameterClass="string" select COUNT(distinct ITEMID) from SALE where SALESTATUS = 0 and MAXPRICE = 1 and TO_DAYS(NOW()) -

Iterate problem

2005-05-19 Thread Niels Beekman
Hi, I'm using the iterate-tag to loop a list, but I can't find a way to use the current element in attributes of inner tags, when I try the following: iterate property=myList isEqual property=myList[].someProperty compareValue=true $myList[].anotherProperty$ /isEqual /iterate iBATIS

Re: Issue with Firebird 1.5 and dot NET v 2.0 Beta

2005-05-19 Thread German Gonzalez
are you setting the password masterkey that come by default for user sysdba in Firebird DB? On 5/18/05, Sunil Sreedharan [EMAIL PROTECTED] wrote: Hi, Posted below is the complete Error Trace. Server Error in '/WebSite1' Application.

Re: ResultMap composite key problem

2005-05-19 Thread Clinton Begin
That parsing happens in BasicResultMap. http://svn.apache.org/repos/asf/incubator/ibatis/trunk/java/mapper/mapper2/src/com/ibatis/sqlmap/engine/mapping/result/BasicResultMap.java There are 3 prepareXxxParameter methods. One for Primitives, one for DOM and one for Beans. The only one that

A really bad N+1 solution

2005-05-19 Thread Mark Bennett
For your enjoyment here is how I solved the N+1 problem before I turned to iBatis. I'm know that I'm opening myself to major code ridicule. Mark /** * Translates a List of maps into a normailzed structure. Choose any number * of column names and pass them in as an array. The result will be an

Re: ResultMap composite key problem - SOLVED

2005-05-19 Thread Stuart Piltch
Of course it was something simple. After ripping apart my project until it was just one set of bare bones jars and classes and still seeing the error, I restored from cvs, cursed the computer and made some coffee. After a few sips away from the computer, I realized what happened. A quick trip to

RE: [HELP] I can't not type sign in my sqlmap xml file

2005-05-19 Thread Elizabeth Baron
Hi Anh, If I understand what you are saying, you need to use the character in your iBatis map. This is possible by using the CDATA tags. I have included an example below. The only problem I see with CDATA is that you might not be able to use dynamic sql in the future. Does anyone

Re: [HELP] I can't not type sign in my sqlmap xml file

2005-05-19 Thread Ron Grabowski
You can use: lt; Or enclose the text within CDATA: select id=getNOFBidding resultClass=int parameterClass=string ![CDATA[ SELECT * FROM Sale WHERE TO_DAYS(NOW()) - TO_DAYS(SALEDATE) = 15 ]] /select --- Pham Anh Tuan [EMAIL PROTECTED] wrote: Hi, I can't not type sign in sql definition

Re: [HELP] I can't not type sign in my sqlmap xml file

2005-05-19 Thread Brandon Goodin
You have two options... 1) Substitute your with their entity counterparts lt; and gt; Ex. select id=getNOFBidding resultClass=int parameterClass=string select COUNT(distinct ITEMID) from SALE where SALESTATUS = 0 and MAXPRICE = 1 and TO_DAYS(NOW()) - TO_DAYS(SALEDATE) lt;= 15 and

RE: [HELP] I can't not type sign in my sqlmap xml file

2005-05-19 Thread Lieven De Keyzer
use the entity reference lt; instead From: Pham Anh Tuan [EMAIL PROTECTED] Reply-To: ibatis-user-java@incubator.apache.org To: ibatis-user-java@incubator.apache.org Subject: [HELP] I can't not type sign in my sqlmap xml file Date: Thu, 19 May 2005 16:06:08 +0700 Hi, I can't not type sign in

Re: Iterate problem

2005-05-19 Thread Brandon Goodin
What version of ibatis are you using? On 5/19/05, Niels Beekman [EMAIL PROTECTED] wrote: Hi, I'm using the iterate-tag to loop a list, but I can't find a way to use the current element in attributes of inner tags, when I try the following: iterate property=myList isEqual

Re: [HELP] I can't not type sign in my sqlmap xml file

2005-05-19 Thread Brandon Goodin
This is just plain funny. Can you tell that we love the easy questions? Brandon On 5/19/05, Ron Grabowski [EMAIL PROTECTED] wrote: You can use: lt; Or enclose the text within CDATA: select id=getNOFBidding resultClass=int parameterClass=string ![CDATA[ SELECT * FROM Sale WHERE

Re: ResultMap composite key problem - SOLVED

2005-05-19 Thread Clinton Begin
Hmmm..I suppose we could have implemented a better error check therefeel free to put in an Improvement in JIRA. ClintonOn 5/19/05, Stuart Piltch [EMAIL PROTECTED] wrote: Of course it was something simple.After ripping apart my project until it was just one set of bare bones jarsand classes

Future releases

2005-05-19 Thread Chipomho
This is just a question about future releases of IBatis, when is the next release of IBatis? as a user i have one or two ideas/things that i would like to see in the next version how do i contribute? That parsing happens in BasicResultMap.

Re: Future releases

2005-05-19 Thread Brandon Goodin
we do not know when the next version will be out. If you have suggestions then post the ideas on the dev list to see if they are workable ideas. If they are good ideas then you would enter them into the JIRA issue tracker and they will be included with a future release. Brandon On 5/19/05,

Re: Re: Future releases

2005-05-19 Thread Brandon Goodin
Go ahead and post them here. It's better to have some dialog here. Brandon On 5/19/05, Chipomho [EMAIL PROTECTED] wrote: can i have the URL where i can post my ideas. From: Brandon Goodin [EMAIL PROTECTED] Date: 2005/05/20 Fri PM 02:26:10 GMT+12:00 To: