javax.resource.ResourceException: IJ000453

By -
Issue faced: "ResourceException: IJ000453" due to "No managed connections available within configured blocking timeout (30000 [ms])"


The issue is related to the database connection request timeout.


This was happening due to large number of threads in the thread pool and the total number of possible database connection request which could have been possible at any given time was well above the max connection specified in the configuration if all the threads would have executed (this is valid under heavy traffic conditions).


could suppress this issue by reducing the maximum number of database connections that could be possible from my code base at any given point in time just by decreasing(proportional) the thread count in the pools (by tuning the thread pools, no performance degrade).



Options are:
          - Check if result sets/statements/connections are closed (Do not wait to close them by JBoss)
                    - To check this follow the suggestions by Jesper/Wolf-Dieter Fink
          - Tune your thread pool(s) if you are using
          - Log the number of opened connections using a bat file when you get the exceptionas this could give a rough idea
          - Increase the blocking-timeout-millis (By default 30s; this is not the ideal fix)
          - Increase the number of connections if and only if necessary



-got this solution from  jboss Developer forum

Comments

Post a Comment

Popular posts from this blog

SinglePass Terms of Service

By -
SinglePass Terms of Service It is important that you read this carefully because you will be legally bound to these terms. Your access to and use of the Service is based on your acceptance of and compliance with these Terms. These Terms apply to all users others who access or use the SinglePass application . By accessing or using the Service you agree to be bound by these Terms and accept all legal consequences. If you do not agree to the terms and conditions of this Agreement, in whole or in part, please do not use the SinglePass application . PREAMBLE Whereas The TechSaga (Anand Gunasekaran) has developed a SinglePass system through which it provides Customers with access to save their password or notes in his/her mobile phone or other mobile devices(the “Device”) and comprising of service options, as detailed in the TECHSAGA Mobile Service terms and conditions accessible on the TECHSAGA   Website ( https://outofboundexception.blogspot.com/2019/...
Read more

Jasper Report Viruatization

By -
Image
Jasper Report Viruatization There are certain things to care while implementing the Jasper Reports for huge data-set to handle the memory efficiently, so that the application does not go out of memory. Pagination of the data and use of JRDataSource Viruatization of the report. Problem:- When there is a huge data set, it is not a good idea to retrieve all the data at one time.The application will hog up the memory and you’re application will go out of memory even before coming to the jasper report engine to fill up the data Solution :- To avoid that, the service layer/Db layer should return the data in pages and you gather the data in chunks and return the records in the chunks using JRDataSource interface, when the records are over in the current chunk, get the next chunk until all the chunks gets over Even after returning the data in chunks, finally the report has to be a single file.Jasper engine build the JasperPrint object for this. To avoid the piling up of me...
Read more

JasperReports Tutorial

By -
Image
Jasper Report is an open source java reporting engine, is Java based and doesn't have its own expression syntax. As JasperReports is a Java class library, and is not meant for end users, but rather is targeted towards Java developers who need to add reporting capabilities to their applications Report template Generally the following report layout is followed to generate reports by many of the commercial report generating tools. Following is the description of each element mentioned in the diagram. Element Description title Title contains the title of the report. It appears only once at the very beginning of the report, for example, "Tutorials Point Report". pageHeader PageHeader may contain date and time information and/or organization name. This appears at top of each page. columnHeader ColumnHeader lists the names of those specific fields which you want to display in the report, for example, "Author Name", "Starting Hour", "Finis...
Read more