dalaocu commented on issue #1711: hbm2ddl update "CREATE INDEX" exception in jpa
URL: 
https://github.com/apache/incubator-shardingsphere/issues/1711#issuecomment-467024850
 
 
   I add two branches in my demo project in order to simplify your work.
   
   **Switch to branch "using-sharding-jdbc-log", the warn log appeared:**
   
   > 2019-02-25 21:17:05.833  WARN 42973 --- [           main] 
o.h.t.s.i.ExceptionHandlerLoggedImpl     : GenerationTarget encountered 
exception accepting command : Error executing DDL "create index block_height on 
activity_activity (block_height)" via JDBC Statement
   > 
   > org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing 
DDL "create index block_height on activity_activity (block_height)" via JDBC 
Statement
   >    at 
org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
 ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyIndexes(AbstractSchemaMigrator.java:331)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:84)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310) 
[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57)
 [spring-orm-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
 [spring-orm-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:390)
 [spring-orm-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377)
 [spring-orm-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341)
 [spring-orm-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1804)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1741)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:576)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 ~[spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1083)
 ~[spring-context-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:853)
 ~[spring-context-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546)
 ~[spring-context-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:142)
 ~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) 
~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
 ~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
org.springframework.boot.SpringApplication.run(SpringApplication.java:316) 
~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
org.springframework.boot.SpringApplication.run(SpringApplication.java:1260) 
~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
org.springframework.boot.SpringApplication.run(SpringApplication.java:1248) 
~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
com.dalaocu.sharding.demo.ShardingDemoApplication.main(ShardingDemoApplication.java:13)
 ~[main/:na]
   > Caused by: java.sql.SQLSyntaxErrorException: Duplicate key name 
'block_height_activity_activity'
   >    at 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) 
~[mysql-connector-java-8.0.13.jar:8.0.13]
   >    at 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 
~[mysql-connector-java-8.0.13.jar:8.0.13]
   >    at 
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
 ~[mysql-connector-java-8.0.13.jar:8.0.13]
   >    at 
com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782) 
~[mysql-connector-java-8.0.13.jar:8.0.13]
   >    at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666) 
~[mysql-connector-java-8.0.13.jar:8.0.13]
   >    at 
com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) 
~[HikariCP-3.2.0.jar:na]
   >    at 
com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) 
~[HikariCP-3.2.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.StatementExecutor$8.execute(StatementExecutor.java:205)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.StatementExecutor$12.executeSQL(StatementExecutor.java:267)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.StatementExecutor$12.executeSQL(StatementExecutor.java:263)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.sql.execute.SQLExecuteCallback.execute0(SQLExecuteCallback.java:72)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.sql.execute.SQLExecuteCallback.execute(SQLExecuteCallback.java:61)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.ShardingExecuteEngine.syncGroupExecute(ShardingExecuteEngine.java:175)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.ShardingExecuteEngine.groupExecute(ShardingExecuteEngine.java:152)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:71)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:54)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.AbstractStatementExecutor.executeCallback(AbstractStatementExecutor.java:114)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.StatementExecutor.execute(StatementExecutor.java:270)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.StatementExecutor.execute(StatementExecutor.java:201)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingStatement.execute(ShardingStatement.java:161)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
 ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    ... 34 common frames omitted
   > 
   > Hibernate: create index status on activity_activity (status)
   > 2019-02-25 21:17:05.874  WARN 42973 --- [           main] 
o.h.t.s.i.ExceptionHandlerLoggedImpl     : GenerationTarget encountered 
exception accepting command : Error executing DDL "create index status on 
activity_activity (status)" via JDBC Statement
   > 
   > org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing 
DDL "create index status on activity_activity (status)" via JDBC Statement
   >    at 
org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
 ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyIndexes(AbstractSchemaMigrator.java:331)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:84)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310) 
[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
 [hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    at 
org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57)
 [spring-orm-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
 [spring-orm-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:390)
 [spring-orm-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377)
 [spring-orm-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341)
 [spring-orm-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1804)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1741)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:576)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 ~[spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
 [spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1083)
 ~[spring-context-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:853)
 ~[spring-context-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546)
 ~[spring-context-5.1.4.RELEASE.jar:5.1.4.RELEASE]
   >    at 
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:142)
 ~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) 
~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
 ~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
