eclipse+mysql+tomcat配置JNDI

 

配置环境：Tomcat5.5、MySQL4.1 、mysql-connector-java-<st1:chsdate isrocdate="False" w:st="on" year="1899" day="30" islunardate="False" month="12">5.0.0</st1:chsdate>-beta 、commons-dbcp-1.2.1、 JDK1.5以上的“东东”在网上都能够下到的。<o:p></o:p>

然后在D:\Tomcat5.5\webapps\新建目录DBtest文件夹，DBtest下建这样几个目录：WEB-INF、META-INF，在WEB-INF下创建两个文件夹和两个文件分别为classes、lib、web.xml、Test.jsp，在META-INF下创建context.xml(为什么要创建这个文件我也不太清楚<v:shapetype id="_x0000_t75" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" filled="f" stroked="f" coordsize="21600,21600" o:spt="75"> <v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v:path o:connecttype="rect" o:extrusionok="f" gradientshapeok="t"></v:path><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape id="_x0000_i1025" style="WIDTH: 14.25pt; HEIGHT: 14.25pt" alt="" type="#_x0000_t75"><v:imagedata src="file:///C:\DOCUME~1\ＴＥＡ~1\LOCALS~1\Temp\msohtml1\01\clip_image001.gif" o:href="Tomcat5_5配置MySQL数据库连接池%20%5b和讯博客%5d.files/emembarrassed.gif"></v:imagedata></v:shape>，哪位高手知道还请多指教)<o:p></o:p>

接下来就要把JDBC驱动程序mysql-connector-java-<st1:chsdate isrocdate="False" w:st="on" year="1899" day="30" islunardate="False" month="12">5.0.0</st1:chsdate>-beta和commons-dbcp-1.2.1解压，分别将解压后的.jar文件分别复制到D:\Tomcat5.5\common\lib下，以上工作做完就可以进行连接池的配置了。<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

1、配置D:\Tomcat 5.5\conf\server.xml在server.xml中的<globalnamingresources></globalnamingresources>中添加如下配置信息：<o:p></o:p>

<resource name="Test"></resource>        type="javax.sql.DataSource"
        driverClassName="com.mysql.jdbc.Driver"
        password="yang" 
        maxIdle="2"
        maxWait="5000"
        username="root"
        url="jdbc:mysql://localhost:3306/math"
        maxActive="4"/><o:p></o:p>

注：name是连接池的名字可任取，type，是数据源的类型，driverClassName是驱动程序的类名好像得这么写，url是数据库的路径math为数据库名。<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

2、配置D:\Tomcat 5.5\webapps\DBtest\WEB-INF\web.xml在<web-app></web-app>中加入如入信息<o:p></o:p>

 <resource-ref></resource-ref>
     <description></description>DB Connection
     <res-ref-name></res-ref-name>Test
     <res-type></res-type>javax.sql.DataSource
     <res-auth></res-auth>Container
 <o:p></o:p>

注：其中的res-ref-name必须和前面的连接池名相同。<o:p></o:p>

<o:p> </o:p>

3、配置D:\Tomcat 5.5\webapps\DBtest\META-INF\context.xml全部内容如下<o:p></o:p>

<context path="/DBTest" docbase="DBTest"></context>         debug="5"
         reloadable="true"
         crossContext="true">
        
         <resourcelink type="javax.sql.DataSourcer" name="Test" global="Test"></resourcelink>
        
<o:p></o:p>

注：path是工作区的路径，ResourceLink name和global好像都得和前面的连接池的名字相同，这里的global有什么用我也不太清楚啦，不好意思，嘻嘻！！<o:p></o:p>

<o:p> </o:p>

<o:p>

java 代码

package app;



import java.sql.*;

import javax.naming.*;

import javax.sql.DataSource;

/*

public class dbManager

{

       public static synchronized Connection getConnection() throws Exception

       {

              try

              {

                     Context initctx = new javax.naming.InitialContext();

                     Context envctx = (Context)initctx.lookup("java:comp/env");

                     DataSource ds = (DataSource)envctx.lookup("jdbc/Test");

                     return ds.getConnection();

              }

              catch (Exception ex)

              {

                     throw ex;

              }

       }

}

*/

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.sql.DataSource;

public class dbManager

{

  final static private boolean VERBOSE = true; //打印控制台控制

  //static Logger logger = Logger.getLogger(dbManager.class.getName());

  private Context initCtx = null;

  private Context ctx = null;

  private DataSource ds = null;

  private long timeout = 5000;

  public dbManager()

  {

         try

         {

                initCtx = new InitialContext();

  //init context，read config web.xml

                if (initCtx == null)

                {

                       throw new Exception("Initial Failed!");

                }

                ctx = (Context) initCtx.lookup("java:comp/env");

  //find "jdbc/SqlServerDB" object  this configruation in the SERVER.XML of Tomcat

                if (ctx != null)

                {

                       ds = (DataSource) ctx.lookup("jdbc/Test");

                }

                if (ds == null)

                {

                       throw new Exception("Look up DataSource Failed!");

                }

             }

              catch (Exception e)

              {



                     log(e, "Can’t get the Context!");



              }

  }

        public synchronized Connection getConnection() {

       //get connection and set to delay time

       long startTime = new java.util.Date().getTime();

       Connection con = null;

       while (con == null) {

         con = newConnection();

         if (con != null) {

           //log("Create New Connection!");

           break;

         }

         try {

           log("连接超时，重新连接，等待" + timeout + "ms");

           wait(timeout);

         }

         catch (InterruptedException e) {

           log(e, "连接超时!");

         }

         if ( (new java.util.Date().getTime() - startTime) >= timeout) {

           log("Connection timeout!");

           break;

         }

       }

       return con;

       }

       private Connection newConnection() {

       Connection con = null;

       try {

         con = ds.getConnection();

         if (con == null) {

           throw new Exception("Create Connection Failed!");

         }

       }

       catch (Exception e) {

         log("Create Connection Failed!");

         System.out.println(e.getMessage());

       }

       return con;

       }

       public synchronized void freeConnection(Connection conn,

                           Statement stmt,

                           PreparedStatement pstmt) {

       try {

       //close Statement

       if (stmt != null) {

         stmt.close();

         stmt = null;

         //log("Close Statement......");

       }

       //close  PreparedStatement

       if (pstmt != null) {

         pstmt.close();

         pstmt = null;

         //log("Close PreparedStatement......");

       }

       }

       catch (Exception e) {

       System.out.println(e.getMessage());

       }

       try {

       //close Connection

       if (conn != null) {

         conn.close();

         conn = null;

         //log("Close Connection......");

       }

       }

       catch (SQLException e) {

       log(e, "释放资源出错!");

       }

       }

/************************************

* write log file.

* @param s String

************************************/

       private void log(String s)

       {

              if (VERBOSE)

              {

                     System.out.println(new java.util.Date() + ":" + s);

              //logger.info(new java.util.Date()+s);

              }

       }

       private void log(Throwable e, String msg)

       {

              System.out.println(new java.util.Date() + ": " + msg);

       }

}

 

</o:p>

• triman.rar (1007.4 KB)
• 描述: eclipse+mysql+tomcat配置JNDI实现例子
• 下载次数: 130

分享到：

郁闷的一天 | JavaBean数据库连接池

• 2007-06-10 11:12
• 浏览 5745
• 评论(2)
• 查看更多

评论

2 楼 like1988 2012-01-05  

谢谢分享！！！

1 楼 linxuewei 2007-06-20  

正需要