Hi
Is there a way I can modify {call $procedureName$ #params[]# } to include jdbc types also, so that I
can pass null value to database?
Thanks
Nicky
-Original Message-
From: Nicky Jha
Sent: Tuesday, May 25, 2010 11:12 AM
To: 'user-java@ibatis.apache.org'
Subject: RE: Need support for
Hi,
I have looked at some of the examples.
All of them show that we need to get a brand new connection to execute a
procedure with Array as out parameters.
Why do we need a new connection, why can't we just use the one from
pool?
Thanks
Vinaya
This electronic message is intended only
This would be a great time to switch to mybatis and usa a
@SelectProvider to write the query exactly as you need it. I think
that the dynamic SQL tags won't work in this case.
Jeff Butler
On 5/25/10, Nicky Jha wrote:
> Hi
>
> Is there a way I can modify {call $procedureName$ open="(" close=")"
Hi Jeff,
we wanted to switch to myIbatis as we started this project, but we are using
ibatis Spring integration in our project and I think new version of Ibatis is
not completely supported by Spring as of now.For example SqlMapExecutor
executor etc. and we want to run Ibatis wit Spring :(.Can
Sure, but it'll be uglier.
To me, your whole approach/rationale seems odd here... Procedures changing at
runtime like that seems like poor DB practice except for very specific
scenarios, and/or single threaded db usage Then again, I don't know exactly
what you're trying to accomplish. So I
Joe - this is exactly what I was going to write next - good call!
Nicky - you might try Clinton's suggestion, but it will depend on
whether your driver allows setting a null VARCHAR for a DECIMAL
parameter. Some will, some won't.
The @SelectProvider route is the best route if things really need
