I am getting errors from a PostgreSQL database when trying to programmatically create a new Database. The error I am getting is:

ERROR: CREATE DATABASE cannot run inside a transaction block

Hmm..the thing is that I did not set up any transaction objects in my code.


Code:

Session session = HibernateUtil.getSessionFactory().openSession();
Connection c = session.connection();
String databaseName = "TEST";
String user = "postgres";

String qString = "CREATE DATABASE \"" + databaseName + "\" WITH OWNER = \"" + user + "\" ENCODING = 'SQL_ASCII' TABLESPACE = pg_default";

Statement st = c.createStatement();
st.execute(qString);
st.close();

So the DB is complaining that this CREATE DATABASE statement is being executed from within a transaction because it only supports this operation outside of an explicit transaction.

IS THERE ANY WAY TO GET CONNECTION TO A DB WITHOUT A TRANSACTION?

Thanks Venkman