Hi,

I tryed to create a db schema with the schema export tool but I got the following exception :
[schemaexport] 18:40:22,302 ERROR SchemaExport:165 - schema export unsuccessful
[schemaexport] java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported

I use postgresql 7.4.1.3 and the jdbc driver postgres-jdbc2-7.3.jar.

The problem seems to be that schema export tool try to set autocommit to OFF instead of doing an explicit commit.

Is there a way to do this?
If not, how can I run hibernate over my configuration?

Regards,
Christophe D.

You're using the wrong JDBC driver. Use the driver for PostgreSQL 7.4.

Formerly autocommit was a server setting, but in 7.4 autocommit is something that the driver handles all by itself. The server doesn't understand the concept of autocommit anymore.

Thanks it's work fine now.

I really appreciate the quick answer.