org.springframework.boot.SpringApplication.run(SpringApplication.java:316) 
~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
org.springframework.boot.SpringApplication.run(SpringApplication.java:1260) 
~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
org.springframework.boot.SpringApplication.run(SpringApplication.java:1248) 
~[spring-boot-2.1.2.RELEASE.jar:2.1.2.RELEASE]
   >    at 
com.dalaocu.sharding.demo.ShardingDemoApplication.main(ShardingDemoApplication.java:13)
 ~[main/:na]
   > Caused by: java.sql.SQLSyntaxErrorException: Duplicate key name 
'status_activity_activity'
   >    at 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) 
~[mysql-connector-java-8.0.13.jar:8.0.13]
   >    at 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 
~[mysql-connector-java-8.0.13.jar:8.0.13]
   >    at 
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
 ~[mysql-connector-java-8.0.13.jar:8.0.13]
   >    at 
com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782) 
~[mysql-connector-java-8.0.13.jar:8.0.13]
   >    at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666) 
~[mysql-connector-java-8.0.13.jar:8.0.13]
   >    at 
com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) 
~[HikariCP-3.2.0.jar:na]
   >    at 
com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) 
~[HikariCP-3.2.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.StatementExecutor$8.execute(StatementExecutor.java:205)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.StatementExecutor$12.executeSQL(StatementExecutor.java:267)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.StatementExecutor$12.executeSQL(StatementExecutor.java:263)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.sql.execute.SQLExecuteCallback.execute0(SQLExecuteCallback.java:72)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.sql.execute.SQLExecuteCallback.execute(SQLExecuteCallback.java:61)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.ShardingExecuteEngine.syncGroupExecute(ShardingExecuteEngine.java:175)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.ShardingExecuteEngine.groupExecute(ShardingExecuteEngine.java:152)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:71)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.core.executor.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:54)
 ~[sharding-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.AbstractStatementExecutor.executeCallback(AbstractStatementExecutor.java:114)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.StatementExecutor.execute(StatementExecutor.java:270)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.executor.StatementExecutor.execute(StatementExecutor.java:201)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
io.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingStatement.execute(ShardingStatement.java:161)
 ~[sharding-jdbc-core-3.1.0.jar:na]
   >    at 
org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
 ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
   >    ... 34 common frames omitted
   
   
   **If you switch to branch "using-jdbc-log", the error disappeared.**
   
   > 2019-02-25 21:30:37.650  INFO 43945 --- [           main] 
o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing 
PersistenceUnitInfo [
   >    name: default
   >    ...]
   > 2019-02-25 21:30:37.751  INFO 43945 --- [           main] 
org.hibernate.Version                    : HHH000412: Hibernate Core 
{5.3.7.Final}
   > 2019-02-25 21:30:37.753  INFO 43945 --- [           main] 
org.hibernate.cfg.Environment            : HHH000206: hibernate.properties not 
found
   > 2019-02-25 21:30:37.962  INFO 43945 --- [           main] 
o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons 
Annotations {5.0.4.Final}
   > 2019-02-25 21:30:38.125  INFO 43945 --- [           main] 
com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
   > 2019-02-25 21:30:38.536  INFO 43945 --- [           main] 
com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
   > 2019-02-25 21:30:38.551  INFO 43945 --- [           main] 
org.hibernate.dialect.Dialect            : HHH000400: Using dialect: 
com.dalaocu.sharding.demo.config.MysqlConfig
   > 2019-02-25 21:30:39.357  INFO 43945 --- [           main] 
j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory 
for persistence unit 'default'
   > 2019-02-25 21:30:40.289  INFO 43945 --- [           main] 
o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 
'applicationTaskExecutor'
   > 2019-02-25 21:30:40.376  WARN 43945 --- [           main] 
aWebConfiguration$JpaWebMvcConfiguration : spring.jpa.open-in-view is enabled 
by default. Therefore, database queries may be performed during view rendering. 
Explicitly configure spring.jpa.open-in-view to disable this warning
   > 2019-02-25 21:30:40.714  INFO 43945 --- [           main] 
o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8082 
(http) with context path ''
   > 2019-02-25 21:30:40.718  INFO 43945 --- [           main] 
c.d.s.demo.ShardingDemoApplication       : Started ShardingDemoApplication in 
6.864 seconds (JVM running for 7.306)
   > 

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

Reply via email to