• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Stored Procs & Tools

 
slicker
Posts: 1108
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
"The Hood"
Posts: 8521
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Moved to the JDBC forum.
 
Ranch Hand
Posts: 15304
6
Mac OS X IntelliJ IDE Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 1108
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Just the other day, I was thinking ... about this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic