[jboss-user] [JBoss Seam] - Persistence - Switching DB to Postgres - Schema Export fails

Trying to switch the DB to PostgreSQL fails, little help would be nice. Using the Seam DVD Example, i configured persistence.xml: | <persistence-unit name="dvdDatabase"> | <provider>org.hibernate.ejb.HibernatePersistence</provider> | <jta-data-source>java:/dvdDatasource</jta-data-source> | <properties> | <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/> | <property name="hibernate.connection.driver_class" value="org.postgresql.Driver"/> | <property name="hibernate.connection.url" value="jdbc:postgresql://localhost:5432/mydb"/> | <property name="hibernate.connection.username" value="testuser"/> | <property name="hibernate.connection.password" value="test"/> | <property name="hibernate.default_schema" value="postgres"/> | | <property name="hibernate.hbm2ddl.auto" value="create-drop"/> | <property name="hibernate.cache.use_query_cache" value="true"/> | <property name="hibernate.show_sql" value="true"/> | <property name="hibernate.cache.provider_class" | value="org.hibernate.cache.HashtableCacheProvider"/> | </properties> | </persistence-unit --> | | The error is: | 15:08:21,754 INFO [SchemaExport] Running hbm2ddl schema export | 15:08:21,766 INFO [SchemaExport] exporting generated schema to database | 15:08:21,858 INFO [SchemaExport] Executing import script: /import.sql | 15:08:21,860 ERROR [SchemaExport] schema export unsuccessful | Some hints would be nice, why the export fails. I guess my persistence.xml might be wrong - but looked at the documentation, should work, should it? kind regards Torsten View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3958786#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...