디비 변환

Question

혹시 알려주실분 계신가요?디비를 호출되는 메서드에 따라서 각각 다르게 연결하려고하는데밑에 로직에서 com/login2 or com/login 중 아무거나 호출해도 무조건 com/login 의 디비만 연결되는데 왜그런지 모르겠네여;;시큐리티에도 도메인명을 확실히 설정했는데 ㅜ 도와주실분계신가요 ?ㅜㅜc:\Users\USER\Documents\GitHub\gj_op\src\main\java\com\configuration\util\DBConfiguration.java@Configuration@PropertySource("classpath:/application.properties")public class DBConfiguration {@Beanpublic DataSource createRouterDatasource() {AbstractRoutingDataSource routingDataSource = new MyRoutingDataSource();Map targetDataSources = new HashMap<>();Object currentLookupKey = ((MyRoutingDataSource) routingDataSource).determineCurrentLookupKey();System.out.println("Current database key: " + currentLookupKey);if(currentLookupKey.equals("datasource1")){targetDataSources.put("datasource1",createDataSource("jdbc:log4jdbc:mariadb://test","root","0314"));}else if(currentLookupKey.equals("datasource2")){targetDataSources.put("datasource2",createDataSource("jdbc:log4jdbc:mariadb://test1/test?allowMultiQueries=true","test","test1234"));}routingDataSource.setTargetDataSources(targetDataSources);routingDataSource.afterPropertiesSet();return routingDataSource;}private DataSource createDataSource(String url,String user, String password) {com.zaxxer.hikari.HikariDataSource dataSource =new com.zaxxer.hikari.HikariDataSource();dataSource.setDriverClassName("net.sf.log4jdbc.sql.jdbcapi.DriverSpy");dataSource.setUsername(user);dataSource.setPassword(password);dataSource.setJdbcUrl(url);return dataSource;}c:\Users\USER\Documents\GitHub\gj_op\src\main\java\com\configuration\util\MyRoutingDataSource.javaprivate static final Logger logger = LoggerFactory.getLogger(MyRoutingDataSource.class);@Overrideprotected Object determineCurrentLookupKey() {ServletRequestAttributes attr = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();Object dbKey = "datasource1"; // 기본 데이터 소스 키 설정if (attr != null) {HttpServletRequest request = attr.getRequest();Cookie[] cookies = request.getCookies();if (cookies != null) {for (Cookie cookie : cookies) {if ("db_key".equals(cookie.getName())) {dbKey = cookie.getValue();break;}}}} else {logger.warn("ServletRequestAttributes not found. Using default DB Key: {}", dbKey);}return dbKey;c:\Users\USER\Documents\GitHub\gj_op\src\main\java\com\sy\controller\SystemController.java@RequestMapping(value = "/com/login")public String getCommon(HttpServletRequest request, Model model, HttpSession session,HttpServletResponse response) throws UnsupportedEncodingException {Cookie cookie = new Cookie("db_key", "datasource1");response.addCookie(cookie);DBConfiguration dbConf = new DBConfiguration();dbConf.createRouterDatasource();String path = request.getServletPath();Map param = new HashMap();param.put("path", path);path = path.substring(1);System.out.println(" PATH :: " + path);return path;}@RequestMapping(value = "/com/login2")public String getNewCommon(HttpServletRequest request, Model model, HttpSession session, HttpServletResponse response) {Cookie cookie = new Cookie("db_key", "datasource2");response.addCookie(cookie);DBConfiguration dbConf = new DBConfiguration();dbConf.createRouterDatasource();String path = request.getServletPath();Map param = new HashMap();param.put("path", path);path = path.substring(1);return path;}

Clickin · Answer

빈을 두개 등록하셔야합니다 스프링 빈은 싱글톤 방식이라 최초 1회만 생성되고 그 이후에는 계속 재사용합니다.

digitalNoMad · Answer

님, 아무리 급해도 IP, 아이디/패스워드는 주석 처리하셔야죠.

디비 변환

2개의 답변

기술 목록