mysql数据库连接池在虚拟机上无法使用
mysql数据库连接池在虚拟机上无法使用,在本地却一切正常,很郁闷谁能帮帮我?
这个是WEB-INF/web.xml
程序代码:
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" 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_2_5.xsd">
<servlet>
<display-name>控制器</display-name>
<servlet-name>ControlServlet</servlet-name>
<servlet-class>
HappyLiving.Control.ControlServlet
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ControlServlet</servlet-name>
<url-pattern>/next</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
<web-app version="2.5" 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_2_5.xsd">
<servlet>
<display-name>控制器</display-name>
<servlet-name>ControlServlet</servlet-name>
<servlet-class>
HappyLiving.Control.ControlServlet
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ControlServlet</servlet-name>
<url-pattern>/next</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
这个是WEB-INF/mvc-config.xml
程序代码:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mvc-config SYSTEM "mvc-config.dtd">
<mvc-config>
<datasource>
<name>java:comp/env/jdbc/gamejoy</name>
</datasource>
<actions>
<!-- 导航到首页 -->
<action>
<cmd>index</cmd>
<next-page>/WEB-INF/form/index.jsp</next-page>
<actionclass>HappyLiving.Action.ForwardAction</actionclass>
</action>
</actions>
</mvc-config>
<!DOCTYPE mvc-config SYSTEM "mvc-config.dtd">
<mvc-config>
<datasource>
<name>java:comp/env/jdbc/gamejoy</name>
</datasource>
<actions>
<!-- 导航到首页 -->
<action>
<cmd>index</cmd>
<next-page>/WEB-INF/form/index.jsp</next-page>
<actionclass>HappyLiving.Action.ForwardAction</actionclass>
</action>
</actions>
</mvc-config>
这个是WEB-INF/mvc-config.dtd
程序代码:
<?xml version="1.0" encoding="UTF-8"?>
<!ELEMENT mvc-config (jdbc-config?,datasource?,actions)>
<!ELEMENT jdbc-config (driverclass,url,user,password)>
<!ELEMENT driverclass (#PCDATA)>
<!ELEMENT url (#PCDATA)>
<!ELEMENT user (#PCDATA)>
<!ELEMENT password (#PCDATA)>
<!ELEMENT datasource (name)>
<!ELEMENT name (#PCDATA)>
<!ELEMENT actions (action*)>
<!ELEMENT action (cmd,next-page,actionclass)>
<!ELEMENT cmd (#PCDATA)>
<!ELEMENT next-page (#PCDATA)>
<!ELEMENT actionclass (#PCDATA)>
<!ELEMENT mvc-config (jdbc-config?,datasource?,actions)>
<!ELEMENT jdbc-config (driverclass,url,user,password)>
<!ELEMENT driverclass (#PCDATA)>
<!ELEMENT url (#PCDATA)>
<!ELEMENT user (#PCDATA)>
<!ELEMENT password (#PCDATA)>
<!ELEMENT datasource (name)>
<!ELEMENT name (#PCDATA)>
<!ELEMENT actions (action*)>
<!ELEMENT action (cmd,next-page,actionclass)>
<!ELEMENT cmd (#PCDATA)>
<!ELEMENT next-page (#PCDATA)>
<!ELEMENT actionclass (#PCDATA)>
这个是META-INF/context.xml
程序代码:
<Context>
<Resource name="jdbc/gamejoy" auth="Container"
type="javax.sql.DataSource" maxActive="500" maxIdle="300"
maxWait="10000" logAbandoned="true"
driverClassName="com.mysql.jdbc.Driver"
username="数据库名"
password="数据库密码"
url="jdbc:mysql://IP地址:3306/数据库名" />
</Context>
<Resource name="jdbc/gamejoy" auth="Container"
type="javax.sql.DataSource" maxActive="500" maxIdle="300"
maxWait="10000" logAbandoned="true"
driverClassName="com.mysql.jdbc.Driver"
username="数据库名"
password="数据库密码"
url="jdbc:mysql://IP地址:3306/数据库名" />
</Context>
麻烦各位帮帮我,在本地是好好的,但丢到虚拟主机上就不行了,虚拟主机是Linux操作系统,跟这个应该没关系吧?Tomcat是5.5版本,mysql是4.0版本
先谢谢各位了
搜索更多相关主题的帖子:
虚拟机 数据库连接池 mysql
----------------解决方案--------------------------------------------------------