File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Stored Procs & Tools Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Stored Procs & Tools" Watch "Stored Procs & Tools" New topic

Stored Procs & Tools

John Dunn
Ranch Hand

Joined: Jan 30, 2003
Posts: 1108
Nature of my project doesn't call for adding/updating from a database. I am only involved in calling stored procs with 10 - 15 different input/output parameters and getting back multiple resultSets with each query. Are there any tools that can aid in this process?

"No one appreciates the very special genius of your conversation as the dog does."
Cindy Glass
"The Hood"

Joined: Sep 29, 2000
Posts: 8521
Moved to the JDBC forum.

"JavaRanch, where the deer and the Certified play" - David O'Meara
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

Well, calling a Stored Procedure in a Database is not much different that adding/updating the data. The only difference is a function that YOU CALL does most of this for you.
I'm not sure what kind of tools you are looking for and it's hard to say what you might want without knowing how you need to call these SP's.
Are you calling them from within a Java App or Web App?
Do you need to call these from outside of a Java app and pass the data back to a Java App or something? Giving us a little more detail about what you are doing might help.
Also, what kind of Database?

GenRocket - Experts at Building Test Data
John Dunn
Ranch Hand

Joined: Jan 30, 2003
Posts: 1108
I guess I was looking for some sort of mapping tool, so I could maybe just set up an xmlMap file for a particular stored proc. So if I add a field to my stored proc I just add a new element to my xml map file OR is an existing field becomes an output field I just change an attribute, etc, etc.
What I'm using now works okay. I'm operating in a web environment and speed is a big issue. With all the object->db mapping talk in the other forum I was just curious if there are other things out there that I haven't stumbled across.
I agree. Here's the link:
subject: Stored Procs & Tools
It's not a secret anymore!