JNDI在Maven项目的配置问题

最新推荐文章于 2023-07-03 18:56:21 发布

singular港

最新推荐文章于 2023-07-03 18:56:21 发布

阅读量1.4k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： JavaEE SSM 基础文章标签： JNDI Mybatis

本文链接：https://blog.youkuaiyun.com/qq_38264999/article/details/96052946

基础同时被 3 个专栏收录

17 篇文章

订阅专栏

JavaEE

7 篇文章

订阅专栏

SSM

6 篇文章

订阅专栏

本文介绍了如何使用JNDI在MyBatis中配置数据源，包括Maven项目的搭建、context.xml文件的设置以及SqlMapConfig.xml中的配置更改。同时，针对配置过程中可能遇到的错误进行了详细的解析。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、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"        连接url字符串
 />
 -->
    <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>
    <!--mybatis环境的配置-->
    <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