Details
-
Bug
-
Resolution: Fixed
-
Critical
-
None
-
None
-
None
Description
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
Attachments
Issue Links
- mentioned in
-
Page Loading...