clarencen/lshift — Issue #55: DB cannot migrate from 9 to 10 on Oracle
Author: clarencen
Created: 2011-11-14 22:41:31+00:00
State: open

When running ReviseUrlLengthMigrationStep, Oracle flags the following error:

java.sql.SQLSyntaxErrorException: ORA-01735: invalid ALTER TABLE option

Oracle's native syntax for this migration step would be:

alter table endpoint modify ( scan_url varchar2(1024 char) );
alter table endpoint modify ( content_retrieval_url varchar2(1024 char) );
alter table endpoint modify ( version_generation_url varchar2(1024 char) );
alter table endpoint modify ( inbound_url varchar2(1024 char) );

N.B. if you leave the "char" keyword off, it defaults to "byte" (i.e. usually not what you want.)

If Hibernate can't handle this, BNF and railroad diagrams are available here: http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_3001.htm#i2103956