Exception in thread "main" dk.netarkivet.common.exceptions.IOFailure: SQL error updating database with sql: ALTER TABLE jobs ADD COLUMN snapshot BOOLEAN
SQLException trace:
SQL State:XCL47
Error Code:20000
java.sql.SQLException: Use of 'BOOLEAN' requires database to be upgraded from version 10.1 to version 10.7 or later.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213)
at dk.netarkivet.common.utils.DBUtils.prepareStatement(DBUtils.java:247)
at dk.netarkivet.common.utils.DBUtils.executeSQL(DBUtils.java:1037)
at dk.netarkivet.harvester.datamodel.HarvestDBConnection.updateTable(HarvestDBConnection.java:167)
at dk.netarkivet.harvester.datamodel.HarvestDBConnection.updateTable(HarvestDBConnection.java:142)
at dk.netarkivet.harvester.datamodel.DerbySpecifics.migrateJobsv9tov10(DerbySpecifics.java:458)
at dk.netarkivet.harvester.datamodel.DBSpecifics.upgradeJobsTable(DBSpecifics.java:417)
at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTable(DBSpecifics.java:149)
at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTables(DBSpecifics.java:741)
at dk.netarkivet.harvester.tools.HarvestdatabaseUpdateApplication.main(HarvestdatabaseUpdateApplication.java:47)
Caused by: org.apache.derby.client.am.SqlException: Use of 'BOOLEAN' requires database to be upgraded from version 10.1 to version 10.7 or later.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
... 11 more
End of SQLException trace
at dk.netarkivet.common.utils.DBUtils.executeSQL(DBUtils.java:1048)
at dk.netarkivet.harvester.datamodel.HarvestDBConnection.updateTable(HarvestDBConnection.java:167)
at dk.netarkivet.harvester.datamodel.HarvestDBConnection.updateTable(HarvestDBConnection.java:142)
at dk.netarkivet.harvester.datamodel.DerbySpecifics.migrateJobsv9tov10(DerbySpecifics.java:458)
at dk.netarkivet.harvester.datamodel.DBSpecifics.upgradeJobsTable(DBSpecifics.java:417)
at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTable(DBSpecifics.java:149)
at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTables(DBSpecifics.java:741)
at dk.netarkivet.harvester.tools.HarvestdatabaseUpdateApplication.main(HarvestdatabaseUpdateApplication.java:47)
Caused by: java.sql.SQLException: Use of 'BOOLEAN' requires database to be upgraded from version 10.1 to version 10.7 or later.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213)
at dk.netarkivet.common.utils.DBUtils.prepareStatement(DBUtils.java:247)
at dk.netarkivet.common.utils.DBUtils.executeSQL(DBUtils.java:1037)
... 7 more
Caused by: org.apache.derby.client.am.SqlException: Use of 'BOOLEAN' requires database to be upgraded from version 10.1 to version 10.7 or later.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
... 11 more