<div>
Sounds to me like you are not closing the connections properly so they are not getting released to the pool. Make sure you are closing the connections in a finally block everywhere.
</div>


Sounds to me like you are not closing the connections properly so they are not getting released to the pool. Make sure you are closing the connections in a finally block everywhere.

<div>
What's a javax.resource.spi.WorkExc<wbr />eption? &nbsp; What causes it?
</div>


What's a javax.resource.spi.WorkException?   What causes it?

<div>
It was a 3rd party jar... &nbsp;<br />
mayanyeagle provided the clue.
</div>


It was a 3rd party jar...  
mayanyeagle provided the clue.

<div>
<div class="content wysiwyg-content">
I'm running a periodic task using the Resin application server. &nbsp;<br />
<br />
The task is supposed to query student data in one table and produce historical data in another table.<br />
<br />
THe task is programmed to run every minute.<br />
<br />
The first time the task runs I get a javax.resource.spi.workExc<wbr />eption: &nbsp;Reentrant Work tasks are not allowed.<br />
The subsequent times the task runs I get a javax.resource.ResourceExc<wbr />eption &nbsp;Connection Pool is full.<br />
<br />
My questions:<br />
What is likely happening here?<br />
What does the Reentrant task exception mean? &nbsp; How can it be prevented?<br />

</div>
</div>


I'm running a periodic task using the Resin application server.  

The task is supposed to query student data in one table and produce historical data in another table.

THe task is programmed to run every minute.

The first time the task runs I get a javax.resource.spi.workException:  Reentrant Work tasks are not allowed.
The subsequent times the task runs I get a javax.resource.ResourceException  Connection Pool is full.

My questions:
What is likely happening here?
What does the Reentrant task exception mean?   How can it be prevented?


Javax.Resource Exception

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

Java Enterprise Edition (Java EE) is a specification defining a collection of Java-based server and client technologies and how they interoperate. Java EE specifies server and client architectures and uses profiles to define technology sets targeted at specific classes of applications. All Java EE profiles share a set of common features, such as naming and resource injection, packaging rules and security requirements.