cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL SQL Syntax Error during Initialization

Former Member
0 Kudos

Trying to initialize hybris 5.5.1.7 with MySQL 5.7.10 and Connector/J v5.1.38 with connection params below:

 # connection
 db.url=jdbc:mysql://127.0.0.1:3306/hybris?useConfigs=maxPerformance&characterEncoding=utf8&useSSL=false&requireSSL=false&verifyServerCertificate=false
 db.driver=com.mysql.jdbc.Driver
 db.username=hybris
 db.password=*****
 # table prefix e.g. if db is shared
 db.tableprefix=
 # other *mandatory* settings
 db.customsessionsql=SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
 mysql.optional.tabledefs=CHARSET=utf8 COLLATE=utf8_bin
 mysql.tabletype=InnoDB
 mysql.allow.fractional.seconds=true

Triggers SQL exception:

     [DefaultDbScriptsExecutor] problem executing sql [reason: StatementCallback; bad SQL grammar.....
     nested exception is java.sql.BatchUpdateException: Table 'hybris.props' doesn't exist]
     Caused by: java.sql.BatchUpdateException: Table 'hybris.props' doesn't exist
          [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
          [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
          [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
          [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
          [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
          [java]     at com.mysql.jdbc.Util.getInstance(Util.java:387)
          [java]     at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1154)
          [java]     at com.mysql.jdbc.StatementImpl.executeBatchInternal(StatementImpl.java:1049)
          [java]     at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:959)
          [java]     at de.hybris.platform.jdbcwrapper.StatementImpl.executeBatch(StatementImpl.java:475)
          [java]     at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:572)
          [java]     at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:559)
          [java]     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          [java]     ... 41 more
          [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hybris.props' doesn't exist
          [java]     at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
          [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
          [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
          [java]     at com.mysql.jdbc.Util.getInstance(Util.java:387)
          [java]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
          [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
          [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
          [java]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
          [java]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
          [java]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
          [java]     at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1541)
          [java]     at com.mysql.jdbc.StatementImpl.executeBatchInternal(StatementImpl.java:1023)
          [java]     ... 46 more
 

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member537989
Contributor
0 Kudos

I'm afraid you are testing against incompatible (or not tested) MySQL version, please refer to Third Party Compatiblity list