Return-Path: 
 <user-return-45619-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 73535 invoked from network); 10 Sep 2004 21:06:26 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 10 Sep 2004 21:06:26 -0000
Received: (qmail 76325 invoked by uid 500); 10 Sep 2004 21:06:16 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 76282 invoked by uid 500); 10 Sep 2004 21:06:15 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Subscribe: <mailto:user-subscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 76269 invoked by uid 99); 10 Sep 2004 21:06:15 -0000
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=DNS_FROM_RFC_ABUSE
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from [131.9.254.187] (HELO amcuxfw803.amc.af.mil) (131.9.254.187)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 10 Sep 2004 14:06:12 -0700
Received: from amc.af.mil ([131.9.19.246])
	by fw3.amc.af.mil with ESMTP id i8AL69cE010378
	for <user@ant.apache.org>; Fri, 10 Sep 2004 16:06:09 -0500 (CDT)
Received: from ([131.9.25.136])
	by amcotav802.amc.af.mil with ESMTP  id KP-BXW35.18193388;
	Fri, 10 Sep 2004 16:05:31 -0500
Message-ID: <4142171C.6060601@scott.af.mil>
Date: Fri, 10 Sep 2004 16:05:32 -0500
From: David Durham <david.durham1@scott.af.mil>
User-Agent: Mozilla Thunderbird 0.7.2 (Windows/20040707)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: hsqldb-user@lists.sourceforge.net, user@ant.apache.org
Subject: Using Hsqldb for unit tests
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

I have a couple of questions.

First off, I'm trying to use hsqldb for rapid development/prototyping.

I'm thinking I can do the following in a series of ant tasks:

   1. Connect to Hsqldb using the "mem" subprotocol simply by having the
      hsqldb jar in a classpath.
   2. Use XDoclet, and Torque to create tables -- I have this basically
      setup.
   3. Run unit tests with classes that use these tables.

Here are my questions:

   1. Can I connect to hsqldb:mem:
          * using username: sa and password: <empty>
          * in seperate ant targets (as in, create-db, and tests.run.*)

    * and expect to have access from a tests.run.* target to the tables
      created in a create-db target.

So far, my work indicates that it's not the case.  I have it setup to 
create tables, but when unit tests run, they through various SQL errors 
from "can't find table", to "no such username: sa"

Does anyone who can give me some help have a setup like this working?  I 
figured this was a common usage of hsqldb, is it not?


Thanks,

Dave


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org