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(){ 

public boolean connect() throws ClassNotFoundException,SQLException{ 
dbCon = DriverManager.getConnection("jdbc  dbc:mybean","",""); 
return true; 
public void close() throws SQLException{ 
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; 
<HEAD><TITLE>DataBase Search</TITLE></HEAD> 

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

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

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

<h2> Results from </h2> 

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

while(rs.next()) { 
<%= rs.getString("empno") %> 

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

Edited 6 Years Ago by peter_budo: Just adding tags

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


Edited 6 Years Ago by peter_budo: Keep It On The Site - Posts must contain actual content and substance and cannot simply be external links.

1)Opening 4 years old thread; 2)Providing PHP answer instead of Java
This article has been dead for over six months. Start a new discussion instead.