SQL Server 2000 and returning results

[R Ray]

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.

 proc = connection.prepareCall("{? = call MY_sp_InsMY_History(?, ?, ?, ?, ?, ?, ?, ?) }");
		       proc.registerOutParameter(1, java.sql.Types.INTEGER);
		       proc.registerOutParameter(2, java.sql.Types.INTEGER);
		       BigDecimal bd = new BigDecimal(5028051);
		       proc.setBigDecimal(3,bd);
		       BigDecimal bd2= new BigDecimal(685720);
		       proc.setBigDecimal(4, bd2);
		       BigDecimal bd3= new BigDecimal(105);
		       proc.setBigDecimal(5, bd3);
		       Timestamp ts = Timestamp.valueOf("2010-03-04 15:02:30.123"); 
		       proc.setTimestamp(6, ts);
		       Timestamp ts2 = Timestamp.valueOf("2010-03-04 15:02:30.123"); 
		       proc.setTimestamp(7, ts2);
		       proc.setString(8, "TestText");
		       proc.setInt(9, 0);

		       int result  = proc.executeUpdate();

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]

my problem is solved.....

		 int success  = proc.executeUpdate();
		       
		       

		if (success==1) {
		int resultCode = proc.getInt(1);
	                BigDecimal history_key = proc.getBigDecimal(2);
	                System.out.println("Generated result code: " + resultCode);
	                System.out.println("Generated history key: " + history_key);
                                }