aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Problem with return values from SP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem with return values from SP" Watch "Problem with return values from SP" New topic
Author

Problem with return values from SP

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I call a stored procedure from my code which returns me an Integer value which is different every time . I am facing a strange problem . When I call the SP sucessively I dont get the updated values , instead I just get the value I got for the first time I called the SP eg . if the SP returned me a val of say 100 then the next successive calls returned me 100 instead of 101, 102.... . This problem has surfaced only after I tried using Atinav ( Type 4 ) and IDS Server( Type 3) Drivers . But the code works fine with JDBC ODBC Bridge .
The DB I use is MSSQL Server. The Server is JRun but even standalone programs give problem .
Can anyone give any clue to this problem
Kunal Aher
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6920
"Kunal P",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.
Thanks.

Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: Problem with return values from SP