B4J Question Error in connecting to server

[SURAJ_PINTU145]

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

 

[Peter Lewis]

Have you tried to Check the database for errors

 

[SURAJ_PINTU145]

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)

 

[OliverA]

Did you recently restore the database? If so, you may want to search the internet with this information as it regards to database restoration. One link: https://stackoverflow.com/questions...meration-operation-may-not-execute-when-resto

 

[Peter Lewis]

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

SQL Manager for MySQL

Simplify and automate your MySQL database development process, design, explore and maintain existing MySQL databases, build compound MySQL query statements, manage MySQL database user rights and manipulate data in different ways.

www.sqlmanager.net

but you can also use the Community version of DB Beaver

DBeaver Community | Free Universal Database Tool

dbeaver.io

 

[OliverA]

What database is being used? Sybase?

 

[SURAJ_PINTU145]

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

 

[SURAJ_PINTU145]

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

 

[Erel]

You need to provide more information. We cannot guess what you are doing.

 

[SURAJ_PINTU145]

Hey b4a commu ity thanks for assiting me i got my answer there was a jdbc version mismatch