File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Stored Procs & Tools Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Stored Procs & Tools" Watch "Stored Procs & Tools" New topic
Author

Stored Procs & Tools

John Dunn
slicker
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"
Sheriff

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: 15299
    
    6

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
slicker
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: http://aspose.com/file-tools
 
subject: Stored Procs & Tools
 
Similar Threads
Can I write Java on database-server instead of stored procedures?
MSSQL Stored Procedures to Java objects
JDBC queries or stored procedure
Spring JdbcTemplate issue for calling stored procedure
Java Stored procedure