tag:blogger.com,1999:blog-6402887293870911985.post8317768739998380211..comments2023-06-19T06:10:58.458-07:00Comments on Richard Chesterwood's Blog: Decent settings for DBCP Connection PoolsRichard Chesterwoodhttp://www.blogger.com/profile/04747758278892300028noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-6402887293870911985.post-59572345749598306572016-05-30T01:36:59.652-07:002016-05-30T01:36:59.652-07:00@Yogendra Joshi, as you mentioned you are using IB...@Yogendra Joshi, as you mentioned you are using IBM JDK 7.0, but have you checked https://commons.apache.org/proper/commons-dbcp/index.html for dbcp1.4 they mentioned to use JDK 6.Anonymoushttps://www.blogger.com/profile/12184364055519197401noreply@blogger.comtag:blogger.com,1999:blog-6402887293870911985.post-54266730031224125182016-05-20T09:18:17.681-07:002016-05-20T09:18:17.681-07:00Yes, I am on Oracle 11g and running the batch unde...Yes, I am on Oracle 11g and running the batch under IBM JDK 7.0.Yogendra Joshihttps://www.blogger.com/profile/16221715645854794743noreply@blogger.comtag:blogger.com,1999:blog-6402887293870911985.post-13396010247139508442016-05-20T04:46:39.740-07:002016-05-20T04:46:39.740-07:00Could be worth a try, but the oracle/net/ns is a c...Could be worth a try, but the oracle/net/ns is a clue that this may be driver related. Are you on Oracle?<br /><br />A random search on that frame of the stacktrace throws up this link, could be a clue to a fault in the driver:<br /><br />http://www-01.ibm.com/support/docview.wss?uid=swg21670914<br />Richard Chesterwoodhttps://www.blogger.com/profile/04747758278892300028noreply@blogger.comtag:blogger.com,1999:blog-6402887293870911985.post-74387893368838035442016-05-19T21:03:15.444-07:002016-05-19T21:03:15.444-07:00Thanks Richard. We've hit a roadblock where we...Thanks Richard. We've hit a roadblock where we are using Commons DBCP 1.4 with Spring Batch+JSR352 approach. We're processing 10k records, the batch runs smooth for 9983 records, however when the last partition starts, the batch goes into the hang state and shows gives the below error:<br /><br />at java/net/SocketInputStream.socketRead0(Native Method) <br />at java/net/SocketInputStream.read(SocketInputStream.java:161(Compiled Code)) <br />at java/net/SocketInputStream.read(SocketInputStream.java:132(Compiled Code)) <br />at oracle/net/ns/Packet.receive(Packet.java:283(Compiled Code)) <br />at oracle/net/ns/DataPacket.receive(DataPacket.java:103(Compiled Code))<br /><br />Do you think this is related to DBCP and quick test either with DBCP 2.2.1 ( last active release as of Aug-15) OR c3p0 should help eliminate this issue?<br /><br />Thanks in advance.<br />YogendraYogendra Joshihttps://www.blogger.com/profile/16221715645854794743noreply@blogger.comtag:blogger.com,1999:blog-6402887293870911985.post-88329033415825096222016-05-19T13:27:04.304-07:002016-05-19T13:27:04.304-07:00No guarantees, you would need to test the settings...No guarantees, you would need to test the settings on your own workloads. Usual advice these days is to avoid DBCP in any case, try the other mentioned pools first.Richard Chesterwoodhttps://www.blogger.com/profile/04747758278892300028noreply@blogger.comtag:blogger.com,1999:blog-6402887293870911985.post-79074419154136439942016-05-19T10:12:59.187-07:002016-05-19T10:12:59.187-07:00Does these settings also apply to High Volume Batc...Does these settings also apply to High Volume Batch Processing application as well?Yogendra Joshihttps://www.blogger.com/profile/16221715645854794743noreply@blogger.comtag:blogger.com,1999:blog-6402887293870911985.post-23790087825967705052014-06-23T07:00:19.047-07:002014-06-23T07:00:19.047-07:00Hi Perry, I don't have a Tomcat 7 system to ha...Hi Perry, I don't have a Tomcat 7 system to hand, but I'd be surprised if c3po makes use of tomcat-jdbc as they are separate connection pool systems. Their website states a dependency on mchange-commons-java-0.2.7.jar but that's all. Richard Chesterwoodhttps://www.blogger.com/profile/04747758278892300028noreply@blogger.comtag:blogger.com,1999:blog-6402887293870911985.post-76461331208913975182014-06-19T08:42:41.475-07:002014-06-19T08:42:41.475-07:00Just one clarification please - Does CP30 make use...Just one clarification please - Does CP30 make use of tomcat-dbcp.jar(deprecated) or tomcat-jdbc.jar (latest) on a Tomcat ver 7.x server??Perry Rhodanhttps://www.blogger.com/profile/17871603347270071556noreply@blogger.com