Hi,
I am trying to "SET SCRIPTFORMAT COMPRESSED" to my underlying HSQLDB but get an exception:
Code:
user lacks privilege or object not found: SCRIPTFORMAT
I am trying the following:
Code:
EntityManager em = getEntityManager();
em.getTransaction().begin();
em.createNativeQuery("SET SCRIPTFORMAT BINARY").executeUpdate();
em.createNativeQuery("SET SCRIPTFORMAT COMPRESSED").executeUpdate();
em.getTransaction().commit();
Code:
<property name="hibernate.connection.username" value="sa" />
<property name="hibernate.connection.password" value="" />
<property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" />
<property name="hibernate.hbm2ddl.auto" value="create" />
The DB is initialized automatically on startup and I am trying this as the first statement after auto-initialization. Can anyone give me a hint what I am missing?
Thanks and Best Regards,
Tobias
Login
FAQ
Search