File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Converting a Store Proc to a Java Function(Class)

 
San Nan
Greenhorn
Posts: 22
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All,

I am having a store proc in backend (SQL Server) & instead of calling the store proc from java program ( through Callable) i want to make a function in java, which can be called without callable....

Please help me to provide solution by providing source code


Thanks


Nan
 
Anonymous
Ranch Hand
Posts: 18944
  • 0
  • send pies
  • Quote
  • Report post to moderator
It seems that you are handling some complicated calculations in Stored Procedures and now intending to achieve it from within Java itself.

Even in the second case, you MUST make at least a SELECT operation in order to get the data over which you will iterate, read, ignore, add , multiply etc. and do your tasks.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic