Page 1 of 1

Migration guide problem

PostPosted:Mon Jan 10, 2011 11:25 am
by geantVert
I have a problem to execute the alter table statements as explained in the migration guide 5.0 beta to 5.0-RC1.
It is impossible to run the statements, using the JDBC driver.

I get the following error while running the following statement:
ALTER TABLE OKM_PROFILE CHANGE PRF_MISC_ADVANCED_FILTERS PRF_MSC_ADVANCED_FILTERS bit(1) DEFAULT 0;
from the Database Query from the admin tool:

Class: java.sql.SQLException
Message: Unexpected token: CHANGE in statement [ALTER TABLE OKM_PROFILE CHANGE]

Apparently the syntax is not correct ?!?

Re: Migration guide problem

PostPosted:Mon Jan 10, 2011 7:21 pm
by jllort
If you're on default OpenKM configuration, then you're on hypersonic, I suggest use some dbms client like data studio and connect directly to hipersonic ( jboss must be stopped ).

Re: Migration guide problem

PostPosted:Thu Jan 20, 2011 8:24 pm
by pavila
Did you executed the SQL sentence already?