Bayless Kirtley wrote:
Paul Taylor, 04.08.2009 15:48:
Thats a shame, I wanted to write junit test for a java program that
queried a database, requiring a full database to be available for
unit tests is not really an environment I want to have.
Well if you want to test the database, you will need a full database.
But you can easily setup and start a Postgres server through a batch
file/shell script. I have a small batch file that simply uses the
binary ZIP distribution to run initdb and create the initial
databases. We are using this to bundle Postgres e.g. with a Tomcat
web application.
You don't really need to run an installer and/or create registry
entries (for windows). This would then resemble more the Derby
network server setup.
Thomas
Of course you can always use Derby for testing the Postgres later. I
have found HSQLDB to be closer to Postgres than Derby is. I do seem to
recall the Netbeans group recommends using sever mode during
development then switch to imbedded for distribution. I have done it
both ways with equal success and similar efforts.
Bayless
Thanks I am trying to use Derby but fallen foul of Postgres array
datatype which Derby doesn't support, Ive just had a quick look at
HSQLDB and it doesn't appear to support it either.
Paul
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
