JBOSS7 AS 部署war包，启动时报这个错，请教一下

0 0

JBOSS7 AS 部署war包，启动时报这个错，请教一下3

12:46:19,625 WARN [org.hibernate.service.jdbc.connections.internal.ConnectionPr
oviderInitiator] (MSC service thread 1-1) HHH000181: No appropriate connection p
rovider encountered, assuming application will be supplying connections
12:46:19,656 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-1) MSC0000
1: Failed to start service jboss.persistenceunit."shopweb.war#shopweb": org.jbos
s.msc.service.StartException in service jboss.persistenceunit."shopweb.war#shopw
eb": Failed to start service
        at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceCont
rollerImpl.java:1767) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
utor.java:886) [rt.jar:1.6.0_31]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:908) [rt.jar:1.6.0_31]
        at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: shopweb] Un
able to build EntityManagerFactory
        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Con
figuration.java:914)
        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Con
figuration.java:889)
        at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFa
ctory(HibernatePersistence.java:73)
        at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEn
tityManagerFactory(PersistenceUnitServiceImpl.java:162)
        at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.start(Persistence
UnitServiceImpl.java:85)
        at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(Se
rviceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
        at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceCont
rollerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
        ... 3 more
Caused by: org.hibernate.HibernateException: Connection cannot be null when 'hib
ernate.dialect' not set
        at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.determ
ineDialect(DialectFactoryImpl.java:97)
        at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.buildD
ialect(DialectFactoryImpl.java:67)
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcSer
vicesImpl.java:176)
        at org.hibernate.service.internal.StandardServiceRegistryImpl.configureS
ervice(StandardServiceRegistryImpl.java:75)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initialize
Service(AbstractServiceRegistryImpl.java:159)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService
(AbstractServiceRegistryImpl.java:131)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
71)
        at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.j
ava:2270)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2266
)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1735)
        at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactor
yImpl.java:84)
        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Con
figuration.java:904)
        ... 9 more

12:46:19,937 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015
870: Deploy of deployment "shopweb.war" was rolled back with failure message {"J
BAS014671: Failed services" => {"jboss.persistenceunit.\"shopweb.war#shopweb\""
=> "org.jboss.msc.service.StartException in service jboss.persistenceunit.\"shop
web.war#shopweb\": Failed to start service"}}
12:46:21,593 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) JBA
S015877: Stopped deployment shopweb.war in 1663ms
12:46:21,609 INFO [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBA
S014774: Service status report
JBAS014777:   Services which failed to start:      service jboss.persistenceunit
."shopweb.war#shopweb": org.jboss.msc.service.StartException in service jboss.pe
rsistenceunit."shopweb.war#shopweb": Failed to start service

12:46:21,609 ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-t
hreads - 1) {"JBAS014653: Composite operation failed and was rolled back. Steps
that failed:" => {"Operation step-2" => {"JBAS014671: Failed services" => {"jbos
s.persistenceunit.\"shopweb.war#shopweb\"" => "org.jboss.msc.service.StartExcept
ion in service jboss.persistenceunit.\"shopweb.war#shopweb\": Failed to start se
rvice"}}}}

/META-INF/persistence.xml配置如下:
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
    http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0">

<persistence-unit name="shopweb" transaction-type="RESOURCE_LOCAL">
               



</persistence-unit>
</persistence>

spring配置文件applicationContext.xml配置如下:

<bean
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
lazy-init="true">
<property name="systemPropertiesModeName" value="SYSTEM_PROPERTIES_MODE_OVERRIDE" />
<property name="ignoreResourceNotFound" value="true" />
<property name="locations">
<list>
<value>classpath:/jdbc.properties</value> jdbc.properties文件内容见后面
</list>
</property>
</bean>

<bean id="shopweb" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="initialSize" value="5" />
<property name="maxActive" value="100" />
<property name="minIdle" value="20" />
<property name="maxIdle" value="50" />
</bean>

jdbc.properties文件

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/shopweb
jdbc.username=root
jdbc.password=rootroot
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.show_sql=true
hibernate.format_sql=false

jboss7 Hibernate mysql