Postgres Pro
Downloads
Home   >   mailing lists

Re: Create Database using JDBC - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Create Database using JDBC
Date
Msg-id 01D427A8-9B3A-457E-8371-C1BA62416274@fastcrypt.com
Whole thread Raw
In response to Create Database using JDBC  ("Nidhi Srivastava" <nsrivastava@quark.com>)
List pgsql-jdbc
Tree view
Is it possible you have an existing open transaction on template1 ?

Have a look at the postgresql logs.

Dave
On 1-Jul-05, at 4:30 AM, Nidhi Srivastava wrote:

Hi all

 

I wish to create a database if one doesn’t exist using JDBC. I tried connecting to template1 database and then issuing the “CREATE DATABASE test” command but I get the following error :

 

ERROR:  CREATE DATABASE: source database "template1"
is being accessed by other users

 

 

How do I resolve this? I’m using PostGreSQL8.0

 

Thanks & Regards

Nidhi





Dave Cramer
www.postgresintl.com
ICQ #14675561
ph (519 939 0336 )

pgsql-jdbc by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Create Database using JDBC
Next
From: Thomas Dudziak
Date:
Subject: Re: Create Database using JDBC