Error when Exporting Solution in Servoy 3.5.2

Classic Servoy
1

Hi All,

I am getting error when Exporting my Solution. I am using MySQL with Servoy. I am running on Servoy 3.5.2.

com.servoy.j2db.persistence.RepositoryException:
org.apache.commons.dbcp.DbcpException:
com.mysql.jdbc.CommunicationsException: Communications link failure due
to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection timed
out: connect
at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:
156)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569)
at com.mysql.jdbc.Connection.(Connection.java:1485)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:26
6)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverC
onnectionFactory.java:83)
at
com.servoy.j2db.persistence.datasource.n.createConnection(Unknown
Source)
at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown
Source)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjec
tPool.java:816)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSourc
e.java:110)
at
com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown
Source)
at com.servoy.j2db.persistence.Server.a(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Form.getTable(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.develop.i$9.run(Unknown Source)
at com.servoy.j2db.util.aq.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
org.apache.commons.dbcp.DbcpException:
com.mysql.jdbc.CommunicationsException: Communications link failure due
to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection timed
out: connect
at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:
156)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569)
at com.mysql.jdbc.Connection.(Connection.java:1485)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:26
6)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverC
onnectionFactory.java:83)
at
com.servoy.j2db.persistence.datasource.n.createConnection(Unknown
Source)
at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown
Source)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjec
tPool.java:816)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSourc
e.java:110)
at
com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown
Source)
at com.servoy.j2db.persistence.Server.a(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Form.getTable(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.develop.i$9.run(Unknown Source)
at com.servoy.j2db.util.aq.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
com.mysql.jdbc.CommunicationsException: Communications link failure due
to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection timed
out: connect
at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:
156)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569)
at com.mysql.jdbc.Connection.(Connection.java:1485)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:26
6)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverC
onnectionFactory.java:83)
at
com.servoy.j2db.persistence.datasource.n.createConnection(Unknown
Source)
at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown
Source)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjec
tPool.java:816)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSourc
e.java:110)
at
com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown
Source)
at com.servoy.j2db.persistence.Server.a(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Form.getTable(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.persistence.ak.a(Unknown Source)
at com.servoy.j2db.develop.i$9.run(Unknown Source)
at com.servoy.j2db.util.aq.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

** END NESTED EXCEPTION **

Can anyone please help me to sort out the error …

Many Thanks.

2

Is the server valid ? Does it happen every time ?

3

Hi Infop,

Seems MySQL dropped/refused the connection. Do you use Query Validation (select 1;) on all your MySQL connections ?