Re: exception on queryForList with list of Enums

2005-10-28 Thread reubenf
Agh, confused myself. Let me clarify: the exception happens if I call queryForList with a List as the parameter. If I call queryForList with an Enum as the parameter, no problem. > I am passing queryForList an ArrayList of Status, which is an Enum I > defined. I have registered a typeHandler for

exception on queryForList with list of Enums

2005-10-28 Thread reubenf
I am passing queryForList an ArrayList of Status, which is an Enum I defined. I have registered a typeHandler for Status, as previously discussed today on the list. The typeHandler works when querying for a single object. However, when querying for list, it gives the following exception: (See belo

Re: Stored Procedures

2005-10-28 Thread Daniel Henrique Ferreira e Silva
Hi Roberto, Does your procedure return values using OUT parameters or it does it like in a function? If it does that using OUT parameters you have to declare a parameter map, declaring each parameter with their modes (IN, OUT, INOUT). In regard of functions, i guess you should have to use a differ

Re: enums & Ibatis

2005-10-28 Thread Michael Campbell
On 10/28/05, Nathan Maves <[EMAIL PROTECTED]> wrote: > I think this is just what you are looking for. > > http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do > +I+use+a+Custom+Type+Handler+with+complex+property+or+Type+Safe > +Enumeration Whew, for those not wanting to cut/paste

Re: enums & Ibatis

2005-10-28 Thread reubenf
Tiz indeed. Thanks > I think this is just what you are looking for. > > http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do > +I+use+a+Custom+Type+Handler+with+complex+property+or+Type+Safe > +Enumeration > > Nathan > > On Oct 28, 2005, at 1:25 PM, [EMAIL PROTECTED] wrote: > >> A

Re: enums & Ibatis

2005-10-28 Thread Nathan Maves
I think this is just what you are looking for. http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do +I+use+a+Custom+Type+Handler+with+complex+property+or+Type+Safe +Enumeration Nathan On Oct 28, 2005, at 1:25 PM, [EMAIL PROTECTED] wrote: Are there any good strategies for us

enums & Ibatis

2005-10-28 Thread reubenf
Are there any good strategies for using enums w/ Ibatis? Are there plans to directly support them, if not? I have been forcing my enums (which represent valid values of certain columns, e.g. status columns) to have a value(), e.g.: public enum Status { ... COMPLETE { public In

Like query...Char vs. Varchar issue?

2005-10-28 Thread Voorhoeve, Niels {PBG}
I've got a problem with the following config below. I am testing with a UserCostCenterDept object with the userId set as a param. When I pass in an object with the costCenter property set and dept null, it formulates the query but returns no row. On the other hand, if the department is set and

Re: using result maps within result maps

2005-10-28 Thread neilhenry
That is true, but as I am getting a very wide result set from lots of tables and also getting that same data from each table at other times it requires duplication of property mappings. I have moved the select clauses into sql fragments so that I don't have to have them written out multiple times,

Re: Parameter Maps AND dynamic sql at the same time

2005-10-28 Thread Gareth Moorst
Thanks Larry - that sounds like just the thing. I'm a bit confused about inline parameters now though - in the sqlmaps pdf guide, it says that you can specify types and null values using #propertyName:TYPE:NULLVALUE# So if I want to specify an inline parameter with a typehandler and a null val

Re: Parameter Maps AND dynamic sql at the same time

2005-10-28 Thread Larry Meadors
Sure, but since I lied to you once (" I know that dynamic SQL and parameter maps work..." - sorry about that), you may not believe me. ;-) Any attributes that you would put in the parameter map, you can put inline like this:  #myColumn,typeHandlerCallback=someClassOrAlias# Larry On 10/28/05, Gare

Re: Parameter Maps AND dynamic sql at the same time

2005-10-28 Thread Gareth Moorst
So it does... Thanks for clearing that up. That's a bit of an arse as far as my datamodel is concerned though... In that case, as I'm only using Parameter Maps because I need to specify a custom type handler, does anyone know of a way to specify a type handler for a particular column without u

Re: Parameter Maps AND dynamic sql at the same time

2005-10-28 Thread neilhenry
Hi In the iBatis-SqlMaps-2.pdf (page 16) it states: Note! Dynamic mapped statements (described below) only support inline parameters and do not work with parameter maps. Regards Neil Quoting g m <[EMAIL PROTECTED]>: > Well spotted - it appears I pasted the wrong xml > fragment. My mistake. > H

Re: Parameter Maps AND dynamic sql at the same time

2005-10-28 Thread g m
Well spotted - it appears I pasted the wrong xml fragment. My mistake. Here's the correct one, along with the parameter map I'm using. insert into supplierextrastmsupplierextras ( preferredsupplier, contactname, websiteaddress, companyregno, emailaddress, supplier) values (?, ?,

Re: Parameter Maps AND dynamic sql at the same time

2005-10-28 Thread Larry Meadors
There is something else going wrong here.. In the stack trace, it shows this message:   "Check the Supplier.insertSupplierExtras-InlineParameterMap" That tells me that you were running "insertSupplierExtras" with an inline parameter map. But the statement sent was "updateSupplierExtras" with an

Parameter Maps AND dynamic sql at the same time

2005-10-28 Thread Gareth Moorst
Before acting on this e-mail or opening any attachments you are advised to read The Caudwell Holdings group of companies' disclaimer at the end of this e-mail. === I'm trying to write insert/update statements that can have their table dynamical