I have jboss portal 2.6.1_GA i want to use Ingres as database for portal. I 
have put in place ingres-ds.xml, portal-ingres-ds.xml, 
ingres-jdbc2-service.xml, ingres-jdbc-state-service.xml and i have removed 
similar files that were already in place, I am getting this exception when i 
start jboss portal:

===========
2007-08-31 12:17:45,334 DEBUG 
[org.jboss.portal.jems.hibernate.SessionFactoryBinder] Starting 
portal:service=Hibernate,type=Workflow
2007-08-31 12:17:45,334 DEBUG 
[org.jboss.portal.jems.hibernate.SessionFactoryBinder] Detecting dialect with 
datasource java:PortalDS ...
2007-08-31 12:17:45,334 DEBUG 
[org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: 
registering pool with interval 900000 old interval: 450000
2007-08-31 12:17:45,553 DEBUG 
[org.jboss.portal.jems.hibernate.SessionFactoryBinder] Starting failed 
portal:service=Hibernate,type=Workflow
org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for 
database: INGRES
        at 
org.jboss.portal.jems.hibernate.DialectFactory.determineDialect(DialectFactory.java:61)
        at 
org.jboss.portal.jems.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:233)
        at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at 
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
        at 
org.jboss.portal.jems.as.system.AbstractJBossService.start(AbstractJBossService.java:73)
        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at 
org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.execute(JBossServiceModelMBean.java:488)
        at 
org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.startService(JBossServiceModelMBean.java:454)
        at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at 
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
        at 
org.jboss.portal.jems.as.system.JBossServiceModelMBean$6.invoke(JBossServiceModelMBean.java:376)
======================

in portal-ingres-ds.xml i have this:

  | <datasources>
  |   <local-tx-datasource>
  |     <jndi-name>PortalDS</jndi-name>
  |     
<connection-url>jdbc:ingres://localhost:II7/jbossportaldb</connection-url>
  |     <driver-class>com.ingres.jdbc.IngresDriver</driver-class>
  |     <min-pool-size>5</min-pool-size>
  |     <max-pool-size>20</max-pool-size>
  |     <dialect>org.hibernate.dialect.IngresDialect</dialect>
  |   </local-tx-datasource>
  | </datasources>
  | 
  | 

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4079851#4079851

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4079851
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to