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

[tkrah]

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#3958786

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3958786