You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Mark Thomas (JIRA)" <ji...@apache.org> on 2010/06/08 15:24:11 UTC
[jira] Resolved: (DBCP-336) Incorect data from data base if
connection pool size is minimum (say 1 to 3 )
[ https://issues.apache.org/jira/browse/DBCP-336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mark Thomas resolved DBCP-336.
------------------------------
Resolution: Invalid
You appear to have a threading issue in your application. This is not the correct place to get help. Please use the users mailing list.
> 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
> Attachments: dbcpconnectionpooltest.zip
>
>
> 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.