数据库升级从X5.2.7升级到X5V3.2;完全按照升级步骤来的,在X5.2.7升级到X5V3.0时报错:
错误如下:
java.sql.SQLException: 各表中的列名必须唯一。在表 'SA_OPPerson' 中多次指定了列名
'sPhotoLastModified'。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.
java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java
:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.jav
a:664)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:11
14)
at com.justep.db.update.MSSQL.update(MSSQL.java:31)
at com.justep.db.update.Database.execute(Database.java:60)
at com.justep.db.update.Update.main(Update.java:26)
Exception in thread "main" java.sql.SQLException: 各表中的列名必须唯一。在表 'SA
_OPPerson' 中多次指定了列名 'sPhotoLastModified'。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.
java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java
:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.jav
a:664)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:11
14)
at com.justep.db.update.MSSQL.update(MSSQL.java:31)
at com.justep.db.update.Database.execute(Database.java:60)
at com.justep.db.update.Update.main(Update.java:26)
备份完成
请按任意键继续. . .