tag:blogger.com,1999:blog-6416385526593383847.post5900198071003279168..comments2024-03-13T00:53:59.549-04:00Comments on Raastech Blog: Difference between WebLogic Server "DbAdapter" and "Data Source" connection pool parametersAhmed Aboulnagahttp://www.blogger.com/profile/17300393989634195878noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-6416385526593383847.post-53718261891921893642019-02-27T03:09:26.837-05:002019-02-27T03:09:26.837-05:00Hi Ahmed,
We are getting below error, can you ple...Hi Ahmed,<br /><br />We are getting below error, can you please let me know if error is caused because of exhaustion of pool connections of data source or db adapter.<br /><br />Internal Exception: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool DataSource is suspended. Cannot allocate resources to applications. It was suspended at Thu Feb 21 12:45:59 IST 2019 because of 2 consecutive connect failures. Last connect attempt failed at Thu Feb 21 12:46:06 IST 2019 because of weblogic.common.ResourceException: weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: Socket read timed out. Last connection created successfully at Thu Feb 21 12:45:52 IST 2019.Saurabh Jhahttps://www.blogger.com/profile/17127330841558228979noreply@blogger.comtag:blogger.com,1999:blog-6416385526593383847.post-37425605529710262972019-01-24T10:21:35.365-05:002019-01-24T10:21:35.365-05:00So If we are using SOA/OSB Web Service to invoke D...So If we are using SOA/OSB Web Service to invoke Database Procedure or running some Database queries and if we are using DB Adapter (JCA) to connect to Database then <br />SOA/OSB can send max. 1000 concurrent request to JCA (as 1000 JCA Max Capacity) and internally JCA we using Maximum 20 Physical connection to connect to database (as 20 Data source Max Capacity) so for the remaining 980 requesta either will wait or get some error. Is my understanding correct?Jagjeetnoreply@blogger.comtag:blogger.com,1999:blog-6416385526593383847.post-8696860903933520082016-05-22T13:59:15.976-04:002016-05-22T13:59:15.976-04:00Hi Ahmed,
Thanks for the information...
Thanks a...Hi Ahmed,<br /><br />Thanks for the information...<br /><br />Thanks and Regards,<br />Ramesh AAnonymoushttps://www.blogger.com/profile/07058011479465290402noreply@blogger.comtag:blogger.com,1999:blog-6416385526593383847.post-78362799676202499132016-05-22T13:22:09.074-04:002016-05-22T13:22:09.074-04:00In your SOA code, you have no choice but to use th...In your SOA code, you have no choice but to use the DBAdapter.<br /><br />With that being said, reread the section titled "The Explanation" in the blog post which explains the difference. If it's still not clear, let me know. I'll admit it's a bit confusing at first.<br /><br />Thanks.Ahmed Aboulnagahttps://www.blogger.com/profile/17300393989634195878noreply@blogger.comtag:blogger.com,1999:blog-6416385526593383847.post-22637606771665494732016-05-22T13:19:49.348-04:002016-05-22T13:19:49.348-04:00Hi Ahmed,
Could you please explain to me the belo...Hi Ahmed,<br /><br />Could you please explain to me the below Queries.<br /><br />Datasource is also providing the connection to the DB thenwWhy we are using DBAdapter instead of the Datasource in SOA services for connecting to the DB?<br /><br />Thank and Regards,<br />RameshAnonymoushttps://www.blogger.com/profile/07058011479465290402noreply@blogger.comtag:blogger.com,1999:blog-6416385526593383847.post-29971571663404435742016-05-22T13:18:08.456-04:002016-05-22T13:18:08.456-04:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/07058011479465290402noreply@blogger.com