• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored Procs & Tools

 
John Dunn
slicker
Ranch Hand
Posts: 1108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Cindy Glass
"The Hood"
Sheriff
Posts: 8521
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moved to the JDBC forum.
 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
John Dunn
slicker
Ranch Hand
Posts: 1108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic