Constellio uses Derby by default

[MohanKumar Durairajan]

Hi,

I am using constellio 1.3
I have configured mysql database as per this guidance.

But constellio continue to write data into derby database and throws truncation error
Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'sysadmin-test: Fwd: this is a test message with really a rea&' to length 512.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
    at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:57)
    ... 37 more

I guess constellio gets configuration from persistance_derby.xml. So i removed this file and run the application again. Now the error message was,
INFO [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] (SQLWarnings.java:43) - Database '/var/www/search/searchWorkSpace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/constellio/WEB-INF/db/constellio_derby' not created, connection made to existing database instead.
java.sql.SQLWarning: Database '/var/www/search/searchWorkSpace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/constellio/WEB-INF/db/constellio_derby' not created, connection made to existing database instead.
    at org.apache.derby.iapi.error.SQLWarningFactory.newSQLWarning(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
    at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
    at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
    at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:120)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
    at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
 
I conclude that constellio continue to write data into derby even though mysql was set as default. Is this normal behavior or issue?