We have entity with one schema and two different catalog under same session-factory
Code:
@Table(name = "ABC", schema = "dbo", catalog = "ProvisioningDB")
and
@Table(name = "collection", schema = "dbo", catalog = "ArrangeDB"
We are using SQLServer as DB in production but for test cases we are using HSQLDB & DB-Unit.
So whenever we run hbm2ddl.auto to create schema for HSQLDB by scanning entity package, it is unable to create schema and catalog .Following is the error we get
Code:
Unsuccessful: create table ProvisioningDB.approved.content (content_id bigint generated by default as identity (start with 1)...)
4538 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - user lacks privilege or object not found: PROVISIONINGDB
I have even try making schema manually in HSQLDB but code choke's because of catalog creation.I guess there is no support of multiple catalog under one schema in HSQLDB and I also feel that problem lies in HSQLDB Hibernate Dialect.
Kindly help me in this guys , I am stuck!!!!
Login
FAQ
Search