Use Spring multiDataSource in chaos

Asked Dec 15 '16 at 02:36

Active Dec 15 '16 at 02:38

Viewed 24 times

In my project, I want method A,B use database1, and all other methods use database2. Now I write like this in controller

DataSourceHolder.putDataSource("db1");
String code = methodA();//for get some
DataSourceHolder.putDataSource("db2");
methodC(code);
...
DataSourceHolder.putDataSource("db1");
methodB(code);//for set some
DataSourceHolder.putDataSource("db2");

In most cases, it runs normally. But while many people visit my webset, it may use wrong dataSource. Some data can not be saved or updated.

edited Dec 15 '16 at 02:38

asked Dec 15 '16 at 02:36

doubleevil

does not seem very threadsafe – Scary Wombat Dec 15 '16 at 02:38
so, how should i do? – doubleevil Dec 15 '16 at 02:41
Use ThreadLocal in DataSourceHolder to store dataSource – Sangram Jadhav Dec 15 '16 at 12:44
Where is that `DataSourceHolder` class defined, is it similar to the one in [this post?](http://www.roytuts.com/define-multiple-datasources-in-spring/) – kewne Dec 15 '16 at 14:22

Use Spring multiDataSource in chaos

0 Answers0