DB cannot migrate from 9 to 10 on Oracle
Reported by John Wright | October 25th, 2011 @ 02:52 PM | in 1.0 (closed)
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/stat...
Comments and changes to this ticket
-
Ben Hood November 1st, 2011 @ 02:39 PM
- Milestone set to “1.0”
- Milestone order changed from “17” to “0”
-
Ben Hood November 1st, 2011 @ 02:42 PM
- Tag changed from “oracle sql schema migration alter table” to “db versioning”
-
Ben Hood November 8th, 2011 @ 12:42 AM
- Milestone order changed from “1” to “0”
(from [0903cb96609529f1f2eec28ed08f097984935953]) [#399] Fix alter column statements under Oracle. https://github.com/lshift/diffa/commit/0903cb96609529f1f2eec28ed08f...
-
Paul Jones November 8th, 2011 @ 12:53 AM
- Assigned user set to “Ben Hood”
- State changed from “new” to “resolved”
Pull request raised, ready for QA.
-
Ben Hood November 8th, 2011 @ 06:52 AM
(from [7ee575073a4d6f6ea0300c7ef1e71ab7808dfc43]) Merge pull request #105 from lshift/399
[#399] Fix alter column statements under Oracle. https://github.com/lshift/diffa/commit/7ee575073a4d6f6ea0300c7ef1e7...
-
Ben Hood November 9th, 2011 @ 05:43 AM
- State changed from “resolved” to “closed”
This was been integration tested against Oracle as part of the testing for #391 -> QA+
-
Paul Jones November 10th, 2011 @ 10:02 AM
A Pivotal Tracker story has been created for this Ticket: http://www.pivotaltracker.com/story/show/20831781
-
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
A Real Time Differencing Tool.
People watching this ticket
Ben Hood
Tags
Referenced by
-
391
DB cannot migrate from 8 to 9 on Oracle
Potentially - I think it maybe a case of running the
Hibe...