aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with return values from SP