Suddenly having the error "Unable to acquire JDBC Connection" (works fine in other projects)

[bechir ben rhaiem]

I use jBPM 6.5.0.Final

I was testing on a new project, I can build and deploy it fine. But suddenly, I could not do it and I get this error

Deployment of unit testUni:testingProject:1.0 failed: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection

I was just editing a script task, I didn't touch anything else! I can't understand how this came! even when undo the edit on my script task the same problem is still there.

when I try to build & deploy an other project, in an other organisation unit, it works fine.

What could be the origin of this? it make no sense for me..

[Bibhutibhusan Sahoo]

Hi,

 Unable to acquire JDBC Connection  error comes when the JBPM tries CRUD operation in JBPM product database. While trying, it is unable to connect or connection pool is exhausted.

Check your connection pool min and max size in standalone-full,xml. Possibly increase min size and try but this is not the right solution as you need to figure out why the connection pool is getting  exhausted

Regards | Bibhu

[Amit ninja]

You can check the connection leak using ccm true in datasource.

And check the output of statistics like active , in-use connection and so on.

I am not sure your datasource configuration, if you share it ,we can guide you.

--
You received this message because you are subscribed to the Google Groups "jBPM Usage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-usage+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-usage/8b176098-3e9d-4468-96d6-5faa90bcc761%40googlegroups.com.

[bechir ben rhaiem]

How to increase pool min size? and what it is for? 

[Abhijit Humbe]

To increase minimum pool modify below tag from datasource:

<pool>
      <min-pool-size>1</min-pool-size>
      <max-pool-size>10</max-pool-size>

</pool>

Go through the link for more details on datasource parameters.

Abhijit Humbe

--

You received this message because you are subscribed to the Google Groups "jBPM Usage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-usage+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-usage/2a6bf7fc-da83-48a7-986d-08426b26d5fe%40googlegroups.com.