2006-03-23 17:24:15 StandardContext[/balancer]org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]]
2006-03-23 17:24:15 StandardContext[/servlets-examples]ContextListener: contextInitialized()
2006-03-23 17:24:15 StandardContext[/servlets-examples]SessionListener: contextInitialized()
2006-03-23 17:24:16 StandardContext[/jsp-examples]ContextListener: contextInitialized()
2006-03-23 17:24:16 StandardContext[/jsp-examples]SessionListener: contextInitialized()
2006-03-23 17:24:49 StandardContext[/ssh]Initializing WebApplicationContext for Struts ActionServlet 'action', module ''
2006-03-23 17:24:57 StandardContext[/login]Initializing WebApplicationContext for Struts ActionServlet 'action', module ''
2006-03-23 17:25:06 StandardContext[/login]action: null
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Initialization of bean failed; nested exception is org.hibernate.MappingException: could not instantiate id generator
org.hibernate.MappingException: could not instantiate id generator
?at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:92)
?at org.hibernate.mapping.SimpleValue.createIdentifierGenerator(SimpleValue.java:151)
?at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:178)
?at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1005)
?at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:800)
?at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:726)
?at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059)
?at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)
?at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
?at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
?at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:269)
?at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320)
?at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
?at org.springframework.web.struts.ContextLoaderPlugIn.createWebApplicationContext(ContextLoaderPlugIn.java:353)
?at org.springframework.web.struts.ContextLoaderPlugIn.initWebApplicationContext(ContextLoaderPlugIn.java:296)
?at org.springframework.web.struts.ContextLoaderPlugIn.init(ContextLoaderPlugIn.java:225)
?at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:869)
?at org.apache.struts.action.ActionServlet.init(ActionServlet.java:336)
?at javax.servlet.GenericServlet.init(GenericServlet.java:256)
?at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
?at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:887)
?at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3959)
?at org.apache.catalina.core.StandardContext.start(StandardContext.java:4284)
?at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
?at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:850)
?at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:638)
?at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:320)
?at org.apache.catalina.core.StandardHost.install(StandardHost.java:875)
?at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:727)
?at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:477)
?at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1008)
?at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:394)
?at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
?at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1134)
?at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)
?at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)
?at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
?at org.apache.catalina.core.StandardService.start(StandardService.java:519)
?at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
?at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
?at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
?at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
?at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
?at java.lang.reflect.Method.invoke(Method.java:324)
?at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
?at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
Caused by: org.hibernate.MappingException: Dialect does not support sequences
?at org.hibernate.dialect.Dialect.getSequenceNextValString(Dialect.java:430)
?at org.hibernate.id.SequenceGenerator.configure(SequenceGenerator.java:65)
?at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:88)
?... 45 more
2006-03-23 17:25:06 StandardContext[/login]Marking servlet action as unavailable
2006-03-23 17:25:06 StandardContext[/login]Servlet /login threw load() exception
javax.servlet.UnavailableException
?at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:880)
?at org.apache.struts.action.ActionServlet.init(ActionServlet.java:336)
?at javax.servlet.GenericServlet.init(GenericServlet.java:256)
?at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
?at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:887)
?at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3959)
?at org.apache.catalina.core.StandardContext.start(StandardContext.java:4284)
?at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
?at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:850)
?at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:638)
?at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:320)
?at org.apache.catalina.core.StandardHost.install(StandardHost.java:875)
?at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:727)
?at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:477)
?at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1008)
?at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:394)
?at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
?at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1134)
?at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)
?at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)
?at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
?at org.apache.catalina.core.StandardService.start(StandardService.java:519)
?at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
?at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
?at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
?at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
?at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
?at java.lang.reflect.Method.invoke(Method.java:324)
?at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
?at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
2006-03-23 17:27:02 StandardWrapperValve[action]: Servlet action is currently unavailable
我用的開發環境:
jdk1.5
eclipse3.12?
myeclipse 4.1
?spring 1.2
hibernate3.0
數據庫服務器:sqlserver2000
數據庫驅動: jtds1.2
web服務器:toncat5.0
我要實現的功能是:當用戶登陸后顯示一個login連接，當用戶單擊這個連接時程序執行LoginAction.java
以下是程序的目錄結構：
src
? ---com
????? ----test
????????? ---hibernate
?????????????????? ----AbstractUser.java
?????????????????? ----SessionFactory.java
?????????????????? ----User.hbm.xml
?????????????????? ----User.java
????????? ----struts
????????????? --action
?????????????????? LoginAction.java
????????? -----UserDao.java
????????? -----UserDaoIMP.java
? -----WebRoot
????????? ----index.jsp
以下是applicationContext.xml的內容：
????? <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "<beans>
? <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
??<property name="driverClassName">
???<value>net.sourceforge.jtds.jdbc.Driver</value>
??</property>
??<property name="url">
???<value>jdbc:jtds:sqlserver://192.168.1.171:1433;DatabaseName=test;SelectMethod=cursor</value>
??</property>
??<property name="username">
???<value>sa</value>
??</property>
??<property name="password">
???<value></value>
??</property>
?</bean>
??????? <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
??<property name="dataSource">
???<ref local="dataSource" />
??</property>
??<property name="mappingResources">
???<list>
????<value>com/test/Hibernate/User.hbm.xml</value>
???</list>
??</property>
??<property name="hibernateProperties">
???<props>
????<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
????<prop key="hibernate.show_sql">true</prop>
???</props>
??</property>
?</bean>
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
??<property name="sessionFactory">
???<ref local="sessionFactory" />
??</property>
?</bean>
?<bean id="userDAO" class="com.test.UserDAOImp">
??<property name="sessionFactory">
???<ref local="sessionFactory" />
??</property>
?</bean>
?<bean id="userDAOProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
??<property name="transactionManager">
???<ref bean="transactionManager" />
??</property>
??<property name="target">
???<ref local="userDAO" />
??</property>
??<property name="transactionAttributes">
???<props>
????<prop key="insert*">PROPAGATION_REQUIRED</prop>
????<prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
????<prop key="is*">PROPAGATION_REQUIRED,readOnly</prop>
???</props>
??</property>
?</bean>
??? <bean name="/login" class="com.test.struts.action.LoginAction" singleton="false">
??<property name="userDAO">
???<ref bean="userDAOProxy" />
??</property>
??? </bean>
</beans>
UserDao.java的代碼：
package com.test;
public interface UserDAO {
?public abstract boolean isValidUser(String username, String password);
}
UserDaoIMP.java的代碼：
?package com.test;
import java.util.List;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
public class UserDAOImp extends HibernateDaoSupport implements UserDAO {
?private static String hql = "from User u where u.username=? and password=?";
?public boolean isValidUser(String username, String password) {
??String[] userlist=new String[2];
??userlist[0]=username;
??userlist[1]=password;
//??List userList = this.getHibernateTemplate().find(hql, (Object)username);
??List userList = this.getHibernateTemplate().find(hql,userlist);
??if (userList.size() > 0) {
???return true;
??}
??return false;
?}
}
LoginAction.java的代碼:
package com.test.struts.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.test.UserDAO;
public class LoginAction extends Action {
?private UserDAO userDAO;
?public UserDAO getUserDAO() {
??return userDAO;
?}
public void setUserDAO(UserDAO userDAO) {
??this.userDAO = userDAO;
?}
?public ActionForward execute(
??ActionMapping mapping,
??ActionForm form,
??HttpServletRequest request,
??HttpServletResponse response) {
??if (userDAO.isValidUser("test","test")) {
???return mapping.getInputForward();
??} else {
???return mapping.getInputForward();
?}
?}
}
index.jsp的內容：
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()
+":"+request.getServerPort()+path+"/";
%>
<html>
? <head>
??? </head>
?? <body>
? <a href="<%=basePath%>login.do">login</a>
? </body>
</html>
以下是hibernate自動生成的User.hbm.xml，hibernate.cfg.xml文件我已經刪除了。
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"<!--
??? Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
??? <class name="com.test.Hibernate.User" table="user" schema="dbo" catalog="test">
??????? <id name="id" type="integer">
??????????? <column name="ID" />
??????????? <generator class="sequence" />
??????? </id>
??????? <property name="username" type="string">
??????????? <column name="USERNAME" length="50" />
??????? </property>
??????? <property name="password" type="string">
??????????? <column name="PASSWORD" length="50" />
??????? </property>
??? </class>
</hibernate-mapping>
struts-config.xml的代碼如下:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "
<struts-config>
? <data-sources />
? <form-beans />
? <global-exceptions />
? <global-forwards />
? <action-mappings >
??? <action path="/login" type="org.springframework.web.struts.DelegatingActionProxy" />
?</action-mappings>
?<message-resources parameter="com.test.struts.ApplicationResources" />
? <plug-in className="org.springframework.web.struts.ContextLoaderPlugIn">
??? <set-property property="contextConfigLocation" value="/WEB-INF/applicationContext.xml" />
? </plug-in>
</struts-config>
讓人不解的是,當我點擊login連接時，出現了以下錯誤信息：
type Status report
message Servlet action is not available
description The requested resource (Servlet action is not available) is not available.
--------------------------------------------------------------------------------
當我把applicationContext.xml改成以下后：
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring
-beans.dtd">
<beans>
??????? <bean name="/login" class="com.test.struts.action.LoginAction" singleton="false">
?</bean>
</beans>
程序能夠正常運行并執行到了我設在LoginAction.java中的段點，由此看來，應該是
applicationContext.xml的配置出了問題,
但不知道問題出在什么地方？是不是數據源配錯了？？
?????????????????????