配置Jndi数据源遇到的一个问题

最新推荐文章于 2024-09-15 20:41:28 发布

oneDayOnePureSmile

最新推荐文章于 2024-09-15 20:41:28 发布

阅读量4.1k

点赞数 2

分类专栏： database 文章标签： Jndi DataSource mysql jdbc

本文链接：https://blog.csdn.net/tianjiaoxiaoyong/article/details/80759275

版权

database 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

因为之前大多配置的是jdbc连接方式,偶然一次用到了jndi连接方式,遇到了个比较头疼的问题,故记录下来,方便以后查阅.

异常如下:

Caused by: javax.naming.NameNotFoundException: Name mysqlDataSource is not bound in this Context
   at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
   at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
   at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
   at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
   at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
   at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
   at org.apache.naming.SelectorContext.lookup(SelectorContext.java:152)
   at javax.naming.InitialContext.lookup(InitialContext.java:417)
   at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:155)
   at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:87)
   at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:152)
   at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:179)
   at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:95)
   at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:106)
   at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:231)
   at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:217)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)

... 27 more

检测配置文件.

注入的配置文件如下

运行时就会出现上面的异常Name mysqlDataSource is not bound in this Context

在实例化JndiTemplate时去找我配置的mysqlDataSource驱动

java:/comp/env/这里是上下文环境.

因为找不到我的mysqlDataSource,所以就报错了.

然后去看JndiName源码介绍.

Convenient superclass for JNDI-based service locators,
* providing configurable lookup of a specific JNDI resource.
*
* <p>Exposes a {@link #setJndiName "jndiName"} property. This may or may not
* include the "java:comp/env/" prefix expected by J2EE applications when
* accessing a locally mapped (Environmental Naming Context) resource. If it
* doesn't, the "java:comp/env/" prefix will be prepended if the "resourceRef"
* property is true (the default is <strong>false</strong>) and no other scheme

* (e.g. "java:") is given.

大意是需要给JndiName配置一个JNDI数据源,这个数据源是包括 "java;comp/env"为前缀的的数据源.

会去访问上下文中配置的映射源.然而并没有配置这个映射.

如果没找到就会去找resourceRef这个预先的数据源配置.

很遗憾,这里我也没有配置...就蹦沙卡拉卡了...

于是,在web.xml里面加入引用的资源

    <resource-ref>
       <description>MYSQL DB Connection</description>
       <res-ref-name>mysqlDataSource</res-ref-name>
       <res-type>javax.sql.DataSource</res-type>
       <res-auth>Container</res-auth>
   </resource-ref>

注意res-ref-name配置的Jndi名,要与配置文件中的jndiName后面的(去掉java:/comp/env/上下文)一致.

res-type指定数据源是dataSource

res-auth指定容器启动时加载.

再次启动就可以正常启动了.