为什么我不能在Tomcat 8中使用JNDI DataSource？

Question

我处于一种情况下，已经超过两天了，但无法使用JNDI获得数据库连接。

我得到了以下错误

org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = myDatabase忽略未知属性值:用于"description“属性的"My DataSource new”的值

我用的是Tomcat-8 Java-1.8，Spring-3和Maven 3.2.5。

我正在尝试在Tomcat中部署我的web应用程序。我创建了war，并将其放在TOMCAT/webapp目录中。

数据库的Tomcat/conf/server.xml文件配置

server.xml

<GlobalNamingResources>

<Resource name="jdbc/myDatabase"
              auth="Container"
              type="javax.sql.DataSource"
              factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
              driverClassName="oracle.jdbc.OracleDriver"
             url="jdbc:oracle:thin:@IpAddress:orcl"
              username="tomcat_dbrds"
              password="cmxinfa"
              initialSize="1"
              minIdle="1"
              maxIdle="1"
              maxActive="3"
              maxWait="1000"
              validationQuery="select 1 from dual"
              jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport(threshold=1500)"
            />
  </GlobalNamingResources>

Spring应用程序上下文内容

<jee:jndi-lookup id="monitoringDataSource" jndi-name="jdbc/myDatabase" expected-type="javax.sql.DataSource"/>   

web.xml含量

  <resource-ref>
    <description>My DataSource new</description>
    <res-ref-name>jdbc/myDatabase</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

我遗漏了什么？

我试过所有可能的配置，但都没有效果。

<Resource name="myDatabase" 
              global="monitords"
              factory="org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory"
              auth="Container"
              type="javax.sql.DataSource"
              username="tomcat_dbrds"
              password="cmxinfa"
              driverClassName="oracle.jdbc.OracleDriver"
              url="jdbc:oracle:thin:@myipaddress:1521:orcl"
              initialSize="20"
              maxWaitMillis="15000"
              maxTotal="100"
              maxIdle="20"
              defaultAutoCommit="true"
              />


<Resource name="jdbc/myDatabase"
          auth="Container"
          factory="org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory"
              type="javax.sql.DataSource"
              validationQuery="SELECT 1"
              validationInterval="30000"
              timeBetweenEvictionRunsMillis="30000"
              maxActive="20"
              maxIdle="10"
              minIdle="1"
              maxWait="20000"
              initialSize="20"
              removeAbandonedTimeout="60"
          removeAbandoned="true"
              logAbandoned="true"
              minEvictableIdleTimeMillis="30000"
              jmxEnabled="true"
              jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
              username="tomcat_dbrds"
              password="cmxinfa"
              driverClassName="oracle.jdbc.OracleDriver"
              url="jdbc:oracle:thin:@myipaddress:1521:orcl"/>




<Resource name="jdbc/myDatabase"
              auth="Container"
              type="javax.sql.DataSource"
              factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
              driverClassName="oracle.jdbc.OracleDriver"
             url="jdbc:oracle:thin:@myipaddress:1521:orcl"
              username="tomcat_dbrds"
              password="cmxinfa"
              initialSize="1"
              minIdle="1"
              maxIdle="1"
              maxActive="3"
              maxWait="1000"
              validationQuery="select 1 from dual"
              jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport(threshold=1500)"
            />

更新1 :

我已经从web.xml中删除了description标签，但是我仍然收到了相同的错误。我刚刚检查了服务器日志，实际错误在下面。我如何解决这个错误。

java.sql.SQLException:无法为连接URL“null”创建类的JDBC驱动程序

更新2:

堆栈跟踪

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
    at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:497)
    at com.globalss.dnb.monitor.dao.ApplicationConfig.<init>(ApplicationConfig.java:24)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)
    ... 43 more
Caused by: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'
    at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2160)
    at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2032)
    at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1532)
    at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
    ... 53 more
Caused by: java.lang.NullPointerException
    at oracle.jdbc.driver.OracleDriver.acceptsURL(OracleDriver.java:620)
    at java.sql.DriverManager.getDriver(DriverManager.java:299)
    at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2144)
    ... 57 more

Answer 1

tomcat_dir\conf\context.xml -工作过。使用eclipse-tomcat env。

Answer 2

将资源定义放在tomcat_dir\conf\context.xml中的上下文标记之间。

​

​