1 Reply Latest reply on Jun 22, 2006 2:49 AM by wfe wfe

    MySQL schema creation mystery

    wfe wfe Newbie

      Hi,
      I've been unsuccessfully trying to create the jbpm-3.0.2 schema on mysql-4.1 trying different things like

      Properties props = new Properties();
      // ...
      Dialect dialect = Dialect.getDialect(props);
      Configuration config = new Configuration();
      config.configure(new File("src\\config.files\\hibernate.cfg.xml"));
      String[] sql = config.generateSchemaCreationScript(dialect);

      and
      Configuration config = new Configuration();
      config.configure(new File("src\\config.files\\hibernate.cfg.xml"));
      JbpmSchema schema = new JbpmSchema(config);
      schema.createSchema();


      and several more but I always got the same org.hibernate.MappingException for some random table each time.

      But, I got the schema created by poking around with the build.deploy.xml and changing the JBPM_HOME\src\resources\hsqldb\create.db.hibernate.properties to suit my purposes.

      So, I'm wondering what did I do wrong in trying to create the schema myself.

      Can anyone clarify ? Please


      wfe