My hibernate config properties
hibernate.connection.password=mit123
hibernate.connection.username=sa
hibernate.connection.driver_class=co
m.microsof
t.sqlserve
r.jdbc.SQL
ServerDriv
er
hibernate.dialect=org.hibernate.dial
ect.MSSQLD
ialect
hibernate.connection.url=jdbc:sqlser
ver://MIT-
EK-WEB18\S
QL2005;Dat
abaseName=
artfact-de
v
hibernate.connection.provider_class=
org.hibern
ate.connec
tion.Drive
rManagerCo
nnectionPr
ovider
hibernate.datasource=artfactMSSQLDat
asource
persistence xml file
<?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="artfact">
<provider>org.hibernate.ejb.Hibernat
ePersisten
ce</provid
er>
<jta-data-source>java:/artfactMSSQLD
atasource<
/jta-data-
source>
<mapping-file>META-INF/artfactMSSQLD
atasource.
xml</mappi
ng-file>
<properties>
<property name="hibernate.hbm2ddl.auto" value="create-drop"/>
<property name="hibernate.cache.use_query_cach
e" value="true"/>
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.format_sql" value="true"/>
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.query.jpaql_strict_c
ompliance"
value="false"/>
<!--<property name="hibernate.jdbc.use_get_generat
ed_keys" value="true"/>-->
<property name="hibernate.cache.provider_class
" value="org.jboss.ejb3.entity.TreeCac
heProvider
Hook"/>
<!--<property name="hibernate.query.factory_class"
value="org.hibernate.hql.classic.Cla
ssicQueryT
ranslatorF
actory"/>-
->
<property name="hibernate.treecache.mbean.obje
ct_name" value="jboss.cache:service=EJB3Entit
yTreeCache
"/>
<property name="jboss.entity.manager.factory.j
ndi.name" value="java:/artfactEntityManagerFac
tory"/>
<property name="com.intellij.javaee.persistenc
e.datasour
ce" value="artfactDatasource"/>
</properties>
</persistence-unit>
</persistence>
Is here any problem in setting hibernate dialect how to find the dialect for sql hibernate
following error occurs while running the application
ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- MBeans waiting for other MBeans ---
ObjectName: persistence.units:ear=artfact.ear,un
itName=art
fact
State: FAILED
Reason: javax.persistence.PersistenceExcepti
on: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
I Depend On:
jboss.jca:service=DataSourceBinding,
name=artfa
ctDatasour
ce
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: persistence.units:ear=artfact.ear,un
itName=art
fact
State: FAILED
Reason: javax.persistence.PersistenceExcepti
on: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
I Depend On:
jboss.jca:service=DataSourceBinding,
name=artfa
ctDatasour
ce
can any give solution for this problem