Bug #2059
closedant installdb fails when run on Oracle
0%
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
Updated by Michael Daigle over 15 years ago
Metacat now runs all scripts internally. All scripts have been tested against postgres and oracle.