Re: Create Database using JDBC

Поиск

Список

Период

Сортировка

От	Dave Cramer
Тема	Re: Create Database using JDBC
Дата	1 июля 2005 г. 12:30:39
Msg-id	01D427A8-9B3A-457E-8371-C1BA62416274@fastcrypt.com обсуждение исходный текст
Ответ на	Create Database using JDBC ("Nidhi Srivastava" <nsrivastava@quark.com>)
Список	pgsql-jdbc

Дерево обсуждения

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