Announcement Announcement Module
Collapse
No announcement yet.
Problem with hibernate.hbm2ddl.auto : drop-create Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem with hibernate.hbm2ddl.auto : drop-create

    Hi there,

    I am having a problem with my configuration.
    I am writing a spring application and I us the config from one of the spring data rest example apps.

    If I use the config as is, I have the problem, that old data is kept, even after a server restart. (Posted another message about this before)
    Therefore, I wanted to add the hibernate.hbm2ddl.auto : drop-create to the config (The block that's comment in the code blow).

    But, if I add that option I get the error:

    org.hsqldb.HsqlException: user lacks privilege or object not found

    If I remove the option, everything works fine again.

    Does anyone have a tip on how to solve this error? Google couldn't help...

    Thanks
    Dominik


    Code:
     @Bean public DataSource dataSource() {
        EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
        return builder.setType(EmbeddedDatabaseType.HSQL).build();
      }
    
      @Bean public EntityManagerFactory entityManagerFactory() {
        HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
        vendorAdapter.setDatabase(Database.HSQL);
        vendorAdapter.setGenerateDdl(true);
    
        LocalContainerEntityManagerFactoryBean factory = new LocalContainerEntityManagerFactoryBean();
        
       /* Properties jpaProperties = new Properties();
       jpaProperties.setProperty("hibernate.hbm2ddl.auto", "drop-create");
        jpaProperties.setProperty("hibernate.show_sql", "true");
        jpaProperties.setProperty("hibernate.dialect", "org.hibernate.dialect.HSQLDialect");
        factory.setJpaProperties(jpaProperties);
       */     
        factory.setJpaVendorAdapter(vendorAdapter);
        factory.setPackagesToScan("de.cab.test1.domain");
        factory.setDataSource(dataSource());
        
    
        
        factory.afterPropertiesSet();
    
        return factory.getObject();
      }
    
      @Bean public JpaDialect jpaDialect() {
        return new HibernateJpaDialect();
      }
    
      @Bean public PlatformTransactionManager transactionManager() {
        JpaTransactionManager txManager = new JpaTransactionManager();
        txManager.setEntityManagerFactory(entityManagerFactory());
        return txManager;
      }
Working...
X