xplanner SQL upgrade problem
Abylai Ospan <aospan-SoTE/[email protected]> Sun, 17 Sep 2006 11:57:41 +0400
| Newsgroups | gmane.comp.java.xplanner.devel |
|---|---|
| Organization | NetUP Inc. |
| Message-ID | <[email protected]> |
Good day !
I'm trying to upgrade xplanner from xplanner-0.7b4 to xplanner-0.7b7 but
when starting tomcat log following error:
Caused by: com.tacitknowledge.util.migration.MigrationException:
patch0004_0-6-2_to_0-7b1_A.sql: Error running SQL "SELECT @id:=next FROM
identifier"
at
com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask.migrate(SqlScriptMigrationTask.java:142)
at
com.tacitknowledge.util.migration.MigrationProcess.doMigrations(MigrationProcess.java:162)
at
com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(JdbcMigrationLauncher.java:288)
at
com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(JdbcMigrationLauncher.java:108)
at
com.technoetic.xplanner.filters.XPlannerMigrationLauncher.contextInitialized(XPlannerMigrationLauncher.java:67)
... 25 more
Caused by: java.sql.SQLException: Unknown column 'next' in 'field list'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
But in table identifier (in xplanner database) I've already have nextId
field:
mysql> desc identifier;
+--------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------+------+-----+---------+-------+
| nextId | int(11) | | | 0 | |
+--------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)
File patch0004_0-6-2_to_0-7b1_A.sql already applyed to database ...
How to disable applying this file to database ?
May be ignoring this exceptions and start anyway ? This would be useful
because duplicate ALTER or INSERT dosn't matter and database is not
corrupted ...
Thanks !
wbr, Abylai
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Xplanner-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xplanner-devel