Win a copy of Real-World Software Development: A Project-Driven Guide to Fundamentals in Java this week in the Agile and Other Processes forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Liutauras Vilda
  • Knute Snortum
  • Bear Bibeault
Sheriffs:
  • Devaka Cooray
  • Jeanne Boyarsky
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • salvin francis
Bartenders:
  • Tim Holloway
  • Piet Souris
  • Frits Walraven

Issue calling a stored procedure from Weblogic 8.1 workshop project

 
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I have one stored procedure, which takes one input parameter and second is output parameter. When I call the stored procedure using DAO design pattern inside weblogic 8.1 workshop proejct, it is failing and giving me below exception,

"Incorrect parameter bindings for stored procedure call.Check your bindings against the stored procedure parameters."

Surprisingly, when I call the same stored procedure using a stand alone java class(inside which I am creating a database connection, callable statement, setting the in parameter and the registering the output parameter and executing the callable statement) it is working fine and giving me the output.

Thanks & Regards
Ashwin
 
Bartender
Posts: 6663
5
MyEclipse IDE Firefox Browser Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please mention

Database name
Database version
Driver version
Driver name
Driver type
XA Vs Non XA connection
If Non XA what TX does it use
What is the TX setting of the stored procedure. Chained Vs unchained.
 
Ash Kondhalkar
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Deepak,

It worked. Thank you for asking me below questions. I found that in standalone java class I was using Oracle's database driver while in the weblogic 8.1 datasource I was using BEA weblogic's database driver class. After I changed by datasource driver class to Oracle driver classs it worked.

Thanks a lot once again.
Regards
Ashwin
 
Deepak Bala
Bartender
Posts: 6663
5
MyEclipse IDE Firefox Browser Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for sharing the solution. There are known problems with some driver types for Oracle / Sybase.
 
Yeah, but is it art? What do you think tiny ad?
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!