tomcat 6连接oracle配置数据源连接池的步骤
来源:互联网 发布:北大荒网络广播电视台 编辑:程序博客网 时间:2024/04/30 06:40
1,在C:/apache-tomcat-6.0.14/conf目录下修改 server.xml文件中找到GlobalNamingResources标签,在标签之间加入:如下代码 即
2,新建一个jnditest.jsp文件代码如下
运行后会控制台出现如下错误: javax.naming.NameNotFoundException: Name jdbc 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:137) at javax.naming.InitialContext.lookup(InitialContext.java:351) at org.apache.jsp.jnditest.index_jsp._jspService(index_jsp.java:81) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) 找不到数据源连接池
3,修改C:/apache-tomcat-6.0.14/conf目录下context.xml文件将这如下代码
WEB-INF/web.xml 覆盖原来代码:
WEB-INF/web.xml
再运行jnditest.jsp文件 控制台出现如下错误 org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at org.apache.jsp.jnditest.index_jsp._jspService(index_jsp.java:83) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130) ... 20 more
4,将MySql连接的数据库包拷贝到 C:/apache-tomcat-6.0.14/lib 下
5,再运行jnditest.jsp文件 网页屏幕上会输出如下: startjdbc:mysql://localhost:3306/hy_0506?autoReconnect=true, UserName=root@localhost, MySQL-AB JDBC Driver
配置数据JNDI成功
- tomcat 6连接oracle配置数据源连接池的步骤
- Tomcat数据源连接池的配置
- 配置Tomcat的连接池和数据源
- Tomcat数据源,连接池配置
- Tomcat配置数据源连接池
- Tomcat 连接池 数据源配置
- TOMCAT数据源连接配置
- 配置Tomcat的连接池和数据源(以oracle数据库为例)
- 配置MSSQL数据源连接步骤:
- 配置Tomcat数据源和连接池
- Tomcat中配置数据源连接池
- Tomcat配置DataSource,连接池数据源
- Tomcat配置DataSource,连接池数据源
- Tomcat中配置数据源和连接池
- tomcat配置数据源与连接池
- Tomcat 【中配置连接池和数据源】
- Tomcat中配置数据源和连接池
- MyEclipse 中 Tomcat 配置数据源和连接池的问题~
- 稳扎稳打Silverlight(45) - 4.0浏览器外运行(Out Of Browser)之被信任的应用程序(Trusted Application)
- 我想要一個DOS的編程教程誰給我一個
- MultiByteToWideChar和WideCharToMultiByte用法详解
- 让php5.2和php5.3共存于一个Apache中(Windows)
- EVC相关
- tomcat 6连接oracle配置数据源连接池的步骤
- 每日学习笔记(7)
- C++ 中extern "C"含义深层探索
- 初始化顺序问题
- 网站创业不仅仅是复制、粘贴
- 魔王抓住了公主 等笑话
- 算法导论学习笔记-第二十二章-图的基本算法
- 网络日志(2010.8.20)
- 两年了,才出第一个软件