On 23/03/06, Bob <[EMAIL PROTECTED]> wrote:
> ... thinking about it, is that the problem? Can I use a parameterized
> statement when an entire where clause is dynamically generated?
Unfortunately, it seems that that was the problem. Oops.
When I use in the query to go through the E
erverDriver
One other difference is that I am using the driver
net.sourceforge.jtds.jdbc.Driver
I'm also setting up the data source in tomcat's server.xml - but I
guess thats not going to be your problem
Bob
ally created
and can be quite long, but the example which is falling over has just
one entry)
(WTRANS.EVENTCD="ABC" OR WTRANS.EVENTCD="DEF")
... thinking about it, is that the problem? Can I use a parameterized
statement when an entire where clause is dynamically generated?
Bob
te any help or suggestions - I am prepared to
consider anything! I've been really struggling with this and am
stumped at the moment.
Thanks a lot,
Bob Ball
Aha! But it seems like a good approach. What are the chances it will be integrated into a future release of iBatis? Anyone? What attracts us to iBatis is that our SQL, and our mappings, are externalised. Now when we call stored procs / functions, which unfortunately we must in some situatio
Thanks for the help everyone, especially Mike. I'm trying out the approach you suggested where no TypeHandler is required. But something is not working. My data is being inserted OK, but I'm getting nothing back. I've tested my stored func (Oracle 9i) and this works being called from another PL
Thanks, now I see how to convert an oracle ref cursor into a jdbc resultSet. But that kind of defeats the point of using ibatis. Is it possible to take it a step further and map the columns of the resultSet so that iBatis returns me a list of java objects?
Telefonieren Sie ohne weitere Kost
Just read http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions which seems to be a great solution to using ref cursors. Is it possible to call a stored function instead of a stored procedure, and to obtain the cursor as a return value rather than an OUT
g up the wrong tree altogether? Many thanks, Bob
Telefonieren Sie ohne weitere Kosten mit Ihren Freunden von PC zu PC!Jetzt Yahoo! Messenger installieren!
