B4J Question Error in connecting to server

Hey B4a community i am getting a serious error while connecting to databse COLLECTION WAS MODIFIED ENUMERATION MAY NOT EXECUTE.But for nearly two months the server wasok and up running without any problem but today it show redourceout errors and other things.So i request if anybody could help me out of this problem
 
Yes i had checked it is ok but today it suddenly gives error
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:622)
at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:1076)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Apr 19, 2020 8:55:02 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Failed to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@32eb46ec
java.sql.SQLException: Some resources failed to close properly while closing com.mchange.v2.c3p0.impl.NewPooledConnection@32eb46ec
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:664)
at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheckedOut(NewPooledConnection.java:255)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:622)
at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:1076)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Apr 19, 2020 8:55:02 PM com.mchange.v2.c3p0.impl.NewPooledConnection
INFO: [c3p0] Exceptions occurred while trying to close a PooledConnection's resources normally.
Apr 19, 2020 8:55:02 PM com.mchange.v2.c3p0.impl.NewPooledConnection
INFO: [c3p0] NewPooledConnection close Exception.
com.extendedsystems.jdbc.advantage.ADSException: [iAnywhere Solutions][Advantage JDBC]Client did not read all data sent by server.
at com.extendedsystems.jdbc.advantage.n.a(Unknown Source)
at com.extendedsystems.jdbc.advantage.n.do(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSResultSet.do(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSResultSet.close(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSStmt.close(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSConnection.close(Unknown Source)
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:642)
 
Upvote 0

OliverA

Expert
Licensed User
Longtime User
Upvote 0

Peter Lewis

Active Member
Licensed User
Longtime User
Normally I find things like this happen under certain circumstances
1. Database Corrupt - Use repair tool
2. Automatic update of software / Database
3. Hacked
4. Connectivity ie Firewall rules and line

What you should do is to get a local SQL manager and login to the database (Not thru the online one) and check from where you are if you can see all the data ect

I use this one

but you can also use the Community version of DB Beaver

 
Upvote 0

OliverA

Expert
Licensed User
Longtime User
What database is being used? Sybase?
 
Upvote 0
Yes this is advantage database server .Thanks b4a community for helping.The server was running without any error for 2 months but it stopped today unknowningly...
 
Upvote 0
Hey b4a community i am not getting whats happening with the server it automatically stopped and giving error logs COLLECTION WAS MODIFIED ENUMERATION MAY NOT EXECUTE .Till two months it was ok but today its not working.
java.sql.SQLException: Some resources failed to close properly while closing com.mchange.v2.c3p0.impl.NewPooledConnection@b6765a2
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:664)
at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheckedOut(NewPooledConnection.java:255)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:622)
at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:1076)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Apr 20, 2020 12:11:43 PM com.mchange.v2.c3p0.impl.NewPooledConnection
INFO: [c3p0] Exceptions occurred while trying to close a PooledConnection's resources normally.
Apr 20, 2020 12:11:43 PM com.mchange.v2.c3p0.impl.NewPooledConnection
INFO: [c3p0] NewPooledConnection close Exception.
com.extendedsystems.jdbc.advantage.ADSException: [iAnywhere Solutions][Advantage JDBC]Client did not read all data sent by server.
at com.extendedsystems.jdbc.advantage.n.a(Unknown Source)
at com.extendedsystems.jdbc.advantage.n.do(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSResultSet.do(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSResultSet.close(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSStmt.close(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSConnection.close(Unknown Source)
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:642)
at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheckedOut(NewPooledConnection.java:255)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:622)
at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:1076)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Apr 20, 2020 12:11:43 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Failed to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@2f4027d1
 
Upvote 0
Top