Error in getting data from database

[Neeba Rebbaca]

i tried to connect to the database using jdbcdbc connection..
while doing so, its giving me this error,

"Error java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt"

Even though, i close my connection properly...

  
Statement stm = conn.createStatement();
			ResultSet rs = null;

			CallableStatement cs = conn.prepareCall("{call cutoff_ml(?,?,?)}"); 
			cs.setString(1, "tular"); 
			cs.setString(2, "ML0"); 
			cs.setString(3, "ML6"); 
			rs =cs.executeQuery();
			while(rs.next())
			{
				System.out.println(rs.getString(1));
				System.out.println(rs.getString(2));
				System.out.println(rs.getString(3));
				System.out.println(rs.getString(4));
				System.out.println(rs.getString(5));
			}
			
			String qry2 = "select number from grade_tmp where id = '48833d2d-0609-4549-8ecf-873e9165df75' and value is not null";
			rs.close();
			stm.clearBatch();
			ResultSet rs1 = stm.executeQuery(qry2);
			while(rs.next())
			{
				string str = rs.getString(1);
			}
 

where i'm going wrong..

Thanks...

[Jan Cumps]

ResultSet rs1 = stm.executeQuery(qry2);
while(rs.next())

You mixed rs1 and rs.

[Neeba Rebbaca]

i tried to execute a stored procedures from my code..the stored procedure will process and fill data in a table.
When i tried to execute from my code, its not filling any data in the table. but i try
to execute manually its filling data in the table for same set of input...whether my code is correct or am i making mistake else where... Neither i'm not getting any error..

 
CallableStatement cs1 = conn.prepareCall("{call cuttoffvalues(?,?,?,?,?,?,?,?)}"); 
                
                    cs1.setString(1, "'est'"); 
                    cs1.setString(2, "'0'"); 
                    cs1.setString(3, "'12'"); 
                    cs1.setFloat(4, 60f); 
                    cs1.setString(5, "0"); 
                    cs1.setString(6, "'ash'"); 
                    cs1.setString(7, "50"); 
                    cs1.setString(8, "'48833d2d-0609-4549-8ecf-873e9165df75'"); 
                    ResultSet rs = cs1.executeQuery();

					while(rs.next())
					{
						System.out.println(rs.getString(2));
					}

Thank you

[Jan Cumps]

Hi,

Is the first issue solved?

Regards, Jan

[Neeba Rebbaca]

Yes, I solved it.

[Paul Sturrock]

Where do you commit your transaction?

[Neeba Rebbaca]

In sql server there is an auto commit,rite..still added commit...but the result remains the same.Its not filling data in the table.


thank you..

[Paul Sturrock]

In sql server there is an auto commit,rite

You can enable auto commit. Its not on by default, and personally I would not use it.

Have you tried calling executeUpdate in stead of executeQuery? It seems the more appropriate method.