fescar+springboot+jpa don't auto create table

[wangpeng9910]

fescar+springboot+jpa don't auto create table,
DataSource configuration:
@bean
public DataSource getDataSource() {
DruidDataSource dataSource = new DruidDataSource();
dataSource.setUrl(env.getProperty("spring.datasource.url"));
dataSource.setUsername(env.getProperty("spring.datasource.username"));
dataSource.setPassword(env.getProperty("spring.datasource.password"));
dataSource.setDriverClassName(env.getProperty("spring.datasource.driver-class-name"));

    DataSourceProxy proxy = new DataSourceProxy(dataSource);

    return proxy;
}

don't auto create table
but The following configuration:
@bean
public DataSource getDataSource() {
DruidDataSource dataSource = new DruidDataSource();
dataSource.setUrl(env.getProperty("spring.datasource.url"));
dataSource.setUsername(env.getProperty("spring.datasource.username"));
dataSource.setPassword(env.getProperty("spring.datasource.password"));
dataSource.setDriverClassName(env.getProperty("spring.datasource.driver-class-name"));

    return dataSource ;
}

can do auto create table

How should I solve this problem?
Thank you

[slievrly]

@wangpeng9910 run our sample？

[wangpeng9910]

@slievrly yes i run your sample ,i modify springboot application.yml:
jpa:
hibernate:
ddl-auto: update
show-sql: true
i hope jpa automatically create tables，but failure

[wangpeng9910]

@slievrly console already output hibernate sql ,but database not have tables

[slievrly]

I will check

[huhuajie]

org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(String) 这个方法里面执行 jdbcStatement.execute( command )建表。 但是 com.alibaba.fescar.rm.datasource.StatementProxy.execute(String) 没有实现,所以无法建表

[wangpeng9910]

@huhuajie 谢谢你的解释，看来要我自己修改完善或者等feacar后面的版本能修正

[slievrly]

mark as bug

[yuchonghua]

我也很期待使用fescar，
期待问题得到解决

[xingfudeshi]

i have made one PR to fix this bug.but i still suggest to create tables by executing the SQL scripts as the undo_log can't be created automatically by JPA.

[wangpeng9910]

@xingfudeshi ok