Connection is busy with results for another hstmt

Connection is busy with results for another hstmt

I wrote a JSP page to connect to a SQL database. I have about 3 connections for each result set. I receive the error "Connection is busy" with results for another hstmt. Sometimes I receive the error, sometimes I do not. I also would like to know if you have a method to close the database connection.

If you are using ODBC driver, I would recommend switching to a JDBC driver. The ODBC driver does not support multiple statements on a single connection. 

Basically, we allow multiple Statements (think of those are queries for example) to be run on a single Connection (we cache the connection, make it available to other apps/same app, etc.) 

You can download the MS JDBC driver from 

http://www.microsoft.com/downloads/details.aspx?familyid=07287b11-0502-461a-b138-2aa54bfdc03a&displaylang=en 

or another one that seems to work even better is http://jtds.sourceforge.net/ 

As far as closing the connection... Stoneware handles that for you. That is part of the connection caching that we supply. After a period of inactivity, we shut it down, handle the cleanup, etc. for you. This basically protects both the coder from having to do it, and the server from relying on the coder to do it. The connection is left available for other uses by the same app or other apps with the same connection settings.

    Can't find the KB

    Unable to find the KB to address your issue ?  

      • Recent Articles

      • Lenovo Unified Workspace End-of-Life Questions and Answers

        Will the shutdown of LUW servers and access to downloads affect my server licensing? No, the shutdown of the customer servers and access to the product and licensing downloads will not affect your server licensing. This license is downloaded and ...

      • How do I determine my Unified Workspace license expiration date?

        The best method for determining the licensing information including the expiration date of your Unified Workspace license: Login to your 8090 management console on each server This may take remoting into each LUW server and relay, opening a browser, ...

      • Lenovo Unified Workspace 7.0.2.13 Released

        Highlights of Unified Workspace 7.0.2.13 Before you install: Please view the installation notes here. 7.0.2.13 requires a 7.0 license file. Below is a list of enhancements and fixes released in Unified Workspace 7.0.2.13 Fixed external storage ...

      • LanSchool Documentation Guides

        LanSchool Classic Teacher Console The LanSchool Teacher Console is the interface teachers will use to manage their classroom and students. It contains all the tools necessary for a teacher to effectively interact with students and create a ...

      • Lenovo Unified Workspace 7.0.1.41 Released

        Highlights of Unified Workspace 7.0.1.41 Before you install: Please view the installation notes here. 7.0.1.41 requires a 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace 7.0.1.41 Updated Log4j Updated Java Updated ...

      • Related Articles

      • Unable to update schema - problem 5001 ( BUSY )

        The customer is trying to install webnetwork into Microsoft ad and is getting Unable to update the schema. And the following error is displayed: INFO (12/19) 11:01:05 [com.stoneware.service.DirectoryManager]: We are creating an AD connection. FATAL ...

      • Remote Desktop Connection Broker

        Issue: Does Unified Workspace work with Remote Desktop Connection Broker? Solution: Unified Workspace does not currently work with Remote Desktop Connection Broker. Here is a URL on how a Remote Desktop Connection Broker works: ...

      • Midnight - lose connection

        Issue: Sometimes have people working late at night from home on a terminal server session.  At midnight they lose their connection and cannot log back into the webNetwork server.  Could you tell me what could be causing the disconnect at midnight? ...

      • Adding another loader

        First thing to do would be to get the 2nd DMZ relay up and running. 2nd would be to set up the new loader/relay. 3rd would be to adjust the relays to talk to the new loader. After that, adjust the DNS servers and virtual webApps to include the new ...

      • Connection refused to host : 127.0.0.2

        Customer moved loader to a new box. The box was Linux and during the install of linux, it auto added a host file entry for 127.0.0.2 myserver.example-cloud.com This causes the loader to tell the relay that when it comes back to connect to loader use ...