I've modified spring.datasource.hikari.maximumPoolSize values (with differents values 1, 2, 3 and 4) and when the application execute a findAll or a query without the clause WHERE the execution is blockade.
In theory there are 2 free connections but the error returned is:
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
Hi Dmitry, It's true, it's not a problem of licenses, it's a problem of connections:
Before the select: only 1 connection used.
When the project execute the findAll query: Connections used = 5
It seems like a problem with the connection pool manager, it reserves connections for each query and when the connections achieve the maximum the execution is blockade.
go to post
I've modified spring.datasource.hikari.maximumPoolSize values (with differents values 1, 2, 3 and 4) and when the application execute a findAll or a query without the clause WHERE the execution is blockade.
In theory there are 2 free connections but the error returned is:
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
go to post
Hi Warlin! thank you for your answer, I tried modifying the connection pool size to 1, 2 and 3 and the problem continued.
go to post
Sure! You have it available here:
https://github.com/es-comunidad-intersystems/webinar-multimodelo/tree/master/jdbc-jpa-rest
It's a MAVEN project so you only need MAVEN installed in your PC and modify the actions.properties to define the parameters to access to the database.
go to post
Hi Dmitry, It's true, it's not a problem of licenses, it's a problem of connections:
Before the select: only 1 connection used.
When the project execute the findAll query: Connections used = 5
It seems like a problem with the connection pool manager, it reserves connections for each query and when the connections achieve the maximum the execution is blockade.
go to post
Thank you Jonathan for your answer, but I don't find any reference to InterSystemsIRISDialect in any page of Hibernate.
It's mysterious...
go to post
That was!
Thank you for your help and great article!
go to post
I am trying to launch the container from my Windows 10 running the command:
C:\>docker run –it –d –p 53773:53773 –p 54773:54773 –-name iris –-volume durable:/durable –-env ISC_DATA_DIRECTORY=/durable/irissys store/intersystems/iris:2019.1.0.510.0-community
I've modified the ports to avoid problems. But I am getting the following error:
Have I missed anything?
Thank you in advance!