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.