SSH配置MYSQL数据池的错误,哪位大侠能帮忙?谢谢啦

diypyh diypyh 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
架构:SSH ,MYECLIPSE9.0 , TOMCAT6.0 , MYSQL5.0

说明:mysql数据库服务是开启的,用户名,密码,URL,驱动都正确,驱动JAR包分别都放在TOMCAT和项目的LIB目录里了。

此项目是根据“李兴华老师的《我的智囊团J2EE项目实训视频》”来做的,一步一步都是跟着他做,可是他成功了,而我却出现了以下的错误,查了几天的互联网都没有得到答案,谢谢啦。

异常如下:
org.hibernate.exception.GenericJDBCException: Cannot open connection

struts-config.xml

<controller processorClass="org.springframework.web.struts.DelegatingRequestProcessor"></controller>
<message-resources parameter="com.pyh.iask.struts.ApplicationResources" />
<plug-in className="org.springframework.web.struts.ContextLoaderPlugIn">
<set-property property="contextConfigLocation" value="/WEB-INF/classes/applicationContext.xml" />
</plug-in>


项目WEBROOT下的web.xml

<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/iask</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/classses/applicationContext.xml</param-value>
</context-param>
<servlet>
<servlet-name>context</servlet-name>
<servlet-class>org.springframework.web.context.ContextLoaderServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>


applicationContext.xml

<bean id="dataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/jdbc/iask"></property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop key="hibernate.connection.autocommit">true</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/pyh/iask/pojo/User.hbm.xml</value></list>
</property></bean>
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
<property name="sessionFactory">
<ref bean="sessionFactory"/>
</property>
</bean>
<bean id="iuserdao" class="com.pyh.iask.dao.IUserDAO" abstract="true"></bean>
<bean id="userdaoimpl" class="com.pyh.iask.dao.impl.UserDAOImpl" parent="iuserdao">
<property name="hibernateTemplate">
<ref bean="hibernateTemplate"/>
</property>
</bean>
<bean name="/jsp/user" class="com.pyh.iask.struts.action.UserAction">
<property name="iuserdao">
<ref bean="userdaoimpl"/>
</property>
</bean>


TOMCAT服务器里的server.xml

<Context path="/iaskdemo" docBase="C:\Documents and Settings\Administrator\Workspaces\MyEclipse 9\IaskDemo\WebRoot"
debug="5" reloadable="true" crossContext="true">

<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_MysqlTest_log." suffix=".txt"
timestamp="true"/>

<Resource name="jdbc/iask" auth="Container" type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/iask">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>mysqladmin</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/iask</value>
</parameter>
</ResourceParams>
</Context>


UserAction

package com.pyh.iask.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.pyh.iask.dao.IUserDAO;
import com.pyh.iask.struts.form.UserForm;
import com.pyh.iask.util.IPTime;
public class UserAction extends DispatchAction {
private IUserDAO iuserdao ;
public ActionForward register(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
UserForm userForm = (UserForm) form;// TODO Auto-generated method stub
if (userForm.getPhoto() == null
|| userForm.getPhoto().getFileSize() == 0) {
userForm.getUser().setPhoto("nophoto.jpeg");
} else {
userForm.getUser().setPhoto(
new IPTime(request.getRemoteAddr()).getIPTime()
+ userForm
.getPhoto()
.getFileName()
.substring(
userForm.getPhoto().getFileName()
.lastIndexOf(".")));
}
try{
this.iuserdao.doRegister(userForm.getUser()) ;
request.getSession().setAttribute("userid", userForm.getUser().getUserid()) ;
request.getSession().setAttribute("grade", userForm.getUser().getGrade()) ;
return mapping.findForward("registersuccess") ;
}catch(Exception e){
e.printStackTrace() ;
request.setAttribute("reg", e) ;
return mapping.getInputForward() ;
}
}

public IUserDAO getIuserdao() {
return iuserdao;
}

public void setIuserdao(IUserDAO iuserdao) {
this.iuserdao = iuserdao;
}
}
...全文
评论 3
收藏 已收藏
分享
返回顶部
diypyh
Java EE 67,535 成员 225,843 内容