Hi,

I hava 1 error in accessing database using javabean in jsp(jsp custom actions).The error like this

javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt

my source code is given below.Anybody help me??

package SQLBean; 
import java.sql.*; 
import java.io.*; 
public class DbBean implements java.io.Serializable{ 
private String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
private Connection dbCon; 
public DbBean(){ 
super(); 
} 

public boolean connect() throws ClassNotFoundException,SQLException{ 
Class.forName(dbDriver); 
dbCon = DriverManager.getConnection("jdbc  dbc:mybean","",""); 
return true; 
} 
public void close() throws SQLException{ 
dbCon.close(); 
} 
public ResultSet execSQL(String sql) throws SQLException{ 
Statement s = dbCon.createStatement(); 
ResultSet r = s.executeQuery(sql); 
return (r == null) ? null : r; 
} 
public int updateSQL(String sql) throws SQLException{ 
Statement s = dbCon.createStatement();
int r = s.executeUpdate(sql);
return (r == 0) ? 0 : r; 
} 
}
<HTML> 
<HEAD><TITLE>DataBase Search</TITLE></HEAD> 
<BODY> 

<%@ page language="Java" import="java.sql.*" %> 
<%@ page import="SQLBean.*"%> 

<jsp:useBean id="db" scope="application" class="SQLBean.DbBean" /> 

<jsp:setProperty name="db" property="*" /> 

<center> 
<h2> Results from </h2> 
<hr> 
<br><br> 
<table> 

<% 
db.connect(); 
ResultSet rs = db.execSQL("select * from employ"); 
int i = db.updateSQL("UPDATE employ set fname = 'raji' where empno='000010'"); 
out.println(i); 

while(rs.next()) { 
%> 
<%= rs.getString("empno") %> 
<BR> 
<% 
} 
%> 
<BR> 
<% 
db.close(); 
%> 
Done 
</table> 
</body> 
</HTML>

Anyone help me??
Thanx in advance....

I am not completely sure if I know the exact cause but I think SQL server supports only one statement per connection. So, if you want to exeucte another query, you will require a new connection. You might find some information on Microsoft's support page for the driver.

hey try this custom object copy and paste to make your connection to mssql worthy, thanks

<URL SNIPPED>

commented: 1)Opening 4 years old thread; 2)Providing PHP answer instead of Java -2
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.