3 Replies Latest reply on Aug 31, 2007 3:57 AM by theute

    pointing portalds of jboss portal 2.6 to Ingres

    advaittrivedi
    advaittrivedi Aug 31, 2007 3:19 AM

      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>


      • 2519 Views
      • Tags: