Tomcat里部署网站项目文件，总是有错，各位抽空看看。

Question

错误是这样的：
2009-6-6 14:32:56 org.apache.catalina.core.ApplicationContext log
信息: Loading Spring root WebApplicationContext
2009-6-6 14:33:00 org.apache.catalina.core.StandardContext listenerStart
严重: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [applicationContext.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
Caused by: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:422)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:804)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:744)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131)
at com.city3s.hibernate.HibernateSessionFactory.afterPropertiesSet(HibernateSessionFactory.java:31)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:270)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)
at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

Answer 1

公司以前的一个人做的，中途走了，让我接手的。现在我在自己的机器上怎么都跑不起来。applicationContext.xml文件的内容中有这样一段：
 <bean id="dataSource" class="com.city3s.hibernate.CommonDataSource">
    <property name="type" value="${jdbc.type}"/>
    <property name="host" value="${jdbc.host}"/>
    <property name="port" value="${jdbc.port}"/>
    <property name="databaseName" value="${jdbc.databaseName}"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
  </bean>
  <bean id="sessionFactory" class="com.city3s.hibernate.HibernateSessionFactory">
    <property name="dataSource">
      <ref bean="dataSource"/>
    </property>
    <property name="annotatedClasses">
      <list>
        <value>com.city3s.affiche.entity.Affiche</value>
        <value>com.city3s.language.Locale</value>
        <value>com.city3s.language.LanguageText</value>
        <value>com.city3s.map.entity.MapEntity</value>
        <value>com.city3s.map.entity.UnitType</value>
        <value>com.city3s.map.entity.EnterpriseType</value>
        <value>com.city3s.map.entity.Unit</value>
        <value>com.city3s.map.entity.UnitType</value>
        <value>com.city3s.map.entity.Surface</value>
        <value>com.city3s.common.entity.Property</value>
        <value>com.city3s.map.entity.Building</value>
        <value>com.city3s.map.entity.Mistake</value>
        <value>com.city3s.map.entity.Notepaper</value>
        <value>com.city3s.map.entity.MapHotKeyword</value>
        <value>com.city3s.company.entity.Enterprise</value>
        <value>com.city3s.company.entity.EnterpriseBBS</value>
        <value>com.city3s.channel.entity.ChannelSubType</value>
        <value>com.city3s.channel.entity.ChannelCommend</value>
        <value>com.city3s.channel.entity.NewsInformation</value>
        <value>com.city3s.channel.entity.CateInformation</value>
        <value>com.city3s.channel.entity.FriendInformation</value>
        <value>com.city3s.channel.entity.RealtyInformation</value>
        <value>com.city3s.channel.entity.JobInformation</value>
        <value>com.city3s.channel.entity.JobPosition</value>
        <value>com.city3s.crm.entity.Customer</value>
        <value>com.city3s.crm.entity.Proprietor</value>
        <value>com.city3s.map.entity.Leave</value>
        <value>com.city3s.map.entity.LeaveReply</value>
        <value>com.city3s.map.traffic.entity.SimpleTaximeter</value>
        <value>com.city3s.member.entity.MemberType</value>
        <value>com.city3s.member.entity.EntityMember</value>
        <value>com.city3s.member.entity.EnterpriseMember</value>
        <value>com.city3s.member.entity.ScorePolicy</value>
        <value>com.city3s.member.ad.entity.MemberAd</value>
        <value>com.city3s.member.channel.entity.MemberChannel</value>
        <value>com.city3s.ad.entity.Ad</value>
        <value>com.city3s.ad.entity.KeywordAd</value>
        <value>com.city3s.ad.entity.MapAd</value>
        <value>com.city3s.member.friend.entity.MemberFriendGroup</value>
        <value>com.city3s.member.friend.entity.MemberFriend</value>
        <value>com.city3s.member.entity.MemberAccount</value>
        <value>com.city3s.member.map.entity.MemberMap</value>
        <value>com.city3s.member.map.entity.MemberMapAd</value>
        <value>com.city3s.member.map.entity.MemberMapLink</value>
        <value>com.city3s.member.map.entity.MemberMapEffect</value>
        <value>com.city3s.map.file.FileEntity</value>
        <value>com.city3s.member.entity.MemberMessage</value>
        <value>com.city3s.member.entity.MemberMessageFolder</value>
        <value>com.city3s.member.entity.MemberLoginRecord</value>
        <value>com.city3s.enterprise.entity.EnterpriseAffiche</value>
        <value>com.city3s.enterprise.entity.EnterpriseParam</value>
        <value>com.city3s.enterprise.entity.EnterpriseProduct</value>
        <value>com.city3s.member.forum.entity.Forum</value>
        <value>com.city3s.member.entity.EnterpriseUpdateRecord</value>
        <value>com.city3s.pay.entity.PayParam</value>
        <value>com.city3s.pay.entity.PayRecord</value>
        <value>com.city3s.map.entity.MapAdUnitType</value>
      </list>
    </property>
    <property name="hibernateProperties">
      <props>
        <prop key="hibernate.connection.autocommit">false</prop>
      </props>
    </property>另外，上面bean id="dataSource"提到的参数是：
jdbc.type=SQLServer2000
jdbc.host=127.0.0.1
jdbc.port=1433
jdbc.databaseName=map
jdbc.username=sa
jdbc.password=kuzi
<bean id="dataSource" class="com.city3s.hibernate.CommonDataSource">
<bean id="sessionFactory" class="com.city3s.hibernate.HibernateSessionFactory">这两行是不是说他用的是自己的hibernate？

Answer 2

1. Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener 
初始化错误，说明是web.xml里面的加载spring文件有错误。检查param-name有否写错，应是contextConfigLocation
2. Hibernate Dialect must be explicitly set 
说是hibernate方言有问题，检查hibernate.cfg.xml