Re: [stellation-res] Firebird status, adding support for multiple databa

[Dave Shields <shields@xxxxxxxxxxxxxx>]

On Thu, Dec 12, 2002 at 01:31:20PM -0500, Dave Shields wrote:
> 
> Our current ant test scripts assume postgres. 
> Mark recently added code as part of his source reorg to allow for 
> database creation and destruction, so I'm going to extend 
> svcadmin (for creation) and add svcdrop (for destruction, 
> as Mark wants this in separate command), which will let me
> make the ant build file used to run tests database-independent.
> 

I have just checked in these changes. There is no svcdrop, just
tscvdrop, and it can only be used to drop (delete) databases
with names starting with 'tsvc', so I renamed the database used
for ant script tests from 'mergetst' to 'tsvctest'.

I ran tests, and they passed using postgres, but I want to work
on firebird support a little more, first by adding database 
creation/destruction (which will test of use via JDBC), before
putting up a new current build.

Though documented, it's worth repeating here that svcadmin (and hence
also tsvcadmin) now create the database and initialize it. However,
this requires that you first create the database 'tsvcboot', as JDBC
needs to connect to something to do database creation/destruction, and you
can't delete a database to which you are connected.

dave

-- 
Dave Shields, IBM Research, shields@xxxxxxxxxxxxxx.