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 SQL Server 2000 and returning results Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Server 2000 and returning results" Watch "SQL Server 2000 and returning results" New topic
Author

SQL Server 2000 and returning results

R Ray
Greenhorn

Joined: Mar 05, 2010
Posts: 6
Okay, this is not a new problem...I am sure of that :-)

I have created a store procedure in SQL Server 2000. The procedure is tested and is working. Now I am attempting to call the procedure and get the results. The results are not a resultset. I have an output parameter and a return code for success.



The issue is I am not able to get any information back from the store procedure but the record is inserted into the database. I am using the latest jar file from jtds.

Any suggestions would be greatly appreciated. I know SQL Server has some funny issues on how to get information back I just have not found a good example that works.

Thanks for reading my post!

Russ
R Ray
Greenhorn

Joined: Mar 05, 2010
Posts: 6
my problem is solved.....

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Server 2000 and returning results
 
Similar Threads
How to store arraylist in xml file
Arithmetic operations with large numbers
BigDecimal issue
Trouble with BigDecimal
Rounding problem