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