Hi guys,

I'm trying to set up my hibernate properties. My EAR is running on a wildfly 10.1. In it's standalone.xml I declared my datasource (DB2 Z/os) which I reference in my persistence.xml.
In my persistence.xml I declared <property name="hibernate.default_schema" value="myown"/>. This set up seems to work for some application operations.
That means, if I persist some entities, the sqls are generated correctly and the schema is put in front of the tables name => myown.table.

But for some operations (other tables), the schema isn't put in front of the table - instead the user name. What's the reason?

Thanks a lot,
Christian

Can you elaborate this with some examples: mappings, queries, data access logic?

Hi Christian,

I run in missing schema-tags before, when I forgot them in my @JoinTable-Annotation. But as Vlad said before it´s hard to find an answer without examles.



Kind regards,
Vincent

Hey guys,

thanks for your help and interest.

I found the fault. I had a sql query that I put in the entity manager and there, the schema wasn't put in front of the table.
I used the tag {h-schema} so that hibernate uses the default schema from the property

hibernate.default_schema.

Greets,
binke

For more details about {h-schema}, check out this article.