Project

General

Profile

Bug #2059

ant installdb fails when run on Oracle

Added by Saurabh Garg over 14 years ago. Updated over 10 years ago.

Status:
Resolved
Priority:
Normal
Category:
metacat
Target version:
Start date:
04/04/2005
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2059

Description

ant installdb doesnt run when Oracle is used as backend. 'set echo off' is not
working as default delimiter in ant is ; and ant sends "set echo off drop
sequence xyz" as one statement. Instead it should send "set echo off" and
then "sequence xyz". Matt suggested the following:
<matt> one advantage of breaking up the xml-tables.sql is that we could use the
same sql code for install and upgrade
<matt> ie, if we had a series of individual script files, one for each table,
trigger, etc
<matt> then we have a list of them to give the right order to call them all
<matt> but it could have some advantages
<matt> like we could have a directory for each release
<matt> the release dir would have the new tables fo rthat release

History

#2 Updated by Michael Daigle over 10 years ago

Metacat now runs all scripts internally. All scripts have been tested against postgres and oracle.

#3 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 2059

Also available in: Atom PDF