JDBC DBF Error quering for new pks in relatedfoundset |
Sebastian Schlatow |
2014-05-15 00:37:38 |
I get the following error with JDBC 4.1 Package for Xbase database Implementation-Version: 5.2.002 on May 08, 2014, but I don't get the error with Implementation-Version: 5.1.207 on March 03, 20.
Error quering for new pks in relatedfoundset
> com.servoy.j2db.persistence.RepositoryException: Connection pool for server boss_db exhausted
Exception Object: com.servoy.j2db.persistence.RepositoryException: Connection pool for server boss_db exhausted
MSG: Connection pool for server boss_db exhausted
is a ServoyException
Errorcode: 227
com.servoy.j2db.persistence.RepositoryException: Connection pool for server boss_db exhausted
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:1620)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1232)
at com.servoy.j2db.server.dataprocessing.Zfb.Za(Zfb.java:3)
at com.servoy.j2db.server.dataprocessing.Zw.Za(Zw.java:1213)
at com.servoy.j2db.server.dataprocessing.Zw.performQuery(Zw.java:1516)
at sun.reflect.GeneratedMethodAccessor240.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Connection pool for server boss_db exhausted
> com.servoy.j2db.persistence.RepositoryException: Connection pool for server boss_db exhausted
> com.servoy.j2db.persistence.RepositoryException: Connection pool for server boss_db exhausted
Exception Object: com.servoy.j2db.persistence.RepositoryException: Connection pool for server boss_db exhausted
MSG: Connection pool for server boss_db exhausted
is a ServoyException
Errorcode: 227
com.servoy.j2db.persistence.RepositoryException: Connection pool for server boss_db exhausted
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:1620)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1232)
at com.servoy.j2db.server.dataprocessing.Zfb.Za(Zfb.java:3)
at com.servoy.j2db.server.dataprocessing.Zw.Za(Zw.java:1213)
at com.servoy.j2db.server.dataprocessing.Zw.performQuery(Zw.java:1516)
at sun.reflect.GeneratedMethodAccessor240.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Connection pool for server boss_db exhausted
> com.servoy.j2db.persistence.RepositoryException: Connection pool for server boss_db exhausted
|
Re:JDBC DBF Error quering for new pks in relatedfoundset |
HXTT Support |
2014-05-15 00:48:37 |
It's strange. Whether it failed to run, or exhaust after run normally a few time?
|
Re:JDBC DBF Error quering for new pks in relatedfoundset |
Sebastian Schlatow |
2014-05-15 00:49:29 |
See also https://support.servoy.com/browse/SVY-6564
|
Re:Re:Re:JDBC DBF Error quering for new pks in relatedfoundset |
Sebastian Schlatow |
2014-05-15 01:10:43 |
The error occurs if I logout from a Servoy Framework solution. Also I get a messsage that there is an "active transaction". See also the Servoy Thread.
|
Re:Re:Re:Re:JDBC DBF Error quering for new pks in relatedfoundset |
HXTT Support |
2014-05-15 04:07:59 |
Checked your error log:
2014-05-14 13:48:05,889 ERROR [pool-7-thread-4] com.servoy.j2db.util.Debug - Throwable [E4C0EED8-A567-4FC8-83CD-F82095E0C71D BOSS]
java.sql.SQLException: connection already closed or transaction in progress
at com.servoy.j2db.datasource.Zo.close(Zo.java:76)
at com.servoy.j2db.util.Utils.closeConnection(Utils.java:1642)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:651)
at com.servoy.j2db.server.dataprocessing.Zfb.Za(Zfb.java:38)
at com.servoy.j2db.server.dataprocessing.Zw.endTransactions(Zw.java:391)
at sun.reflect.GeneratedMethodAccessor374.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2014-05-14 13:49:05,945 ERROR [pool-7-thread-4] com.servoy.j2db.util.Debug - DB Pool for server boss_dbis empty for a while, you need to increase max connection usage (especially when using long transactions) [E4C0EED8-A567-4FC8-83CD-F82095E0C71D BOSS]
It seems that HxttConnection.close() should throw an error, which hasn't processed by Servoy.
|
Re:Re:Re:Re:Re:JDBC DBF Error quering for new pks in relatedfoundset |
HXTT Support |
2014-05-15 05:22:38 |
Tried Servoy Developer. The Smart Client seems normal and Logout is normal too. Failed to recur your issue.
|
Re:Re:Re:Re:Re:Re:JDBC DBF Error quering for new pks in relatedfoundset |
Sebastian Schlatow |
2014-05-15 06:01:07 |
Do you have the Servoy Framework used?
|
Re:Re:Re:Re:Re:Re:Re:JDBC DBF Error quering for new pks in relatedfoundset |
HXTT Support |
2014-05-15 06:14:44 |
I tried Servoy Developer. If possible, you can try to catch the exception:
java.sql.SQLException: connection already closed or transaction in progress
at com.servoy.j2db.datasource.Zo.close(Zo.java:76)
at com.servoy.j2db.util.Utils.closeConnection(Utils.java:1642)
to see what's the reason.
|
Re:Re:Re:Re:Re:Re:Re:JDBC DBF Error quering for new pks in relatedfoundset |
HXTT Support |
2014-05-15 06:17:22 |
Maybe you forget to commit a transaction so that it has been rollbacked?
|
Re:Re:Re:Re:Re:Re:Re:Re:JDBC DBF Error quering for new pks in relatedfoundset |
Sebastian Schlatow |
2014-05-15 09:05:20 |
"Maybe you forget to commit a transaction so that it has been rollbacked?"
How can it be, if I don't get that error with the older driver version?
|
Re:Re:Re:Re:Re:Re:Re:Re:JDBC DBF Error quering for new pks in relatedfoundset |
HXTT Support |
2014-05-16 08:53:39 |
Checked, but failed to find where code modification can result that issue.
According to Sevoy message:
servoy.error.transaction.closedOrInProgress=connection already closed or transaction in progress
You have to using 5.1.207 temporarily util we can recur your issue or received other customer's report.
|