on 12-11-2015 9:39 AM
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
I'm afraid you are testing against incompatible (or not tested) MySQL version, please refer to Third Party Compatiblity list
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.