Re: Another custom type handler issue

2005-05-17 Thread Ken Katsma
;t support returning arrays. My guess is if you were to have List addresses and List communications (type specification not necessary, just highlighting what its doing) - then iBATIS would "do the right thing". Brice On 5/16/05, Ken Katsma <[EMAIL PROTECTED]> wrote: Now that I ha

Another custom type handler question

2005-05-17 Thread Ken Katsma
I posted this last night but I'm posting it again because I didn't see my mail come through on the mailing list.  Do I have a gmail problem?  Or are users not cc'd on their own posts? Now that I have the custom type handler executing correctly for the nested cursor, I have another question :) I

Re: Custom Type Handler question

2005-05-17 Thread Ken Katsma
re no way to just join the data and return a set of repeating groups >>and use the iBATIS N+1 Selects solution?>>>>http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem%3F >>>>Cheers,>>Clinton>>>>&

Re: iBATIS for Java 2.1.0 Released

2005-05-17 Thread Ken Katsma
Graham, Oracle doesn't support the getResultSet call in it's JDBC drivers.  Though it does appear to be a step in the right direction :) Ken On 5/16/05, Graham Cruickshanks <[EMAIL PROTECTED]> wrote: Hi Clinton,Great news on the 2.1.0 release. I see in the change log "Changed SQLexecutor to alway

Another custom type handler issue

2005-05-17 Thread Ken Katsma
Now that I have the custom type handler executing correctly for the nested cursor, I have another question :) I'm trying to use the custom type handler to populate an array of objects in my class.  For instance, I have a Client, which contains Address[] arrays and Communication[] arrays.  I'd like

Re: Custom Type Handler question

2005-05-16 Thread Ken Katsma
d use the iBATIS N+1 Selects solution?>> http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem%3F>>Cheers, >Clinton>>>On 5/15/05, Ken Katsma <[EMAIL PROTECTED]> wrote:>> >> Hi,>> >> My group

Custom Type Handler question

2005-05-15 Thread Ken Katsma
Hi, My group is currently using stored procedures in Oracle for all our database access.  To get around the n+m problem we are considering several alternatives.  One we know will work is to do a user function for each column that maps to a "m" table that gives us the data in string format (name,va

Custom Type Handler question

2005-05-14 Thread Ken Katsma
Hi, My group is currently using stored procedures in Oracle for all our database access. To get around the n+m problem we are considering several alternatives. One we know will work is to do a user function for each column that maps to a "m" table that gives us the data in string format (name

Re: Oracle function result sets with iBatis

2005-01-15 Thread Ken Katsma
Sure, see my comments through the following I just added a check to see if the database was oracle if (conn.getMetaData().getDatabaseProductName().equalsIgnoreCase("Oracle")) { And if it is, then don't do a query, do an execute boolean b = cs.execute(); errorContext.setMoreInfo("In

Oracle function result sets with iBatis

2005-01-15 Thread Ken Katsma
I think iBatis is a great product, my group was looking to build something that extracted our sql into xml files anyway, and when I found iBatis, I was pretty happy to see all that work has already been done. One thing it can't seem to do right now though is support Oracle result sets from func