MyBatis 怎样使用JNDI连接数据库
发布网友
发布时间：2022-04-29 19:48
共3个回答
懂视网
时间：2022-04-30 00:09
第一步：Tomcat的conf/context.xml中的配置
加入数据库驱动文件
把数据库驱动的.jar文件，加入到Tomcat的commonlib中
应用程序的web.xml文件的配置
在web.xml中配置<resource-ref>
<?xml version=‘1.0‘ encoding=‘utf-8‘?> <!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. --> <!-- The contents of this file will be loaded for each web application --> <Context> <!-- Default set of monitored resources --> <WatchedResource>WEB-INF/web.xml</WatchedResource> <!-- Uncomment this to disable session persistence across Tomcat restarts --> <!-- <Manager pathname="" /> --> <!-- Uncomment this to enable Comet connection tacking (provides events on session expiration as well as webapp lifecycle) --> <!-- <Valve className="org.apache.catalina.valves.CometConnectionManagerValve" /> --> --红色字体是需要根据数据库名配置 <Resource name="jdbc/liuyan" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="epet" password="123456" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:orcl" /> </Context>
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
/**
* 文件名：JNDI.java
* 描 述：这是一个数据库连接类
* 作 者：WLX
* 所属项目：MyNews
* JDK版本：JDK1.7
* 创建时间：2015年5月23日 下午2:54:24
*
*/
public class JNDI {
public Connection getconn() {
Connection conn = null;
try {
Context ctx;
ctx = new InitialContext();
//java:comp/env/为前缀
DataSource source = (DataSource)ctx.lookup("java:comp/env/jdbc/liuyan");
Connection connection = source.getConnection();
if(connection != null){
conn = connection;
}
} catch (NamingException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
}
JNDI连接池连接Oracle数据库
标签：
热心网友
时间：2022-04-29 21:17
重点讲使用：
1.配置context.xml
注意地址是：tomcat安装目录下的conf，该目录下应该有了context.xml文件。貌似以前的版本是在项目目录中的META-INF目录下配置，我刚开始时参考是也是老版本的操作方法，谁知道试了一晚都不行。。。如果不是那里配置的话会可能出现这样的错误提示：javax.naming.NameNotFoundException: Name jdbc is not bound in this Context?
现在开始配置:
<Context path="/Manager" reloadable="true">
<Resource
name="hello"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
username="root"
password="123456"
maxIdle="4"
maxActive="4"
热心网友
时间：2022-04-29 22:35
