In one of our environment, some stored proc uses multiple level table
objects, such as:
TopLevelTable Obj is table of TopLevelObj.
Then in TopLevelObj, it contains variables which is table of some other
objects.
In this kind of multi-level table environment, seems I have to assign
values to
I am wondering whether the plugin could support stored procedure, as I
know ibator does __not___.
if you have equivlent plugin on eclipse, i will be more than happy to
try.
Jack
_
From: Jeff Butler [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 04, 2007 12:48 PM
Yes, ibatis could work with Oracle Object in the table.
If that's output parameter, you could use java.sql.Array to hold
response data.
If it is input, you would need to play some tricks to get Oracle
Connection object and create oracle ARRAY. I am not sure whether that's
the prefer way or not,
I would need to pass Array in the call, but I couldn't find out feasible
way to wrap around my objects to java.sql.Array.
In Oracle, it appears I could use ARRAY to create, but ARRAY object
need ArrayDescriptor which requires access to Connection object, which I
am not sure how to get in the
On 6/5/07, Yu, Jack [EMAIL PROTECTED] wrote:
Hi,
We are trying to handle custom types
(such as Oracle Object), the only way we find out now is to
get the connection instance from
SqlMapper.getDataSource
Hi,
We are trying to handle custom types (such as Oracle
Object), the only way we find out now is to
get the connection instance from
SqlMapper.getDataSource().getConnection(),
and set the typeMap in that connection, and set it back
using