cancel
Showing results for 
Search instead for 
Did you mean: 

Hybris 6.7 failed to initialize when using MySQL databse

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member620692
Active Contributor
0 Kudos

It seems you are using an incompatible MySQL version and/or driver (mysql-connector-java-5.0.4-bin.jar). Please check my answer https://answers.sap.com/questions/12770812/system-update-not-working.html?childToView=12804533#answe... for more information.

0 Kudos

Thanks!!. It worked :)

former_member620692
Active Contributor
0 Kudos

You are most welcome.

Answers (0)