I've previously been told when I was asking about Oracle REF Cursors
that I should be using "update" instead of "queryForList". Technically
"queryForList" doesn't fully work correctly with REF Cursors since the
return list isn't being populated even though the map passed into
"queryForList" does se
ndler
the RowHandler handleRow method never is executed.
Is queryWithRowHandler even supported when mapping to Result Set from an
Oracle Ref Cursor?
Thanks,
Jesse Reimann
I need to regenerate my code with
Abator?
Thanks,
Jesse Reimann
t.sqlExecuteUpdate(ProcedureStatement.java:30)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
... 7 more
From: Andrey Rogov
Sent: Tuesday, March 18, 2008 7:45 PM
To: Jesse Reiman
ssing TIMESTAMP
WITH LOCAL TIME ZONE data
ALTER SESSION SET time_zone = #timezonevalue#
2008/3/17, Jesse Reimann <[EMAIL PROTECTED]>:
I'm trying to retrieve an Oracle column that is defined as TIMESTAMP
WITH LOCAL TIME ZONE. Currently I'm receiv
when using iBATIS (and Spring).
Thanks,
Jesse Reimann
ting
the still empty HashMap to a list and returning that to your method.
queryForList doesn't take an object parameter to store the results in,
it takes an object parameter to pass variables into your queries. The
return value of queryForList is a List of your ResultMapped Models.
-Ryan
On Mon,
Ryan I guess you didn't read my original post. I tried both the Hashmap
method of queryForList and the way you suggested. The only way I can
actually get a populated List back is using the HashMap. If I do it this
way :
return
getSqlMapClientTemplate().queryForList("TEST_TESTPROC.GET_CDDRPT");
Ryan that's exactly what I did that wouldn't work. It returns to me a
List that has 10 elements all which are NULL.
Jesse
Can anyone shed some light on why this is? Is there are way I can change
my parameter settings to have queryForList return a List directly when
calling a ref cursor?
Thanks,
Jesse Reimann
Thanks for the help. I had seen that code example before but not from
the Spring doc so didn't understand the context. After playing with it
for a bit I was able to get some test code working with the batching
using that method.
I don't know if it's my environment config or what but I had to ma
oint me in the right direction?
Thanks,
Jesse Reimann
12 matches
Mail list logo
