Re: [stellation-res] Firebird Testing (Windows)

["Jonathan Gossage" <jonathan@xxxxxxxxxxxxxx>]

----- Original Message -----
From: "Jim Wright - IBM Research" <jwright@xxxxxxxxxxxxxx>
To: <stellation-res@xxxxxxxxxxxxxxx>
Sent: Monday, April 28, 2003 2:24 PM
Subject: [stellation-res] Firebird Testing (Windows)


> Jonathan,
>
> I've just successfully completed the remote test suite (all 14 tests)
> for Stellation with Firebird.  Congratulations!
>
> (Sorry not to finish testing sooner; I was with my younger daughter
> at the NY state debate tournament on Friday and Saturday, rescheduled
> from early April due to a severe ice storm at that time).
>
> There've been a number of speed bumps along the way (mostly related to
> db initialization, directory location and username/password issues).  I'm
> in the process of writing
> these up and making sure I can repeat the install-test process from
scratch.
> I'll post further details once I'm fairly sure they're correct.
>
> Related tasks:
> * Run a local Firebird test suite on Windows
> * Run local and remote test suites  on Linux, using PostgreSQL.
>
> I have a couple of questions /comments:
>
> 1. The tsvcadmin and tsvcserver batch files include an exit directive.  I
> suppose this is
> to facilitate calling these batch files from the Ant test scripts?  While
> debugging some issues,
> I was calling tsvcadmin and tsvcserver directly, and had to REM out those
> lines to keep my shell alive.

Yes, that was the reason. Would you like me to create special versions to
run under Ant and leave the t*.bat files capable of running standalone?
>
> 2. The tsvcserver command line includes the option:
>    --database=firebird+D:\Firebird\tsvctest+++sysdba+masterkey
> Is the syntax for "+++sysdba+masterkey" documented somewhere?
> (and, why "...+++sysdba" rather than "...+sysdba" ??)
> More generally, what's the exact syntax for both the --database
> option (for tsvcserver) and the --location option (for tsvcadmin).

The general syntax is
database-type[+[database-name][+[hostname][+[port][+[user] [+[password]]]]]]

This allows any part except the database type to be omitted and a default
value used. Defaulted trailing
values can be completely omitted. Thus you can have
     firebird+D:\Firebird\tsvctest
         where everything except the type and database name are defaulted

or
    firebird+D:\Firebird\tsvctest+++me+mypassword
       where the hostname and port are defaulted
>
Regards

Jonathan