aspose file tools*
The moose likes JDBC and the fly likes Setting Array of String to callable statement ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Setting Array of String to callable statement ?" Watch "Setting Array of String to callable statement ?" New topic
Author

Setting Array of String to callable statement ?

Devendra Thomare
Greenhorn

Joined: Dec 13, 2008
Posts: 15
HI ,

I want to set array of String 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: http://aspose.com/file-tools
 
subject: Setting Array of String to callable statement ?