Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 54513 invoked from network); 8 Apr 2002 03:37:02 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 8 Apr 2002 03:37:02 -0000 Received: (qmail 6681 invoked by uid 97); 8 Apr 2002 03:36:56 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org Received: (qmail 6665 invoked by uid 97); 8 Apr 2002 03:36:55 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 6654 invoked from network); 8 Apr 2002 03:36:55 -0000 Reply-To: From: "Sudhir Kumar" To: "'Tomcat Users List'" Subject: Problem with SQL Date: Mon, 8 Apr 2002 09:06:46 +0530 Message-ID: <000701c1deae$9cb0e900$4301a8c0@cgsmith.soft.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 In-Reply-To: <01d201c1de95$bdd7e2a0$0300a8c0@babylon> Importance: Normal X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Hi, I have a problem with the SQL Database. I have connected to SQL server through JDBC-ODBC bridge. In the code since i need to fetch the data inside a number of loops one inside the other , i have used 5 different resultset objects , 5 statement onjects and a single connection object. In each loop i am fetching data from different tables. The code is working fine with Oracle 8 and MS Access Database. But SQl is throwing this exception, Can any one help me out...?? The Exception is : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt Thanks in advance.. Sudhir -- To unsubscribe: For additional commands: Troubles with the list: