[
http://jira.dspace.org/jira/browse/DS-191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Larry Stone updated DS-191:
---------------------------
Attachment: database_schema.sql-diff.txt
Here is a patch to the original Oracle schema to fix this bug.
An existing repository that hasn't tried to add any metadata schemas yet can
fix it by executing these two SQL statements to re-create the sequence
properly; this has been tested under 1.5.2:
DROP SEQUENCE metadataschemaregistry_seq ;
CREATE SEQUENCE metadataschemaregistry_seq START WITH 2;
> metadataschemaregistry_seq is not initialized correctly under Oracle
> --------------------------------------------------------------------
>
> Key: DS-191
> URL: http://jira.dspace.org/jira/browse/DS-191
> Project: DSpace 1.x
> Issue Type: Bug
> Components: DSpace API
> Affects Versions: 1.5.2
> Environment: Oracle database
> Java 1.5.
> MacOS 10.5.6
> Reporter: Larry Stone
> Attachments: database_schema.sql-diff.txt
>
>
> The first attempt to add a new metadata schema fails, because the sequence
> metadataschemaregistry_seq is initialized to the default of 1, while there is
> already a row with ID 1 (inserted in databse_schema.sql).
> The easiest fix is probably just initializing the sequence to start with 2,
> as is done for epersongroup_seq. If I get the time to try it, I'll submit a
> patch.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.dspace.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel
