Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT DBF
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.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap