Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-30186

Liferay Portal Community Edition 6.1.1 CE GA2 connecting to informix9.4 issues

    Details

      Description

      With config in portlet-ext.properties,
      jdbc.default.driverClassName=com.informix.jdbc.IfxDriver
      jdbc.default.url=jdbc:informix-sqli://informix02:9500/portal:INFORMIXSERVER=portal02;DB_LOCALE=en_us.utf8
      dbc.default.username=xxxxxx
      jdbc.default.password=xxxxxx
      jdbc.default.liferay.pool.provider=dbcp
      jdbc.default.defaultAutoCommit=false
      jdbc.default.acquireIncrement=1
      jdbc.default.maxPoolSize=5
      jdbc.default.minPoolSize=1
      jdbc.default.numHelperThreads=4

      I get the following exceptions when i start liferay with informix database:
      02:11:39,364 ERROR [DialectDetector:116] org.apache.commons.dbcp.SQLNestedExcept
      ion: Cannot create PoolableConnectionFactory (Transactions not supported)
      org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact
      ory (Transactions not supported)
      at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
      rce.java:1225)
      at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
      .java:880)
      at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$Laz
      yConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourceProxy.j
      ava:403)
      at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$Laz
      yConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
      at $Proxy4.getMetaData(Unknown Source)
      at com.liferay.portal.spring.hibernate.DialectDetector.getDialect(Dialec
      tDetector.java:63)
      at com.liferay.portal.spring.hibernate.DialectDetector.determineDialect(
      DialectDetector.java:44)
      at com.liferay.portal.spring.hibernate.PortalHibernateConfiguration.dete
      rmineDialect(PortalHibernateConfiguration.java:52)
      at com.liferay.portal.spring.hibernate.PortalHibernateConfiguration.newC
      onfiguration(PortalHibernateConfiguration.java:83)
      at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessi
      onFactory(LocalSessionFactoryBean.java:549)
      at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPr
      opertiesSet(AbstractSessionFactoryBean.java:211)
      ----------------------

      Please see "Informix Connect" in Home » Liferay Portal » English » 1. Installation / Deployment / Setup » for more information about this bug.

        Attachments

          Activity

            People

            • Assignee:
              mika.koivisto Mika Koivisto
              Reporter:
              jane.gu@brandhub.co.nz jane (Inactive)
              Participants of an Issue:
              Recent user:
              Esther Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                6 years, 33 weeks, 2 days ago

                Packages

                Version Package
                6.0.6 GA
                6.1.1 CE GA2