|
楼主 |
发表于 2016-11-28 17:08:30
|
显示全部楼层
本帖最后由 shunan 于 2016-11-28 17:18 编辑
升级数据库2.7-3.0的时候报错
开始备份数据库
========开始升级MYSQL数据库============
加载sql文件:mysql.sql
执行sql脚本...
java.lang.RuntimeException: 执行: create table SA_Social ( sID VARC
HAR(32) not null, sName VARCHAR(256), sTypeID VARCHAR(32), sTy
peName VARCHAR(64), sProcess VARCHAR(1024), sActivity VARCHAR
(128), sURL TEXT, sData1 VARCHAR(128), sData2 VARCH
AR(128), sData3 VARCHAR(128), sData4 VARCHAR(128), sCreatorID
VARCHAR(32), sCreatorName VARCHAR(128), sCreatorFID VARCHAR(1024), s
CreatorFName VARCHAR(1024), sPersonID VARCHAR(32), sPersonName V
ARCHAR(128), sOrgID VARCHAR(65), sOrgName VARCHAR(128), sOrgFID
VARCHAR(1024), sOrgFName VARCHAR(1024), sValidState INT, sCrea
teTime DATETIME, version INT, sESField01 VARCHAR(128), sESField02
VARCHAR(128), sESField03 VARCHAR(128), sESField04 VARCHAR(
128), sESField05 VARCHAR(128), sESField06 VARCHAR(128), sESField07
VARCHAR(128), sESField08 VARCHAR(128), sENField11 NUMERIC,
sENField12 NUMERIC, sENField13 NUMERIC, sENField14 NUMERIC, sEDFiel
d21 DATETIME, sEDField22 DATETIME, sEDField23 DATETIME, sEDField24
DATETIME, sETField31 TEXT, sETField32 TEXT, sETField33 TEXT, sE
TField34 TEXT, sEIField41 INT, sEIField42 INT, sEIField43 INT, sEI
Field44 INT, sEBField51 LONGBLOB, sEBField52 LONGBLOB, sEbField53 LONGBLOB
, sEBField54 LONGBLOB, sGroupID VARCHAR(32), sGroupName VARCHAR
(64), sMessageNumber INT, sActive INT ); 出错!
at com.justep.db.update.Database.update2(Database.java:243)
at com.justep.db.update.MYSQL.update(MYSQL.java:17)
at com.justep.db.update.Database.execute(Database.java:60)
at com.justep.db.update.Update.main(Update.java:26)
Caused by: java.sql.SQLException: Table 'sa_social' already exists
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.execute(Statement.java:529)
at com.justep.db.update.Database.update2(Database.java:229)
... 3 more
Exception in thread "main" java.lang.RuntimeException: 执行: create table SA_So
cial ( sID VARCHAR(32) not null, sName VARCHAR(256), sType
ID VARCHAR(32), sTypeName VARCHAR(64), sProcess VARCHAR(102
4), sActivity VARCHAR(128), sURL TEXT, sData1 VARCHAR(
128), sData2 VARCHAR(128), sData3 VARCHAR(128), sData4
VARCHAR(128), sCreatorID VARCHAR(32), sCreatorName VARCHAR(128), sCrea
torFID VARCHAR(1024), sCreatorFName VARCHAR(1024), sPersonID VARCHA
R(32), sPersonName VARCHAR(128), sOrgID VARCHAR(65), sOrgName
VARCHAR(128), sOrgFID VARCHAR(1024), sOrgFName VARCHAR(1024), sV
alidState INT, sCreateTime DATETIME, version INT, sESField01
VARCHAR(128), sESField02 VARCHAR(128), sESField03 VARCHAR(128), sE
SField04 VARCHAR(128), sESField05 VARCHAR(128), sESField06
VARCHAR(128), sESField07 VARCHAR(128), sESField08 VARCHAR(128), sE
NField11 NUMERIC, sENField12 NUMERIC, sENField13 NUMERIC, sENFiel
d14 NUMERIC, sEDField21 DATETIME, sEDField22 DATETIME, sEDField23
DATETIME, sEDField24 DATETIME, sETField31 TEXT, sETField32 TEXT, sE
TField33 TEXT, sETField34 TEXT, sEIField41 INT, sEIField42
INT, sEIField43 INT, sEIField44 INT, sEBField51 LONGBLOB, sEBField52 LONGBLOB
, sEbField53 LONGBLOB, sEBField54 LONGBLOB, sGroupID VARCHAR(32),
sGroupName VARCHAR(64), sMessageNumber INT, sActive INT ); 出错!
at com.justep.db.update.Database.update2(Database.java:243)
at com.justep.db.update.MYSQL.update(MYSQL.java:17)
at com.justep.db.update.Database.execute(Database.java:60)
at com.justep.db.update.Update.main(Update.java:26)
Caused by: java.sql.SQLException: Table 'sa_social' already exists
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.execute(Statement.java:529)
at com.justep.db.update.Database.update2(Database.java:229)
... 3 more
备份完成
请按任意键继续. . .
|
|