Skip to Content
author's profile photo Former Member
Former Member

MySQL SQL Syntax Error during Initialization

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
 
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 11, 2015 at 04:57 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.