Re: Map from id->list

2006-08-14 Thread Clinton Begin
It might take some trial and error, but you might be able to get it to work.You may need to use groupBy and a second resultMap, even though you're only using primitives.  This will aggregate the external ids beneath the unique types.  Map the whole thing to a hashmap.  Initially this will get you a

Re: Updating from ibatis 1.3.1 to 2.1.7 .. should I? Does it worth the effort?

2006-08-14 Thread Clinton Begin
You can set it with the resultSetType attribute of the element.PS:  2.2.0 is coming out in a few days.  Feel free to continue your upgrade efforts, as it will be compatible, but I'd suggest going to production with 2.2.0 (after testing of course).Cheers,ClintonOn 8/14/06, David Gagnon <[EMAIL PRO

Map from id->list

2006-08-14 Thread Daniel Pitts
I have a table that looks something like this: external_maps Parent externalId type 1 1 1 1 2 1 1 3 1 1 8 2 1

RE: sproc call / long / empty value

2006-08-14 Thread Reuben Firmin
You are right, Jeff... this was a sproc-being-out-of-sync-with-documentation issue. *Now* it's a numeric field, and we're passing 0 for defaults.   Tnx  -Original Message-From: Jeff Butler [mailto:[EMAIL PROTECTED]Sent: Monday, August 14, 2006 12:27 PMTo: user-java@ibatis.apache.org;

Re: sproc call / long / empty value

2006-08-14 Thread Jeff Butler
Well even the iSeries nuts know the difference between a string and a number. :-)   What's the procedure expecting - number or string?   Jeff Butler  On 8/14/06, Larry Meadors <[EMAIL PROTECTED]> wrote: Those crazy iSeries nuts...don't they curse at you for calling it an AS/400?Anyway, I guess I'd

Re: sproc call / long / empty value

2006-08-14 Thread Larry Meadors
Those crazy iSeries nuts...don't they curse at you for calling it an AS/400?Anyway, I guess I'd try 0, but if that's a valid value (i.e., not the same as "empty" or "null"), then I'd try it as a String. LarryOn 8/14/06, Reuben Firmin <[EMAIL PROTECTED]> wrote: I didn't write the sproc. Don'

RE: sproc call / long / empty value

2006-08-14 Thread Reuben Firmin
I didn't write the sproc. Don't ask me :D   It is acceptable in AS400-land - I guess the question boils down to: what is the least terrible hack on the DAO/Ibatis side of things? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Larry MeadorsSen

Re: sproc call / long / empty value

2006-08-14 Thread Larry Meadors
I am confused..what is an "empty" number?LarryOn 8/14/06, Reuben Firmin <[EMAIL PROTECTED] > wrote: How do I pass an empty value into a java.lang.Long field for a sproc? Null is not acceptable on the sproc side of things, and Ibatis won't take "".   My sproc definition is:     {call TEST3

sproc call / long / empty value

2006-08-14 Thread Reuben Firmin
How do I pass an empty value into a java.lang.Long field for a sproc? Null is not acceptable on the sproc side of things, and Ibatis won't take "".   My sproc definition is:     {call TEST3SQL(?, ?, ?, ?)}   and the params are:   id="testParams" class="map">     />      

Re: abator: dynamic where clause

2006-08-14 Thread Jeff Butler
There's no way to do this with Abator generated queries...yet...   Right now with Abator you can only do one LIKE clause in the dynamic where clause.   With the next version of Abator you'll be able to do multiple LIKE clauses or'd together in the dynamic where clause (you'll be able to generate vi

abator: dynamic where clause

2006-08-14 Thread Thomas Karl Schwaerzler
hello again, i'd like to do something like the following, a 'dynamic where clause': public List search( long groupId, String criterion, List columns ) { String where = ""; while (existsNext) { column = (String) i.next(); where += column + " LIKE '%" + criterion + "%'"; if

Re: Updating from ibatis 1.3.1 to 2.1.7 .. should I? Does it worth the effort?

2006-08-14 Thread David Gagnon
Hi, Thanks for the help! I will then ;-) I'm using 1.5 so this shouldn`t be a problem. Maybe another question that you may answer since your know well all the db stuff. I came to the idea of upgrading ibatis because I tried to upgrade my postgresql jdbc driver. I get this exception: DE

Re: Exception while setting properties

2006-08-14 Thread Nathan Maves
Eugeny that is why I asked what jdk you are using.  If you can run java 1.5 you will not have these issues. nathanOn 8/14/06, Larry Meadors <[EMAIL PROTECTED]> wrote: Ahh, yeah, you can't set an int to null, if the values can be null, they have to be Integer instead.Larry On 8/14/06, Eugeny N Dzhu

Re: Exception while setting properties

2006-08-14 Thread Larry Meadors
Ahh, yeah, you can't set an int to null, if the values can be null, they have to be Integer instead.LarryOn 8/14/06, Eugeny N Dzhurinsky < [EMAIL PROTECTED]> wrote:On Mon, Aug 14, 2006 at 09:38:02AM -0600, Larry Meadors wrote: >>The simplest solution is for you to make the setters for the>p

