JNDI在Maven项目的配置问题

系统管理员 2021-12-09 00:35 245阅读 0赞

一、JNDI的配置

JNDI：Java Naming and Directory Interface。是SUN公司推出的一套规范，属于JavaEE技术之一。目的是模仿windows系统中的注册表。在服务器中注册数据源。

4.1、创建Maven的WAR工程，并导入坐标。

<?xml version="1.0" encoding="UTF-8"?>
    
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
    
      <groupId>cn.waggag.mybatis</groupId>
      <artifactId>MybatisDeno6_JNDI</artifactId>
      <version>1.0-SNAPSHOT</version>
      <packaging>war</packaging>
      <dependencies>
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.4.5</version>
        </dependency>
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.16</version>
        </dependency>
        <dependency>
          <groupId>log4j</groupId>
          <artifactId>log4j</artifactId>
          <version>1.2.16</version>
        </dependency>
        <dependency>
          <groupId>junit</groupId>
          <artifactId>junit</artifactId>
          <version>4.12</version>
        </dependency>
        <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>jsp-api</artifactId>
          <version>2.0</version>
        </dependency>
        <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>servlet-api</artifactId>
          <version>2.5</version>
        </dependency>
      </dependencies>
      <build>
        <resources>
          <resource>
            <directory>src/main/java</directory>
            <includes>
              <include>**/*.xml</include>
            </includes>
          </resource>
          <resource>
            <directory>src/main/resources</directory>
            <includes>
              <include>**/*.xml</include>
              <include>**/*.properties</include>
            </includes>
          </resource>
        </resources>
      </build>
    </project>

4.2、在webapp文件下创建META-INF目录，并在里面加入context.xml

<?xml version="1.0" encoding="UTF-8"?>
    <Context>
    
        <Resource
                name="jdbc/ssm"
                type="javax.sql.DataSource"
                auth="Container"
                maxActive="20"
                maxWait="10000"
                maxIdle="5"
                username="waggag"
                password="225514"
                driverClassName="com.mysql.cj.jdbc.Driver"
                
                url="jdbc:mysql://localhost:3306/ssm?serverTimezone=UTC"  
        />
    </Context>

4.3、修改在SqlMapConfig.xml中的配置

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        
        <environments default="mysql">
            <environment id="mysql">
                <transactionManager type="JDBC"></transactionManager>
                <dataSource type="JNDI">
                   <property name="data_source" value="java:comp/env/jdbc/ssm"/>
                </dataSource>
            </environment>
        </environments>
        <mappers>
            <mapper resource="cn/waggag/mapper/UserMapper.xml"></mapper>
        </mappers>
    </configuration>

其中value="java:comp/env/"为固定写法，后面加上配置的数据源名称

二、配置JNDI遇到的错误

2.1、出错信息

org.apache.ibatis.exceptions.PersistenceException: 
    ### Error building SqlSession.
    ### The error may exist in SQL Mapper Configuration
    ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.datasource.DataSourceException: There was an error configuring JndiDataSourceTransactionPool. Cause: javax.naming.NameNotFoundException: Name [jdbc/ssm] is not bound in this Context. Unable to find [jdbc].
    	org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    	org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:80)
    	org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:64)
    	org.apache.jsp.index_jsp._jspService(index_jsp.java:149)
    	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
    	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
    	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    Root Cause
    
    org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.datasource.DataSourceException: There was an error configuring JndiDataSourceTransactionPool. Cause: javax.naming.NameNotFoundException: Name [jdbc/ssm] is not bound in this Context. Unable to find [jdbc].
    	org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:121)
    	org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:99)
    	org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:78)
    	org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:64)
    	org.apache.jsp.index_jsp._jspService(index_jsp.java:149)
    	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
    	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
    	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    Root Cause
    
    org.apache.ibatis.datasource.DataSourceException: There was an error configuring JndiDataSourceTransactionPool. Cause: javax.naming.NameNotFoundException: Name [jdbc/ssm] is not bound in this Context. Unable to find [jdbc].
    	org.apache.ibatis.datasource.jndi.JndiDataSourceFactory.setProperties(JndiDataSourceFactory.java:60)
    	org.apache.ibatis.builder.xml.XMLConfigBuilder.dataSourceElement(XMLConfigBuilder.java:326)
    	org.apache.ibatis.builder.xml.XMLConfigBuilder.environmentsElement(XMLConfigBuilder.java:280)
    	org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:116)
    	org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:99)
    	org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:78)
    	org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:64)
    	org.apache.jsp.index_jsp._jspService(index_jsp.java:149)
    	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
    	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
    	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    Root Cause
    
    javax.naming.NameNotFoundException: Name [jdbc/ssm] is not bound in this Context. Unable to find [jdbc].
    	org.apache.naming.NamingContext.lookup(NamingContext.java:817)
    	org.apache.naming.NamingContext.lookup(NamingContext.java:159)
    	org.apache.naming.NamingContext.lookup(NamingContext.java:827)
    	org.apache.naming.NamingContext.lookup(NamingContext.java:159)
    	org.apache.naming.NamingContext.lookup(NamingContext.java:827)
    	org.apache.naming.NamingContext.lookup(NamingContext.java:173)
    	org.apache.naming.SelectorContext.lookup(SelectorContext.java:163)
    	javax.naming.InitialContext.lookup(InitialContext.java:417)
    	org.apache.ibatis.datasource.jndi.JndiDataSourceFactory.setProperties(JndiDataSourceFactory.java:56)
    	org.apache.ibatis.builder.xml.XMLConfigBuilder.dataSourceElement(XMLConfigBuilder.java:326)
    	org.apache.ibatis.builder.xml.XMLConfigBuilder.environmentsElement(XMLConfigBuilder.java:280)
    	org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:116)
    	org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:99)
    	org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:78)
    	org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:64)
    	org.apache.jsp.index_jsp._jspService(index_jsp.java:149)
    	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
    	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
    	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

2.2、出错原因

META-INF写错，导致无法加载content.xml