Create Database using 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