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.