@Configuration
public class DataSourceConfig { public final static String WRITE_DATASOURCE_KEY = "writeDruidDataSource";
public final static String READ_DATASOURCE_KEY = "readDruidDataSource"; @ConfigurationProperties(prefix = "spring.datasource.read")
@Bean(name = READ_DATASOURCE_KEY)
public DataSource readDruidDataSource() {
DataSource aa=DataSourceBuilder.create().build(); return aa;
} @ConfigurationProperties(prefix = "spring.datasource.write")
@Bean(name = WRITE_DATASOURCE_KEY)
@Primary
public DataSource writeDruidDataSource() {
return DataSourceBuilder.create().build();
} /**
* 注入AbstractRoutingDataSource
*
* @param readDruidDataSource
* @param writeDruidDataSource
* @return
* @throws Exception
*/
@Bean
public AbstractRoutingDataSource routingDataSource(
@Qualifier(READ_DATASOURCE_KEY) DataSource readDruidDataSource,
@Qualifier(WRITE_DATASOURCE_KEY) DataSource writeDruidDataSource) throws Exception {
DynamicDataSource dataSource = new DynamicDataSource();
Map<Object, Object> targetDataSources = new HashMap<Object, Object>();
targetDataSources.put(WRITE_DATASOURCE_KEY, writeDruidDataSource);
targetDataSources.put(READ_DATASOURCE_KEY, readDruidDataSource);
dataSource.setTargetDataSources(targetDataSources);// 配置数据源
dataSource.setDefaultTargetDataSource(writeDruidDataSource);// 默认为主库用于写数据 return dataSource;
}
}
.yml文件设制规则,也没有用
jpa:
database: mysql
show-sql: true
database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
hibernate:
ddl-auto: update
naming:
physical-strategy: org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy
现在所有实体都要把大写改为小写,项目才能运行,如userId,要改为user_id。
请大神指点指点。
public class DataSourceConfig { public final static String WRITE_DATASOURCE_KEY = "writeDruidDataSource";
public final static String READ_DATASOURCE_KEY = "readDruidDataSource"; @ConfigurationProperties(prefix = "spring.datasource.read")
@Bean(name = READ_DATASOURCE_KEY)
public DataSource readDruidDataSource() {
DataSource aa=DataSourceBuilder.create().build(); return aa;
} @ConfigurationProperties(prefix = "spring.datasource.write")
@Bean(name = WRITE_DATASOURCE_KEY)
@Primary
public DataSource writeDruidDataSource() {
return DataSourceBuilder.create().build();
} /**
* 注入AbstractRoutingDataSource
*
* @param readDruidDataSource
* @param writeDruidDataSource
* @return
* @throws Exception
*/
@Bean
public AbstractRoutingDataSource routingDataSource(
@Qualifier(READ_DATASOURCE_KEY) DataSource readDruidDataSource,
@Qualifier(WRITE_DATASOURCE_KEY) DataSource writeDruidDataSource) throws Exception {
DynamicDataSource dataSource = new DynamicDataSource();
Map<Object, Object> targetDataSources = new HashMap<Object, Object>();
targetDataSources.put(WRITE_DATASOURCE_KEY, writeDruidDataSource);
targetDataSources.put(READ_DATASOURCE_KEY, readDruidDataSource);
dataSource.setTargetDataSources(targetDataSources);// 配置数据源
dataSource.setDefaultTargetDataSource(writeDruidDataSource);// 默认为主库用于写数据 return dataSource;
}
}
.yml文件设制规则,也没有用
jpa:
database: mysql
show-sql: true
database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
hibernate:
ddl-auto: update
naming:
physical-strategy: org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy
现在所有实体都要把大写改为小写,项目才能运行,如userId,要改为user_id。
请大神指点指点。
解决方案 »
- 关于tomcat的连续刷新问题????(在线等,大家进来讨论一下)
- eclipse中的奇怪问题
- 启动了Tomcat,但无法打开jsp页面
- jsp页面和SERVELET的访问
- 某个区域的图片问题
- 关于用正则达到日期格式从12时制转到24时制的问题,高手帮忙!!!!!!!!!!!!!
- applet 与 servlet 通讯(请帮我纠错),急..........
- JSP排序问题(在线等待)
- 100分,jspsmartupload大家帮忙看看这里http://expert.csdn.net/Expert/topic/1274/1274742.xml?temp=.527218
- 这里的try后面代码是什么意思呀都?
- springboot项目 前后端分离 前端代码应该写在哪
- javaweb的项目,公司买的框架,现在项目下所有的jsp都报错Unable to compile class for JSP,求大神解惑
2019-06-01 12:15:58.826 WARN 12409 --- [nio-8080-exec-8] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1146, SQLState: 42S02
2019-06-01 12:15:58.827 ERROR 12409 --- [nio-8080-exec-8] o.h.engine.jdbc.spi.SqlExceptionHelper : Table 'oto.SysUser' doesn't exist
https://blog.csdn.net/newhanzhe/article/details/81287874