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."
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?
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.