codefairy08 commented on issue #1711: hbm2ddl update "CREATE INDEX" exception in jpa URL: https://github.com/apache/incubator-shardingsphere/issues/1711#issuecomment-467760655 @dalaocu it works well use your 'using-sharding-jdbc-log' branch, my code url is [https://github.com/codefairy08/sharding-demo](url), mysql version is 8.0, i do not use zk. the log is 019-02-27 15:40:18.733 INFO 9220 --- [ main] c.d.s.demo.ShardingDemoApplication : Starting ShardingDemoApplication on DESKTOP-UJ1QVF3 with PID 9220 (E:\gitrepo\1711_demo\using-sharding-jdbc-log\sharding-demo\bin\main started by dhj in E:\gitrepo\1711_demo\using-sharding-jdbc-log\sharding-demo) 2019-02-27 15:40:18.735 INFO 9220 --- [ main] c.d.s.demo.ShardingDemoApplication : The following profiles are active: sharding-tables 2019-02-27 15:40:19.268 INFO 9220 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data repositories in DEFAULT mode. 2019-02-27 15:40:19.320 INFO 9220 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 45ms. Found 1 repository interfaces. 2019-02-27 15:40:19.562 INFO 9220 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$ca11adb3] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-02-27 15:40:19.927 INFO 9220 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8082 (http) 2019-02-27 15:40:20.031 INFO 9220 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2019-02-27 15:40:20.032 INFO 9220 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.14] 2019-02-27 15:40:20.041 INFO 9220 --- [ main] o.a.catalina.core.AprLifecycleListener : The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: 2019-02-27 15:40:20.124 INFO 9220 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2019-02-27 15:40:20.124 INFO 9220 --- [ main] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 1213 ms 2019-02-27 15:40:20.207 INFO 9220 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2019-02-27 15:40:20.304 INFO 9220 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2019-02-27 15:40:20.434 INFO 9220 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [ name: default ...] 2019-02-27 15:40:20.481 INFO 9220 --- [ main] org.hibernate.Version : HHH000412: Hibernate Core {5.3.7.Final} 2019-02-27 15:40:20.481 INFO 9220 --- [ main] org.hibernate.cfg.Environment : HHH000206: hibernate.properties not found 2019-02-27 15:40:20.591 INFO 9220 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.0.4.Final} 2019-02-27 15:40:20.707 INFO 9220 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: com.dalaocu.sharding.demo.config.MysqlConfig Hibernate: create table activity_activity (pk_id bigint not null auto_increment, block_height bigint, depot_updatetime datetime(6), status integer, primary key (pk_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8 Hibernate: create index block_height on activity_activity (block_height) Hibernate: create index status on activity_activity (status) 2019-02-27 15:40:21.488 INFO 9220 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2019-02-27 15:40:21.920 INFO 9220 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2019-02-27 15:40:21.954 WARN 9220 --- [ 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-27 15:40:22.106 INFO 9220 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8082 (http) with context path '' 2019-02-27 15:40:22.107 INFO 9220 --- [ main] c.d.s.demo.ShardingDemoApplication : Started ShardingDemoApplication in 3.639 seconds (JVM running for 3.949)
---------------------------------------------------------------- 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
