Re: Create Database using JDBC

From: Kris Jurka <books(at)ejurka(dot)com>
To: Nidhi Srivastava <nsrivastava(at)quark(dot)com>
Cc: Thomas Dudziak <tomdzk(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org, John R Pierce <pierce(at)hogranch(dot)com>
Subject: Re: Create Database using JDBC
Date: 2005-07-04 09:30:53
Message-ID: Pine.BSO.4.56.0507040428390.12238@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, 4 Jul 2005, Nidhi Srivastava wrote:

> Even when I'm not accessing templte1 but any other scratch database
> through pgAdmin and try to create a new DB using JDBC I get the same
> ERROR: CREATE DATABASE: source database "template1" is being accessed
> by other users. Is there a way to check if a DB exists and create it if
> it doesn't using JDBC. How can I ensure that pgAdmin is not open on any
> of the client machines and connected to the Postgre server on my
> machine....becuase if even a single pgAdmin client is open on any of the
> client machines it doesn't allow me to create a new DB throwing the
> above error.
>

I would suggest using an alernate template database to create new
databases with. You could even mark it to refuse connections to ensure no
one else will connect to it and block your operation.

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-07-04 09:33:32 Re: Streaming blob to db
Previous Message Oliver Jowett 2005-07-04 08:52:38 Re: Write to outputstream in PGStream blocks indefinitely