Return-Path: 
 <issues-return-13842-apmail-commons-issues-archive=commons.apache.org@commons.apache.org>
Delivered-To: apmail-commons-issues-archive@minotaur.apache.org
Received: (qmail 39445 invoked from network); 7 Jun 2010 13:54:09 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 7 Jun 2010 13:54:09 -0000
Received: (qmail 87813 invoked by uid 500); 7 Jun 2010 13:54:09 -0000
Delivered-To: apmail-commons-issues-archive@commons.apache.org
Received: (qmail 87731 invoked by uid 500); 7 Jun 2010 13:54:08 -0000
Mailing-List: contact issues-help@commons.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@commons.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@commons.apache.org>
List-Post: <mailto:issues@commons.apache.org>
List-Id: <issues.commons.apache.org>
Reply-To: issues@commons.apache.org
Delivered-To: mailing list issues@commons.apache.org
Received: (qmail 87723 invoked by uid 99); 7 Jun 2010 13:54:08 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Jun 2010 13:54:08 +0000
X-ASF-Spam-Status: No, hits=-1502.8 required=10.0
	tests=ALL_TRUSTED,AWL
X-Spam-Check-By: apache.org
Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Jun 2010 13:54:07 +0000
Received: from thor (localhost [127.0.0.1])
	by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o57DrlTx012789
	for <issues@commons.apache.org>; Mon, 7 Jun 2010 13:53:47 GMT
Message-ID: <5889395.1801275918827131.JavaMail.jira@thor>
Date: Mon, 7 Jun 2010 09:53:47 -0400 (EDT)
From: "Rony M Sunny (JIRA)" <jira@apache.org>
To: issues@commons.apache.org
Subject: [jira] Created: (DBCP-336) Incorect data from data base if
 connection pool size is minimum (say 1 to 3 )
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394

Incorect data from data base if connection pool size is minimum (say 1 to 3 )
-----------------------------------------------------------------------------

                 Key: DBCP-336
                 URL: https://issues.apache.org/jira/browse/DBCP-336
             Project: Commons Dbcp
          Issue Type: Bug
    Affects Versions: 1.4
         Environment:  java on linux and sql server 2005  db on windows 
            Reporter: Rony M Sunny



   Environment:
   I have a sp which return data from data base according to a criteria and i put a sleep of 700 millisecond on sp . 
   The connection pool configuration is very minimum compared to data accessing thread, then from multiple java thread i tried to access data for a time period of 30- 60 minute, also i put a query execution time out of 1 second, 

    The result is that
       Some thread have not get any data from db as there is not much available connection to db in pool and can see it from the exception log , it is OK.
     But the problem  is that after some period time (take 30 - 60 min)  data retrieved by  threads are incorrect, means data retrieved is, query result of some other thread.
     
My connection pool configuration is here
-----------------------------------------------------------
  <property name="maxIdle" value="3" description=""/>
                    <property name="poolInitialSize" value="1" description=""/>
                    <property name="testOnBorrow" value="true" description=""/>
                    <property name="maxStmts" value="10" description=""/>
                    <property name="validationQuery" value="SELECT 1" description=""/>
                    <property name="password" value="*****" description=""/>
                    <property name="url" value="jdbc:microsoft:sqlserver://192.168.29.222:1433;           DatabaseName=marketsummary" description=""/>
                    <property name="testOnReturn" value="true" description=""/>
                    <property name="maxActive" value="3" description=""/>
                    <property name="userId" value="***" description=""/>
                    <property name="minIdle" value="3" description="String"/>
                    <property name="maxWait" value="1000" description=""/>
                    <property name="driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" description=""/>

----------------------------------------------------------

Please look in to this
   

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.