Spring Boot jndi 설정좀 봐주세요...

Question

Failed to look up JNDI DataSource with name오류가 나는데 도저히 이유를 모르겠습니다...굳이 JDNI 를 사용하는 의미가 있나 싶지만... JNDI를 요구하네요...package com.test.config.app.jndi.local; import javax.sql.DataSource; import org.apache.catalina.Context; import org.apache.catalina.startup.Tomcat; import org.apache.tomcat.util.descriptor.web.ContextResource; import org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory; import org.springframework.boot.web.embedded.tomcat.TomcatWebServer; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Profile; &#64;Profile(&#34;local&#34;) &#64;Configuration public class TomcatEmbdded { &#64;Bean TomcatServletWebServerFactory tomcatFactory() { return new TomcatServletWebServerFactory() { &#64;Override protected TomcatWebServer getTomcatWebServer(Tomcat tomcat) { tomcat.enableNaming(); return super.getTomcatWebServer(tomcat); } &#64;Override protected void postProcessContext(Context context) { ContextResource resource1 &#61; new ContextResource(); resource1.setName(&#34;jdbc/devhp&#34;); resource1.setType(DataSource.class.getName()); resource1.setAuth(&#34;Container&#34;); resource1.setProperty(&#34;driverClassName&#34;, &#34;com.microsoft.sqlserver.jdbc.SQLServerDriver&#34;); resource1.setProperty(&#34;url&#34;, &#34;jdbc:sqlserver://아이피:1433;databaseName&#61;DB명;encrypt&#61;true;trustServerCertificate&#61;true&#34;); resource1.setProperty(&#34;username&#34;, &#34;계정&#34;); resource1.setProperty(&#34;password&#34;, &#34;비번&#34;); resource1.setProperty(&#34;factory&#34;, &#34;org.apache.commons.dbcp2.BasicDataSourceFactory&#34;); ContextResource resource2 &#61; new ContextResource(); resource2.setName(&#34;jdbc/devci&#34;); resource2.setType(DataSource.class.getName()); resource2.setAuth(&#34;Container&#34;); resource2.setProperty(&#34;driverClassName&#34;, &#34;com.microsoft.sqlserver.jdbc.SQLServerDriver&#34;); resource2.setProperty(&#34;url&#34;, &#34;jdbc:sqlserver://아이피:1433;databaseName&#61;DB명;encrypt&#61;true;trustServerCertificate&#61;true&#34;); resource2.setProperty(&#34;username&#34;, &#34;계정&#34;); resource2.setProperty(&#34;password&#34;, &#34;비번&#34;); resource2.setProperty(&#34;factory&#34;, &#34;org.apache.commons.dbcp2.BasicDataSourceFactory&#34;); context.getNamingResources().addResource(resource1); context.getNamingResources().addResource(resource2); } }; } }application-local.ymlserver: port: 8080 spring: first: datasource: jndi-name: java:comp/env/jdbc/devhp second: datasource: jndi-name: java:comp/env/jdbc/devcipackage com.test.config.app; import javax.naming.NamingException; import javax.sql.DataSource; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.session.SqlSessionFactory; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.SqlSessionTemplate; import org.mybatis.spring.annotation.MapperScan; import org.mybatis.spring.boot.autoconfigure.SpringBootVFS; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Primary; import org.springframework.core.io.ClassPathResource; import org.springframework.core.io.support.PathMatchingResourcePatternResolver; import org.springframework.jdbc.datasource.DataSourceTransactionManager; import org.springframework.jdbc.datasource.lookup.JndiDataSourceLookup; import org.springframework.transaction.PlatformTransactionManager; import org.springframework.transaction.annotation.EnableTransactionManagement; &#64;Configuration &#64;EnableTransactionManagement &#64;MapperScan(basePackages &#61; {&#34;com.test.app.mapper.first.**&#34;}, annotationClass &#61; Mapper.class, sqlSessionFactoryRef &#61; &#34;firstSqlSessionFactory&#34;) public class FirstDataSourceConfig { private static final String MYBATIS_CONFIG_LOCATION &#61; &#34;mybatis/mybatis-config.xml&#34;; private static final String MYBATIS_MAPPER_LOCATION &#61; &#34;classpath:mybatis/mappers/first/**/*.xml&#34;; &#64;Primary &#64;Bean(name &#61; &#34;firstDataSource&#34;) DataSource firstDataSource() throws IllegalArgumentException, NamingException { JndiDataSourceLookup jndiDataSourceLookup &#61; new JndiDataSourceLookup(); return jndiDataSourceLookup.getDataSource(&#34;java:comp/env/jdbc/devhp&#34;); } &#64;Primary &#64;Bean(name &#61; &#34;firstTransactionManager&#34;) PlatformTransactionManager firstTransactionManager(&#64;Qualifier(&#34;firstDataSource&#34;) DataSource dataSource) { return new DataSourceTransactionManager(dataSource); } &#64;Primary &#64;Bean(name &#61; &#34;firstSqlSessionFactory&#34;) SqlSessionFactory firstSqlSessionFactory(&#64;Qualifier(&#34;firstDataSource&#34;) DataSource dataSource) throws Exception { SqlSessionFactoryBean sqlSessionFactory &#61; new SqlSessionFactoryBean(); sqlSessionFactory.setDataSource(dataSource); sqlSessionFactory.setConfigLocation(new ClassPathResource(MYBATIS_CONFIG_LOCATION)); sqlSessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(MYBATIS_MAPPER_LOCATION)); sqlSessionFactory.setVfs(SpringBootVFS.class); return sqlSessionFactory.getObject(); } &#64;Primary &#64;Bean(name &#61; &#34;firstSqlSessionTemplate&#34;) SqlSessionTemplate firstSqlSessionTemplate(&#64;Qualifier(&#34;firstSqlSessionFactory&#34;) SqlSessionFactory sqlSessionFactory) { return new SqlSessionTemplate(sqlSessionFactory); } }package com.test.config.app; import javax.naming.NamingException; import javax.sql.DataSource; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.session.SqlSessionFactory; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.SqlSessionTemplate; import org.mybatis.spring.annotation.MapperScan; import org.mybatis.spring.boot.autoconfigure.SpringBootVFS; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.core.io.ClassPathResource; import org.springframework.core.io.support.PathMatchingResourcePatternResolver; import org.springframework.jdbc.datasource.DataSourceTransactionManager; import org.springframework.jdbc.datasource.lookup.JndiDataSourceLookup; import org.springframework.transaction.PlatformTransactionManager; import org.springframework.transaction.annotation.EnableTransactionManagement; &#64;Configuration &#64;EnableTransactionManagement &#64;MapperScan(basePackages &#61; {&#34;com.test.app.mapper.second.**&#34;}, annotationClass &#61; Mapper.class, sqlSessionFactoryRef &#61; &#34;secondSqlSessionFactory&#34;) public class SecondDataSourceConfig { private static final String MYBATIS_CONFIG_LOCATION &#61; &#34;mybatis/mybatis-config.xml&#34;; private static final String MYBATIS_MAPPER_LOCATION &#61; &#34;classpath:mybatis/mappers/second/**/*.xml&#34;; &#64;Bean(name &#61; &#34;secondDataSource&#34;) DataSource secondDataSource() throws IllegalArgumentException, NamingException { JndiDataSourceLookup jndiDataSourceLookup &#61; new JndiDataSourceLookup(); return jndiDataSourceLookup.getDataSource(&#34;java:comp/env/jdbc/devci&#34;); } &#64;Bean(name &#61; &#34;secondTransactionManager&#34;) PlatformTransactionManager secondTransactionManager(&#64;Qualifier(&#34;secondDataSource&#34;) DataSource dataSource) { return new DataSourceTransactionManager(dataSource); } &#64;Bean(name &#61; &#34;secondSqlSessionFactory&#34;) SqlSessionFactory secondSqlSessionFactory(&#64;Qualifier(&#34;secondDataSource&#34;) DataSource dataSource) throws Exception { SqlSessionFactoryBean sqlSessionFactory &#61; new SqlSessionFactoryBean(); sqlSessionFactory.setDataSource(dataSource); sqlSessionFactory.setConfigLocation(new ClassPathResource(MYBATIS_CONFIG_LOCATION)); sqlSessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(MYBATIS_MAPPER_LOCATION)); sqlSessionFactory.setVfs(SpringBootVFS.class); return sqlSessionFactory.getObject(); } &#64;Bean(name &#61; &#34;secondSqlSessionTemplate&#34;) SqlSessionTemplate secondSqlSessionTemplate(&#64;Qualifier(&#34;secondSqlSessionFactory&#34;) SqlSessionFactory sqlSessionFactory) { return new SqlSessionTemplate(sqlSessionFactory); } }단순하게SELECT GETDATE()만 junit 으로 출력합니다.JNDI 로 변경하기 전에는 first, second 확인했습니다.오류는 내용이 많기는 하지만 눈에 띄는 부분은 다음과 같습니다.Caused by: org.springframework.jdbc.datasource.lookup.DataSourceLookupFailureException: Failed to look up JNDI DataSource with name 'java:comp/env/jdbc/devci'DataSource 부분만 엣지 코파일럿에서 답변해준 식으로 변경하면 에러가 또 다릅니다.... &#64;Primary &#64;Bean(name &#61; &#34;firstDataSource&#34;) DataSource firstDataSource() throws IllegalArgumentException, NamingException { // JndiDataSourceLookup jndiDataSourceLookup &#61; new JndiDataSourceLookup(); // return jndiDataSourceLookup.getDataSource(&#34;java:comp/env/jdbc/devhp&#34;); JndiObjectFactoryBean bean &#61; new JndiObjectFactoryBean(); bean.setJndiName(&#34;java:comp/env/jdbc/devhp&#34;); bean.setProxyInterface(DataSource.class); bean.setLookupOnStartup(false); bean.afterPropertiesSet(); return (DataSource) bean.getObject(); }org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transactionCaused by: org.springframework.jndi.JndiLookupFailureException: JndiObjectTargetSource failed to obtain new target objectCaused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or in an application resource file: java.naming.factory.initial

kdk1026 · Answer

아... junit 테스트는 안되는 거였네요...실행해보니 컨트롤러는 동작합니다.

Spring Boot jndi 설정좀 봐주세요...

1개의 답변

#jndi 목록