Message Title

Matthias Kurz created an issue

HHH-9910

Issue Type:	Bug
Affects Versions:	5.0.0.CR2
Assignee:	Unassigned
Created:	09/Jul/2015 07:01 AM
Environment:	Ubuntu Linux 12.04 64 bit, PostgreSQL 9.1, Java 8
Priority:	Major
Reporter:	Matthias Kurz

This works with Hibernate 4.3.10.

Running on LINUX

Dependencies:

 
                                                      "org.postgresql" % "postgresql" % "9.4-1201-jdbc41",
  "org.hibernate" % "hibernate-entitymanager" % "5.0.0.CR2"

Postgresql version:

 
                                                    # SELECT version();
                                                   version                                                   
-------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.1.18 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit
(1 row)
 
                                                

Files:
Java model: https://gist.github.com/mkurz/4f07657fe39bbf75ec13
config: https://gist.github.com/mkurz/063c6a780519060eddb5

Reproduce:
Database is empty (no tables). Running with hibernate.hbm2ddl.auto=update gives me the exception:

 
                                                    Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: BIG PROBLEM
	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigrationToTargets(SchemaMigratorImpl.java:113) ~[hibernate-core-5.0.0.CR2.jar:5.0.0.CR2]
	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:59) ~[hibernate-core-5.0.0.CR2.jar:5.0.0.CR2]
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:129) ~[hibernate-core-5.0.0.CR2.jar:5.0.0.CR2]
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:97) ~[hibernate-core-5.0.0.CR2.jar:5.0.0.CR2]
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:476) ~[hibernate-core-5.0.0.CR2.jar:5.0.0.CR2]
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:444) ~[hibernate-core-5.0.0.CR2.jar:5.0.0.CR2]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:802) ~[hibernate-entitymanager-5.0.0.CR2.jar:5.0.0.CR2]
	... 58 common frames omitted
 
                                                

However the table test (lower case) is created in the database.

Re-running (without deleting the table) now gives me:

 
                                                    Caused by: org.postgresql.util.PSQLException: ERROR: relation "test" already exists
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) ~[postgresql-9.4-1201-jdbc41.jar:9.4]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998) ~[postgresql-9.4-1201-jdbc41.jar:9.4]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql-9.4-1201-jdbc41.jar:9.4]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) ~[postgresql-9.4-1201-jdbc41.jar:9.4]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406) ~[postgresql-9.4-1201-jdbc41.jar:9.4]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) ~[postgresql-9.4-1201-jdbc41.jar:9.4]
	at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:108) ~[HikariCP-2.3.7.jar:na]
	at com.zaxxer.hikari.proxy.StatementJavassistProxy.executeUpdate(StatementJavassistProxy.java) ~[HikariCP-2.3.7.jar:na]
	at org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:56) ~[hibernate-core-5.0.0.CR2.jar:5.0.0.CR2]
	... 68 common frames omitted
 
                                                

It seems this is an issue case-sensitive table/entity names.
From my PostgreSQL logs I can see hibernate tries to create:

 
                                                    create table Test (id uuid not null, primary key (id))

but the lower case table "test" exists already...

Add Comment

This message was sent by Atlassian JIRA