Problems when using multiple datasources with hibernate

Hibernate ORM
1

In my project i have annotated entities with @Table(name=“UPPERCASE_TABLE_NAME”).
When i using this entity via hibernate on oracle dasasource validation sucess - in my oracle database name in uppercase.
When i use same entity via postgresql9.6 i catch exceprion -
in my psql dstsbase table name in lowercase.

org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table. But table exists in schema.

How can i configure sessionfactory to support uppercase names with postgresql?

2

I think it could be the OS or the DB who changes the casing.

Try it like this if you want to make it case sensitive:

@Table(name = "`UPPERCASE_TABLE_NAME`")

Or you can use a custom naming strategy to enforce uppercase database identifiers, as explained in this article.