aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Callable Statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Callable Statement" Watch "Callable Statement" New topic

Callable Statement

Ranch Hand

Joined: May 29, 2002
Posts: 198
Hi ,
when using Callable statement with parameter names I am getting the exception when setting the parameters.
java.lang.AbstractMethodError: oracle/jdbc/driver/OracleCallableStatement.setString

while I tried to use parameter order no e.g. 1,2 etc it gave compiler error when setting dates

cs.setDate(int, String ) ..

Any workaround.

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 31634

Do you have the Oracle driver (classes12.jar) in your classpath?

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Rajesh Agarwal
Ranch Hand

Joined: Aug 01, 2005
Posts: 79
I dont see a setDate method taking cs.setDate(int, String ) ..
as parameters.

void setDate(String parameterName, Date x)
void setDate(String parameterName, Date x, Calendar cal)

Please let me know incase I am wrong.
Ranch Hand

Joined: May 29, 2002
Posts: 198
Thanks all.

There was difference the jar i was using in build path and run time class path .

I agree. Here's the link:
subject: Callable Statement