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

      • Change Reset Password Button Text

        Change the text of the "Reset Password" button on the UW Login Page How to change the text of the Reset Password button on the Login Page. Login to webNetwork and open webAdmin on your Relay Central Server Expand Customization Center Expand Tenants ...

      • Remove Reset Password Button From Login Page

        Remove the Reset Password Button from the Login Page How to remove the Reset Password button from the Unified Workspace login page. Login to webNetwork and open webAdmin on your Relay Central Server Expand Customization Center Expand Tenants Expand ...

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

        As of January 31st 2024, Lenovo Unified Workspace (formerly Stoneware WebNetwork) is no longer supported. This means that we no longer provide licenses, downloads, updates, patches, or technical assistance for this product. If you have any questions ...

      • 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 ...

      • 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: ...

      • 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 ...

      • 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? ...

      • How can we authenticate someone and then redirect them to another url ?

        An example:  https://portal.example-cloud.com/index.jsp?redirectTo=http://www.google.com  Will authenticate you to webNetwork and then redirect your browser over to google.com  This is handled in the /stoneware/webserv/index.jsp page. If you are not ...