tomcat7 + mysql5.1 + jdk1.7 采用连接池方法,在Myclipse中可以正常连接centos 中的MySQL(做了端口转发),但导出到centos 中之后却连接不上,哪位高手帮忙分析分析看看哪出了问题?本人新手,轻拍砖!
context.xml (在项目META-INF下)<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="true">
     <Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource" 
        maxActive="10" maxIdel="5" maxWait="1000" 
        username="root" password="jun19800427" 
        driverClassName="com.mysql.jdbc.Driver" 
        url="jdbc:mysql://localhost:3306/nxs" 
      />
</Context>
web.xml (项目WEB-INF下)<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0" 
xmlns="http://java.sun.com/xml/ns/javaee" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
  <display-name></display-name>
    <filter>
     <filter-name>struts2</filter-name>
     <filter-class>
      org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
     </filter-class>
  </filter>
  <filter-mapping>
     <filter-name>struts2</filter-name>
     <url-pattern>/*</url-pattern>
  </filter-mapping>
  <resource-ref>
   <description>DB Connection</description>
   <res-ref-name>jdbc/mysql</res-ref-name>
   <res-type>javax.sql.DataSource</res-type>
   <res-auth>Container</res-auth>
  </resource-ref>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>
数据库连接类 DBConn.javapackage action;import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
public class DBConn
{
    private Connection conn = null;
    
    public DBConn()
    {
        try{
            Context initCtx = new InitialContext();
            if (initCtx ==  null)
                throw new Exception();
            Context ctx = (Context) initCtx.lookup("java:comp/env");
 //           Object obj = (Object) ctx.lookup("jdbc/mysql");
 //           javax.sql.DataSource ds = (javax.sql.DataSource) obj;
            DataSource ds = (DataSource)ctx.lookup("jdbc/mysql");
            conn = ds.getConnection();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    
    public Connection getConn()
    {
        return this.conn;
    }
    
    public void close()
    {
        try {
            this.conn.close();
        } catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}
一个用于测试的类DBTest.java
package action;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.*;
import action.DBConn;
public class DBTest extends ActionSupport
{
private Connection conn=null;
private DBConn test = new DBConn();
    public String execute() throws Exception
    {
     conn = test.getConn();
        if (conn!=null){
         conn.close();
            return "DBTestOK";
        } else {
            return "DBTestBad";
        }
    }
}错误信息
Jul 18, 2013 9:33:46 PM org.apache.struts2.components.ServletUrlRenderer warn
WARNING: No configuration found for the specified action: 'dbconn.action' in nam
espace: ''. Form action defaulting to 'action' attribute's literal value.