Spring Boot Jndi不起作用，Tomcat也没有开始

Question

我正在处理Spring Boot应用程序，并且尝试使用JNDI连接数据源，但是它不起作用，并且给我以下错误，请提供帮助，如果有人知道原因：

这是它显示的错误：

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'i': Invocation of init method failed; 
nested exception is org.springframework.jndi.JndiLookupFailureException: JndiObjectTargetSource failed to obtain new target object; 
nested exception is javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, 
or in an application resource file:  java.naming.factory.initial

for pom.xml依赖关系文件i i i已包括以下依赖项：

<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jdbc</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-devtools</artifactId>
        <scope>runtime</scope>
        <optional>true</optional>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-tomcat</artifactId>
        <scope>provided</scope>
    </dependency>

    <!-- Added from here -->
    <dependency>
        <groupId>org.apache.tomcat.embed</groupId>
        <artifactId>tomcat-embed-jasper</artifactId>
        <scope>provided</scope>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
    </dependency>

    <dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <version>42.2.25</version>
    </dependency>

当我使用PostgreSQL数据库时，我使用了它的依赖项和application.properties文件，我提到的如下所述：

## Spring DATASOURCE (DataSourceAutoConfiguration & DataSourceProperties)
# Datasource settings
spring.datasource.initialize=true
spring.datasource.jndi-name=jdbc/IDB

spring.jmx.enabled: false
spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://localhost:5432/postgres
spring.datasource.username=postgres
spring.datasource.password=ROOT
spring.datasource.type=javax.sql.DataSource
spring.datasource.separator=;

对于tomcat上下文命名初始化，我将bean定义为以下：

@Bean
public TomcatServletWebServerFactory tomcatFactory() {
    return new TomcatServletWebServerFactory() {
        @Override
        protected TomcatWebServer getTomcatWebServer(Tomcat tomcat) {
            tomcat.enableNaming();
            try {
                tomcat.addContext("/aiv/appimages", imgLoc);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            return super.getTomcatWebServer(tomcat);
        }

        @Override
        protected void postProcessContext(org.apache.catalina.Context context) {
            ContextResource resource = new ContextResource();
            resource.setName("jdbc/ActiveIDB");
            resource.setType(DataSource.class.getName());

            resource.setProperty("driverClassName", "org.postgresql.Driver");
            resource.setProperty("url", "jdbc:postgresql://localhost:5432/postgres");
            resource.setProperty("username", "postgres");
            resource.setProperty("password", "ROOT");

            context.getNamingResources().addResource(resource);
        }
    };
}


@Bean(destroyMethod="")
public DataSource dataSource() throws IllegalArgumentException, NamingException {
    JndiObjectFactoryBean bean = new JndiObjectFactoryBean();
    bean.setJndiName("java:comp/env/jdbc/IDB");
    bean.setProxyInterface(DataSource.class);
    bean.setLookupOnStartup(false);
    bean.afterPropertiesSet();
    return (DataSource)bean.getObject();
}

请任何人都可以让我知道什么是我是错误的，为什么它给我这个错误。帮助批准。

Answer 1

您必须做5件事：

1. tomcat.enablenaming（）;
2. （使用相同的名称： jdbc/idb 和 jdbc/activeIdb 具有不同的哈希码：））
3. 将contextresource添加到namingResources name: jdbc/DS_NAME
4. add org.springframework:spring-jdbc (class EmbeddedDatabaseType) to classpath (it will activate JndiDataSourceAutoConfiguration)

at this moment, spring will try to create datasource but fails, because of org.apache.tomcat.dbcp class不在classpath中（是javax.sql.datasource 资源的默认工厂 resources）

5. .dbcp2.basicdatasourcefactory 它包含org.apache.tomcat.dbcp.dbcp.dbcp.basicdatasourcefactory

---

 package com.example;

 import org.apache.catalina.Context;
 import org.apache.catalina.startup.Tomcat;
 import org.apache.tomcat.util.descriptor.web.ContextResource;
 import org.springframework.boot.SpringApplication;
 import org.springframework.boot.autoconfigure.SpringBootApplication;
 import org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory;
 import org.springframework.boot.web.embedded.tomcat.TomcatWebServer;
 import org.springframework.context.annotation.Bean;

 import javax.servlet.ServletException;
 import javax.sql.DataSource;
 import java.io.IOException;
 import java.sql.SQLException;

 @SpringBootApplication
 public class Application {

     /**
      * Or you can copy full implementation from
      * org.springframework.boot.autoconfigure.web.servlet.ServletWebServerFactoryConfiguration.EmbeddedTomcat
      * override only getTomcatWebServer(Tomcat)
      * and provide TomcatContextCustomizer instead of overriding 'postProcessContext(Context)'
      */
     @Bean
     public TomcatServletWebServerFactory tomcatServletWebServerFactory() {
         return new TomcatServletWebServerFactory() {

             @Override
             protected TomcatWebServer getTomcatWebServer(Tomcat tomcat) {
                 //1 enable naming
                 tomcat.enableNaming();
                 return super.getTomcatWebServer(tomcat);
             }

             @Override
             protected void postProcessContext(Context context) {
                 //2 create resource
                 ContextResource resource = new ContextResource();
                 resource.setName("jdbc/h2DS");
                 resource.setType(DataSource.class.getName());
                 resource.setProperty("driverClassName", "org.h2.Driver");
                 resource.setProperty("url", "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE");
                 resource.setProperty("username", "sa");
                 resource.setProperty("password","");
                 context.getNamingResources().addResource(resource);
             }
         };
     }

     public static void main(String[] args) throws ServletException, IOException, SQLException {
         //3 JndiDataSourceAutoConfiguration will provide that bean if
         // a) spring.datasource.jndi-name: jdbc/h2DS
         // b) org.springframework:spring-jdbc (class EmbeddedDatabaseType) is in classpath
         SpringApplication.run(Application.class, args)
             .getBean(DataSource.class)
             .getConnection();
     }
 }
 

---

8.5.4 [或

1. ）
2. ：
3. hier版本] （ ：2.1.214（运行时）
4. org.apache.tomcat：tomcat-dbcp：8.5.4 [或hier]（runtime）

---

application.properties

spring.datasource.jndi-name=jdbc/h2DS