Re: iBatis Dao Setup

2005-04-26 Thread Larry Meadors
Does this class implement the DataSource (javax.sql) interface? If it does, you can set it up as a JNDI DataSource, and configure iBATIS to use it that way. If not...it really should. It is a very simple interface, something like 3 (maybe 6) methods, and buys you a ton of flexibility when

Output parameters with optional result set

2005-04-26 Thread David Whipple
We have a situation that might address a situation that is not handled by iBATIS, but I wanted to describe it here and see if there is something I missed. The situation we have is that there is a (legacy - DB2) stored procedure which has input parameters and output parameters and optionally a

RE: ANSI_PADDING

2005-04-26 Thread Ron Grabowski
How is this an IBatis question? It sounds like you need to contact the database vendor and find out how to turn it off. If you were using straight JDBC, how would you turn padding off? --- Bitra, Venkateswararao (Corporate, consultant) [EMAIL PROTECTED] wrote: We never required to turn it off.

Re: iBatis Dao Setup

2005-04-26 Thread Folashade Adeyosoye
Thanks for the advise, my plan is to actually have 2 implementaions of the code, one would be whatever i have now, unchanged in terms of the how it gets it data and the other, the iBatis route. And my thinking is DAO would basically be the factory that would point to whatever implementation i

Re: CacheModel Cache Removal

2005-04-26 Thread Clinton Begin
The big question here is...how do you intend to identify that object? Cheers, Clinton On 4/26/05, Mike Zupper [EMAIL PROTECTED] wrote: I am using Spring Framework 1.1.5, SQLMaps 2.0 with OSCACHE 2.1. Currently, the FlushOnExecute XML element of the SQLMaps configuration file determines

Re: Output parameters with optional result set

2005-04-26 Thread Clinton Begin
Can you wrap the wacky stored proc with a more predictable one that returns an empty result set every time, so as to avoid the exception? cheers, Clinton On 4/26/05, David Whipple [EMAIL PROTECTED] wrote: We have a situation that might address a situation that is not handled by iBATIS, but I

Re: setUserConnection() does not reset the connection used in SQLMAP

2005-04-26 Thread Clinton Begin
This combination of Tyrex and the Oracle XA driver leave you in a situation where non-standard interfaces are required to make this work. My recommendation to you would be to write your own custom DataSourceFactory implementation. It is a very simple interface. This way you can call the

invalid column type

2005-04-26 Thread Jason Punzalan
this works on mysql but not on oracle. same table layout. any ideas? insert id=insertContent parameterClass=Content ![CDATA[ insert into content(publication, modified_by, priority, source, type_id, body, id, subtitle, title, isFeature, modified, summary, page_id, enabled, created_by,