Create Database using JDBC - Mailing list pgsql-jdbc

From Nidhi Srivastava
Subject Create Database using JDBC
Date
Msg-id 2BC68159E3EC814BA1E81C108DF99A4203A37FD9@EXCH-IND-VS1.india.quark.com
Whole thread Raw
Responses Re: Create Database using JDBC  (Thomas Dudziak <tomdzk@gmail.com>)
Re: Create Database using JDBC  (Oliver Jowett <oliver@opencloud.com>)
Re: Create Database using JDBC  (Dave Cramer <pg@fastcrypt.com>)
Re: Create Database using JDBC  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-jdbc

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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: jdbc cts final diff for review
Next
From: Thomas Dudziak
Date:
Subject: Re: Create Database using JDBC