Hi, I have installed hybris 6.7 with b2c_b2b_acc_oms recipe and using mysql as database. While initializing hybris, it gives error , it is unable to find cronjob table in my databse.
My database settings for mysql in local.properties
db.url=jdbc:mysql://localhost:3306/hybrislocal?useConfigs=maxPerformance&characterEncoding=utf8 db.driver=com.mysql.jdbc.Driver db.username=root db.password=root db.tableprefix= mysql.optional.tabledefs=CHARSET=utf8 COLLATE=utf8_bin mysql.tabletype=InnoDB mysql.allow.fractional.seconds=true innodb_flush_log_at_trx_commit=0
Caused by: java.sql.BatchUpdateException: Table 'hybrislocal.cronjobs' doesn't exist at com.mysql.jdbc.Statement.executeBatch(Statement.java:919) ~[mysql-connector-java-5.0.4-bin.jar:?] at de.hybris.platform.jdbcwrapper.StatementImpl.executeBatch(StatementImpl.java:481) ~[coreserver.jar: at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408) ~[spring-jdbc-4.3.17.RELE at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:606) ~[spring-jdbc-4.3.17. at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeBatch(DefaultDbScriptsExecutor.java:142) ~[ ... 144 more