"RapidMiner Server complains that a database connection was closed. How can I re-establish it"

User13

Problem:

JBoss pools SQL connections. When connections are closed for various reasons (errors, timeouts, network problems), it does not realize that this has happens and returns closed connections the next time they are required.

Solution:

Force JBoss to check whether the connection is still live before returning them from the pool. If not, it will re-establish the connection. To achieve this, insert the following into the standalone.xml configuration file (found under standalone/configuration):

<check-valid-connection-sql> sql code</check-valid-connection-sql>

after the XML element

<validate-on-match>true</validate-on-match>

For sql code, insert arbitrary (fast) SQL code like

SELECT 1

or (for Microsoft SQL Server)

SELECT 1 FROM sysobjects

Note that this may very slightly influence performance. You may also want to try setting

<background-validation>false</background-validation>

to

<background-validation>true</background-validation>