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.
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.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货