A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Setting Array of String to callable statement ?
Joined: Dec 13, 2008
Dec 18, 2008 05:35:00
I want to set array of
to callable statement .
with OracleCallable statement it is easy to do with the help of cstmt.setARRAY()
but i with normal callable statement though it provides us serArray() but we have to create ARRAY object with the help if ArrayDesriptor() which again takes connection io its constructor ...
and it works only if your connection is oracleConnection
but if your connection is other than that OracleConnection (WSJdbcConnection) then it says classcast exception
so i cant use ArrayDescriptor method ...
Is there any other way of pass array to callable statment
Thanks in Advance
SCJP 88% SCWCD 88%SCBCD 88%
I agree. Here's the link:
subject: Setting Array of String to callable statement ?
setArray(...) in DB2
Apache Commons DBCP connection object problem
a little confused!
Conditional 'where' condition
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014