Re: Exception while setting properties

2006-08-14 Thread Nathan Maves
what version of the jdk are you using? can you post the sqlmap as well as the set/get method of the property that you are having issues with? On 8/14/06, Eugeny N Dzhurinsky <[EMAIL PROTECTED]> wrote: On Mon, Aug 14, 2006 at 09:38:02AM -0600, Larry Meadors wrote:>>The simplest solution is for

Re: Exception while setting properties

2006-08-14 Thread Eugeny N Dzhurinsky
On Mon, Aug 14, 2006 at 09:38:02AM -0600, Larry Meadors wrote: > >The simplest solution is for you to make the setters for the >properties on com.project.Entity.Task not throw NPEs. ;-) The thing is I don't have methods whch are throwing MPEs. I found such thing happens when setProperty(i

Re: Updating from ibatis 1.3.1 to 2.1.7 .. should I? Does it worth the effort?

2006-08-14 Thread Clinton Begin
YES! CONCURE!!!   ;-)David:  Are you using JDK 1.4 or greater?Cheers,ClintonOn 8/14/06, Nathan Maves < [EMAIL PROTECTED]> wrote:I even *concur* :) On 8/14/06, Nathan Maves <[EMAIL PROTECTED] > wrote: I concure.  Please upgrade and let us know if you have any problems. nathan On 8/14/06, Jeff Butle

Re: Re: Multiple Result Set Support complete, 2.2.0 will fly within a week

2006-08-14 Thread Clinton Begin
Not really.  But here's a quick personal take:  * Turn invalid the JDBC 4.0 "Ease of Development API" by kicking the living snot out of it.  * Make laughable the Microsoft DLINQ API.  * Bring to the enterprise the ways of Ruby without ActiveRecord.   * Remain a good neighbour to Spring, Hibernate a

Re: Exception while setting properties

2006-08-14 Thread Larry Meadors
The simplest solution is for you to make the setters for the properties on com.project.Entity.Task not throw NPEs. ;-)It looks like most of the places where we are setting properties are reporting the property that causes the erros, but some are not - for example, the CGLIB version (EnhancedPropert

Re: Updating from ibatis 1.3.1 to 2.1.7 .. should I? Does it worth the effort?

2006-08-14 Thread Nathan Maves
I even *concur* :)On 8/14/06, Nathan Maves <[EMAIL PROTECTED]> wrote: I concure.  Please upgrade and let us know if you have any problems. nathan On 8/14/06, Jeff Butler <[EMAIL PROTECTED] > wrote: You can use the Ant task to upgrade your sql maps, or just a find/replace.  On one project with abou

Re: Updating from ibatis 1.3.1 to 2.1.7 .. should I? Does it worth the effort?

2006-08-14 Thread Nathan Maves
I concure.  Please upgrade and let us know if you have any problems. nathan On 8/14/06, Jeff Butler <[EMAIL PROTECTED]> wrote: You can use the Ant task to upgrade your sql maps, or just a find/replace.  On one project with about 80 result maps I did it with find/replace - it's pretty easy.   The o

Re: Updating from ibatis 1.3.1 to 2.1.7 .. should I? Does it worth the effort?

2006-08-14 Thread Jeff Butler
You can use the Ant task to upgrade your sql maps, or just a find/replace.  On one project with about 80 result maps I did it with find/replace - it's pretty easy.   The only real issue we had with upgrading that project is that iBATIS 2.x will throw an exception if you execute a queryForObject but

Exception while setting properties

2006-08-14 Thread Eugeny N Dzhurinsky
Would it be a better idea to explain exceptions like NullPointerException when setting some property and inform which method on the business object was executed? Because I don't see any help of: ERROR com.project.Builder.DBTaskBuilder - com.ibatis.common.jdbc.exception.NestedSQLException: -

Updating from ibatis 1.3.1 to 2.1.7 .. should I? Does it worth the effort?

2006-08-14 Thread David Gagnon
Hi all, I've been working with ibatis for several years but because version 1.3+ wasn't supporting multiple datasource in the sqlmap I didn't update since this time:-( I don't have this limitation anymore and I wonder if the upgrade worth the effort. I probably have arroud 60 sql maps. I

Re: Re: Multiple Result Set Support complete, 2.2.0 will fly within a week

2006-08-14 Thread Jerome Gagner
Is there a road map for 3.0 yet? It'd be cool to see :) On 8/14/06, Gwyn Evans <[EMAIL PROTECTED]> wrote: On 13/08/06, Clinton Begin <[EMAIL PROTECTED]> wrote: > > The good news is that I'm on vacation. The bad news is that I spent the > last 6 hours watching the first two extended edition Lord

Re: Multiple Result Set Support complete, 2.2.0 will fly within a week

2006-08-14 Thread Gwyn Evans
On 13/08/06, Clinton Begin <[EMAIL PROTECTED]> wrote: The good news is that I'm on vacation. The bad news is that I spent the last 6 hours watching the first two extended edition Lord of the Rings movies while implementing the Multiple ResultSet support. As a result, to enable it, just set th