Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Informix connect jane g September 10, 2012 3:09 PM
RE: Informix connect László Csontos September 14, 2012 9:18 AM
RE: Informix connect jane g September 16, 2012 2:57 PM
RE: Informix connect Hitoshi Ozawa September 16, 2012 4:53 PM
RE: Informix connect jane g September 16, 2012 7:18 PM
RE: Informix connect László Csontos September 17, 2012 4:49 AM
RE: Informix connect jane g September 17, 2012 3:32 PM
RE: Informix connect Hitoshi Ozawa September 17, 2012 5:10 PM
RE: Informix connect László Csontos September 18, 2012 1:27 AM
RE: Informix connect jane g September 18, 2012 7:55 PM
RE: Informix connect László Csontos September 21, 2012 1:13 PM
RE: Informix connect Hitoshi Ozawa September 22, 2012 7:42 PM
RE: Informix connect jane g September 23, 2012 10:47 PM
RE: Informix connect László Csontos September 24, 2012 2:09 AM
RE: Informix connect jane g September 24, 2012 2:25 PM
RE: Informix connect Hitoshi Ozawa September 24, 2012 3:16 PM
RE: Informix connect László Csontos September 24, 2012 11:54 PM
RE: Informix connect Hitoshi Ozawa September 25, 2012 5:50 PM
RE: Informix connect David H Nebinger September 25, 2012 6:50 PM
RE: Informix connect jane g September 26, 2012 8:05 PM
RE: Informix connect László Csontos September 28, 2012 10:59 AM
RE: Informix connect Hitoshi Ozawa September 29, 2012 3:40 PM
RE: Informix connect jane g October 10, 2012 1:22 AM
RE: Informix connect Mika Koivisto March 11, 2013 5:48 PM
RE: Informix connect Hitoshi Ozawa September 15, 2012 7:04 PM
jane g
Informix connect
September 10, 2012 3:09 PM
Answer

jane g

Rank: New Member

Posts: 13

Join Date: September 9, 2012

Recent Posts

hi all,
I am new to Liferay. I have problem to connect to informix 9.40. I have changed in ROOT.xml and portlet-ext.properties.
The changes in ROOT.xml
<Resource
name="jdbc/LiferayPool"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.informix.jdbc.IfxDriver"
url="jdbc:informix-sqli://informix02:9500/portal:INFORMIXSERVER=portal02"
username="xxxxxx"
password="xxxxxx"
db_locale="en_us.utf8"
maxActive="10"
maxIdle="3"
maxWait="10000" />

And 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.acquireIncrement=1
jdbc.default.maxPoolSize=5
jdbc.default.minPoolSize=1
jdbc.default.numHelperThreads=4

And i also copy informix .jar file in tomcat/lib/ext folder, but i still get exceptions:
java.sql.SQLException: Can't load driver java.lang.reflect.InvocationTargetException
at com.informix.util.IfxErrMsg.getLocSQLException(IfxErrMsg.java:497)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:279)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
László Csontos
RE: Informix connect
September 14, 2012 9:18 AM
Answer

László Csontos

Rank: New Member

Posts: 20

Join Date: June 15, 2012

Recent Posts

Hi Jane,

Could you please execute the following peace of code to test your connection to Informix?

 1import java.sql.Connection;
 2import java.sql.DriverManager;
 3
 4public class TestConnection {
 5
 6    public static void main(String args[]) {
 7
 8        String url="jdbc:informix-sqli://informix02:9500/portal" +
 9            ":INFORMIXSERVER=portal02";
10       
11        Connection connection = null;
12
13        try {
14
15            String driver = "com.informix.jdbc.IfxDriver";
16            Class.forName(driver).newInstance();
17            System.out.println("Obtained Informix driver.");
18        }
19        catch( Exception e ) {
20            System.out.println("Failed to load Informix driver.");
21            e.printStackTrace();
22            return;
23        }
24
25        try {
26            System.out.println("Using url: "+url);
27            connection = DriverManager.getConnection(
28                url, "username", "password");
29            System.out.println("Connected");
30        }
31        catch( Exception e ) {
32            e.printStackTrace();
33        }
34        finally {
35            if( connection != null ) {
36                try {
37                    connection.close();
38                }
39                catch( Exception e ) {
40                    e.printStackTrace();
41                }
42            }
43        }
44    }
45
46}


Most likely there is something wrong with the database server itself.

Are you able to connect to it from other applications (eg. IBM Data Studio)?

With best regards,
Laszlo Csontos
Support Engineer
Hitoshi Ozawa
RE: Informix connect
September 15, 2012 7:04 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Is there any reason you're defining informix connection as a resource but not referencing the resource in portal-ext.properties but defining informix connection again in the portal-ext.properties?

Do you want to define your connection as a resource in your application server or in liferay's portal-ext.properties?

#
# Set the JNDI name to lookup the JDBC data source. If none is set,
# then the portal will attempt to create the JDBC data source based on the
# properties prefixed with "jdbc.default.".
#
jdbc.default.jndi.name=jdbc/LiferayPool
jane g
RE: Informix connect
September 16, 2012 2:57 PM
Answer

jane g

Rank: New Member

Posts: 13

Join Date: September 9, 2012

Recent Posts

hi Laszlo Csontos,
Thanks for your reply. Yes we do have a couple of existing web applications connecting to the informix server. The JDBC_URL is copied from existing database connection code, so it should be ok. I need to add DB_LOCALE:en_us.utf8 in the JDBC_URL. Is the format correct:
jdbc.default.url=jdbc:informix-sqli://informix02:9500/portal:INFORMIXSERVER=portal02;DB_LOCALE=en_us.utf8

Also i copy my informix .jar files into Tomcat_home/lib/ext. Do i need to copy to other places in tomcat?
Hitoshi Ozawa
RE: Informix connect
September 16, 2012 4:53 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Also i copy my informix .jar files into Tomcat_home/lib/ext. Do i need to copy to other places in tomcat?


No. Where did you place portal-ext.properties file? Did you put it under ROOT\WEB-INF\classes.

Strongly suggest you and Laszlo to read Liferay's online User Guide.

http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/lp-6-1-ugen14-manual-configuration-1
jane g
RE: Informix connect
September 16, 2012 7:18 PM
Answer

jane g

Rank: New Member

Posts: 13

Join Date: September 9, 2012

Recent Posts

hi Hitoshi Ozawa,
Thanks. I comment out the database resource in ROOT.xml and only define it in
$CATALINA_HOME/webapps/ROOT/WEB-INF/classes/portal-ext.properties
I can connect to informix database now, but the server can't be started because of some errors.

Starting Liferay Portal Community Edition 6.1.1 CE GA2 (Paton / Build 6101 / July 31, 2012)
01:31:55,873 INFO [pool-2-thread-1][BaseDB:452] Database supports case sensitive queries
01:31:55,907 ERROR [pool-2-thread-1][JDBCExceptionReporter:76] Not in transaction.
01:31:55,913 ERROR [pool-2-thread-1][CustomSQLUtil:127]
java.lang.RuntimeException: Unable to get class name from value com.liferay.portal.model.Group
java.lang.RuntimeException: Unable to get class name from value com.liferay.portal.model.Group
at com.liferay.portal.service.impl.ClassNameLocalServiceImpl.getClassNameId(ClassNameLocalServiceImpl.java:149)
at com.liferay.portal.service.impl.ClassNameLocalServiceImpl.getClassNam
eId(ClassNameLocalServiceImpl.java:138)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Ser
viceBeanMethodInvocation.java:122)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(T
ransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Ser
viceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM
ethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Ser
viceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM
ethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Ser
viceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM
ethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Ser
viceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM
ethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Ser
----------------------------------------------------
Stopping the server due to unexpected startup errors

Any idea?
László Csontos
RE: Informix connect
September 17, 2012 4:49 AM
Answer

László Csontos

Rank: New Member

Posts: 20

Join Date: June 15, 2012

Recent Posts

Hi,

This one seems an Informix error:
101:31:55,907 ERROR [pool-2-thread-1][JDBCExceptionReporter:76] Not in transaction.


According to the documentation, this happens ...

In a database that has been created with logging, if a COMMIT statement is sent to the database server and autocommit mode is on, the error -255: Not in transaction is returned by the database server because there is currently no user transaction started. This occurs whether the COMMIT statement was sent with the Connection.commit( ) method or directly with an SQL statement.


Could you please try the following properties?

1jdbc.default.liferay.pool.provider=dbcp
2jdbc.default.defaultAutoCommit=false


If it doesn't work you can still revert back to the connection pool you have created in ROOT.xml and try to set defaultAutoCommit=false there. In this case you need to specify only the JNDI name of the data source in portal-ext.properties (I overlooked this on Friday).

1jdbc.default.jndi.name=jdbc/LiferayPool


Regards,
Laszlo.
jane g
RE: Informix connect
September 17, 2012 3:32 PM
Answer

jane g

Rank: New Member

Posts: 13

Join Date: September 9, 2012

Recent Posts

hi László Csontos,
Thanks for your reply. I have added the following in portal-ext.properties
jdbc.default.liferay.pool.provider=dbcp
jdbc.default.defaultAutoCommit=false

But i get the different exception which stops the server starts.
22:25:48,743 WARN [pool-2-thread-1][BaseDB:428] The specified table (quartz_tri
ggers) is not in the database.: create index IX_CD7132D0 on QUARTZ_TRIGGERS (SCH
ED_NAME, CALENDAR_NAME);

Starting Liferay Portal Community Edition 6.1.1 CE GA2 (Paton / Build 6101 / Jul
y 31, 2012)
22:25:51,693 INFO [pool-2-thread-1][BaseDB:452] Database supports case sensitiv
e queries
22:25:54,579 ERROR [pool-2-thread-1][JDBCExceptionReporter:76] Unique constraint
(informix.u135_70) violated.
22:25:54,586 ERROR [pool-2-thread-1][MainServlet:217] com.liferay.portal.kernel.
events.ActionException: com.liferay.portal.kernel.exception.SystemException: com
.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintV
iolationException: Could not execute JDBC batch update
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exce
ption.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hiber
nate.exception.ConstraintViolationException: Could not execute JDBC batch update

at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServl
et.java:1306)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
------------------------------------------------
Stopping the server due to unexpected startup errors
Hitoshi Ozawa
RE: Informix connect
September 17, 2012 5:10 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

I think you're using Liferay 6.1.x. Did you startup initially using Setup Wizard?
I've sometimes found Setup Wizard to cause problem.

Try extracting liferay bundle once again and setting the following property in portal-ext.properties before you startup liferay for the first time to turn off setup wizard.
Also, setup informix jdbc connections too.
#
# Set this property to true if the Setup Wizard should be displayed the
# first the portal is started.
#
setup.wizard.enabled=false
László Csontos
RE: Informix connect
September 18, 2012 1:27 AM
Answer

László Csontos

Rank: New Member

Posts: 20

Join Date: June 15, 2012

Recent Posts

jane g:
hi László Csontos,
Thanks for your reply. I have added the following in portal-ext.properties
jdbc.default.liferay.pool.provider=dbcp
jdbc.default.defaultAutoCommit=false

But i get the different exception which stops the server starts.
22:25:48,743 WARN [pool-2-thread-1][BaseDB:428] The specified table (quartz_tri
ggers) is not in the database.: create index IX_CD7132D0 on QUARTZ_TRIGGERS (SCH
ED_NAME, CALENDAR_NAME);

Starting Liferay Portal Community Edition 6.1.1 CE GA2 (Paton / Build 6101 / Jul
y 31, 2012)
22:25:51,693 INFO [pool-2-thread-1][BaseDB:452] Database supports case sensitiv
e queries
22:25:54,579 ERROR [pool-2-thread-1][JDBCExceptionReporter:76] Unique constraint
(informix.u135_70) violated.
22:25:54,586 ERROR [pool-2-thread-1][MainServlet:217] com.liferay.portal.kernel.
events.ActionException: com.liferay.portal.kernel.exception.SystemException: com
.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintV
iolationException: Could not execute JDBC batch update
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exce
ption.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hiber
nate.exception.ConstraintViolationException: Could not execute JDBC batch update

at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServl
et.java:1306)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
------------------------------------------------
Stopping the server due to unexpected startup errors


Hi Jane,

Could you please post or attach your full stack trace?
And could you try it again with a brand new bundle (as Hitoshi suggested) and with an empty database?

Thanks,
Laszlo
jane g
RE: Informix connect
September 18, 2012 7:55 PM
Answer

jane g

Rank: New Member

Posts: 13

Join Date: September 9, 2012

Recent Posts

yes, i use default Setup Wizard firstly, then i add portal-ext.properties. Now i try the brand new bundle with 6.1.1 and 6.0.6, but both get the following exceptions:
ps. I have turned on
jdbc.default.liferay.pool.provider=dbcp
jdbc.default.defaultAutoCommit=false
jdbc.default.acquireIncrement=5
jdbc.default.maxPoolSize=50
jdbc.default.minPoolSize=1
jdbc.default.numHelperThreads=4
in portal-ext.properties

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)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.ConstructorResolver.resolve
ConstructorArguments(ConstructorResolver.java:630)
at org.springframework.beans.factory.support.ConstructorResolver.instant
iateUsingFactoryMethod(ConstructorResolver.java:441)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:98
3)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:879)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:47)
at com.liferay.portal.spring.context.PortalContextLoaderListener.context
Initialized(PortalContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:4135)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
630)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
va:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
ava:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445
)
at org.apache.catalina.core.StandardService.start(StandardService.java:5
19)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.sql.SQLException: Transactions not supported
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:398)
at com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:18
64)
at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(Delegating
Connection.java:331)
at org.apache.commons.dbcp.PoolableConnectionFactory.activateObject(Pool
ableConnectionFactory.java:378)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas
icDataSource.java:1248)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:1221)
... 111 more
02:11:39,428 ERROR [PortalHibernateConfiguration:95] java.lang.RuntimeException:
No dialect found
java.lang.RuntimeException: No dialect found
at com.liferay.portal.spring.hibernate.DialectDetector.getDialect(Dialec
tDetector.java:124)
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)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.ConstructorResolver.resolve
ConstructorArguments(ConstructorResolver.java:630)
at org.springframework.beans.factory.support.ConstructorResolver.instant
iateUsingFactoryMethod(ConstructorResolver.java:441)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:98
3)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:879)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:47)
at com.liferay.portal.spring.context.PortalContextLoaderListener.context
Initialized(PortalContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:4135)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
630)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
va:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
ava:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445
)
at org.apache.catalina.core.StandardService.start(StandardService.java:5
19)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
02:11:39,613 ERROR [ContextLoader:220] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'serviceAdvice' defined in class path resource [META-INF/base-spring.xml]
: Cannot resolve reference to bean 'asyncAdvice' while setting bean property 'ne
xtMethodInterceptor'; nested exception is org.springframework.beans.factory.Bean
CreationException: Error creating bean with name 'asyncAdvice' defined in class
path resource [META-INF/base-spring.xml]: Cannot resolve reference to bean 'thre
adLocalCacheAdvice' while setting bean property 'nextMethodInterceptor'; nested
exception is org.springframework.beans.factory.BeanCreationException: Error crea
ting bean with name 'threadLocalCacheAdvice' defined in class path resource [MET
A-INF/base-spring.xml]: Cannot resolve reference to bean 'bufferedIncrementAdvic
e' while setting bean property 'nextMethodInterceptor'; nested exception is org.
springframework.beans.factory.BeanCreationException: Error creating bean with na
me 'bufferedIncrementAdvice' defined in class path resource [META-INF/base-sprin
g.xml]: Cannot resolve reference to bean 'transactionAdvice' while setting bean
property 'nextMethodInterceptor'; nested exception is org.springframework.beans.
factory.BeanCreationException: Error creating bean with name 'transactionAdvice'
defined in class path resource [META-INF/base-spring.xml]: Cannot resolve refer
ence to bean 'liferayTransactionManager' while setting bean property 'transactio
nManager'; nested exception is org.springframework.beans.factory.BeanCreationExc
eption: Error creating bean with name 'liferayTransactionManager' defined in cla
ss path resource [META-INF/hibernate-spring.xml]: Cannot resolve reference to be
an 'liferayHibernateSessionFactory' while setting constructor argument; nested e
xception is org.springframework.beans.factory.BeanCreationException: Error creat
ing bean with name 'liferayHibernateSessionFactory' defined in class path resour
ce [META-INF/hibernate-spring.xml]: Invocation of init method failed; nested exc
eption is java.lang.NullPointerException
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:47)
at com.liferay.portal.spring.context.PortalContextLoaderListener.context
Initialized(PortalContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:4135)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
630)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
va:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
ava:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445
)
at org.apache.catalina.core.StandardService.start(StandardService.java:5
19)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'asyncAdvice' defined in class path resource [META-INF/base-sp
ring.xml]: Cannot resolve reference to bean 'threadLocalCacheAdvice' while setti
ng bean property 'nextMethodInterceptor'; nested exception is org.springframewor
k.beans.factory.BeanCreationException: Error creating bean with name 'threadLoca
lCacheAdvice' defined in class path resource [META-INF/base-spring.xml]: Cannot
resolve reference to bean 'bufferedIncrementAdvice' while setting bean property
'nextMethodInterceptor'; nested exception is org.springframework.beans.factory.B
eanCreationException: Error creating bean with name 'bufferedIncrementAdvice' de
fined in class path resource [META-INF/base-spring.xml]: Cannot resolve referenc
e to bean 'transactionAdvice' while setting bean property 'nextMethodInterceptor
'; nested exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'transactionAdvice' defined in class path resource
[META-INF/base-spring.xml]: Cannot resolve reference to bean 'liferayTransactio
nManager' while setting bean property 'transactionManager'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'liferayTransactionManager' defined in class path resource [META-INF/hibe
rnate-spring.xml]: Cannot resolve reference to bean 'liferayHibernateSessionFact
ory' while setting constructor argument; nested exception is org.springframework
.beans.factory.BeanCreationException: Error creating bean with name 'liferayHibe
rnateSessionFactory' defined in class path resource [META-INF/hibernate-spring.x
ml]: Invocation of init method failed; nested exception is java.lang.NullPointer
Exception
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
... 40 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'threadLocalCacheAdvice' defined in class path resource [META-
INF/base-spring.xml]: Cannot resolve reference to bean 'bufferedIncrementAdvice'
while setting bean property 'nextMethodInterceptor'; nested exception is org.sp
ringframework.beans.factory.BeanCreationException: Error creating bean with name
'bufferedIncrementAdvice' defined in class path resource [META-INF/base-spring.
xml]: Cannot resolve reference to bean 'transactionAdvice' while setting bean pr
operty 'nextMethodInterceptor'; nested exception is org.springframework.beans.fa
ctory.BeanCreationException: Error creating bean with name 'transactionAdvice' d
efined in class path resource [META-INF/base-spring.xml]: Cannot resolve referen
ce to bean 'liferayTransactionManager' while setting bean property 'transactionM
anager'; nested exception is org.springframework.beans.factory.BeanCreationExcep
tion: Error creating bean with name 'liferayTransactionManager' defined in class
path resource [META-INF/hibernate-spring.xml]: Cannot resolve reference to bean
'liferayHibernateSessionFactory' while setting constructor argument; nested exc
eption is org.springframework.beans.factory.BeanCreationException: Error creatin
g bean with name 'liferayHibernateSessionFactory' defined in class path resource
[META-INF/hibernate-spring.xml]: Invocation of init method failed; nested excep
tion is java.lang.NullPointerException
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
... 50 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'bufferedIncrementAdvice' defined in class path resource [META
-INF/base-spring.xml]: Cannot resolve reference to bean 'transactionAdvice' whil
e setting bean property 'nextMethodInterceptor'; nested exception is org.springf
ramework.beans.factory.BeanCreationException: Error creating bean with name 'tra
nsactionAdvice' defined in class path resource [META-INF/base-spring.xml]: Canno
t resolve reference to bean 'liferayTransactionManager' while setting bean prope
rty 'transactionManager'; nested exception is org.springframework.beans.factory.
BeanCreationException: Error creating bean with name 'liferayTransactionManager'
defined in class path resource [META-INF/hibernate-spring.xml]: Cannot resolve
reference to bean 'liferayHibernateSessionFactory' while setting constructor arg
ument; nested exception is org.springframework.beans.factory.BeanCreationExcepti
on: Error creating bean with name 'liferayHibernateSessionFactory' defined in cl
ass path resource [META-INF/hibernate-spring.xml]: Invocation of init method fai
led; nested exception is java.lang.NullPointerException
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
... 60 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'transactionAdvice' defined in class path resource [META-INF/b
ase-spring.xml]: Cannot resolve reference to bean 'liferayTransactionManager' wh
ile setting bean property 'transactionManager'; nested exception is org.springfr
amework.beans.factory.BeanCreationException: Error creating bean with name 'life
rayTransactionManager' defined in class path resource [META-INF/hibernate-spring
.xml]: Cannot resolve reference to bean 'liferayHibernateSessionFactory' while s
etting constructor argument; nested exception is org.springframework.beans.facto
ry.BeanCreationException: Error creating bean with name 'liferayHibernateSession
Factory' defined in class path resource [META-INF/hibernate-spring.xml]: Invocat
ion of init method failed; nested exception is java.lang.NullPointerException
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
... 70 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'liferayTransactionManager' defined in class path resource [ME
TA-INF/hibernate-spring.xml]: Cannot resolve reference to bean 'liferayHibernate
SessionFactory' while setting constructor argument; nested exception is org.spri
ngframework.beans.factory.BeanCreationException: Error creating bean with name '
liferayHibernateSessionFactory' defined in class path resource [META-INF/hiberna
te-spring.xml]: Invocation of init method failed; nested exception is java.lang.
NullPointerException
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.ConstructorResolver.resolve
ConstructorArguments(ConstructorResolver.java:630)
at org.springframework.beans.factory.support.ConstructorResolver.instant
iateUsingFactoryMethod(ConstructorResolver.java:441)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:98
3)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:879)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
... 80 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'liferayHibernateSessionFactory' defined in class path resourc
e [META-INF/hibernate-spring.xml]: Invocation of init method failed; nested exce
ption is java.lang.NullPointerException
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
... 92 more
Caused by: java.lang.NullPointerException
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
159)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.j
ava:2163)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159
)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1383)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSession
Factory(LocalSessionFactoryBean.java:860)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessi
onFactory(LocalSessionFactoryBean.java:779)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPr
opertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
... 99 more
19/09/2012 2:11:39 AM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
19/09/2012 2:11:39 AM org.apache.catalina.core.StandardContext start
SEVERE: Context [] startup failed due to previous errors
02:11:39,713 INFO [HotDeployUtil:69] Initializing hot deploy manager 5190593
02:11:39,714 INFO [HotDeployUtil:69] Initializing hot deploy manager 30335176
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class
reloading, using NOPLoggerRepository.
19/09/2012 2:11:41 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory chat-portlet
19/09/2012 2:11:41 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory default-site-templates-hook
19/09/2012 2:11:42 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory google-maps-portlet
19/09/2012 2:11:42 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory kaleo-web
19/09/2012 2:11:42 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory mail-portlet
19/09/2012 2:11:42 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory opensocial-portlet
19/09/2012 2:11:45 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory sevencogs-hook
19/09/2012 2:11:45 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory sevencogs-mobile-theme
19/09/2012 2:11:45 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory sevencogs-theme
19/09/2012 2:11:45 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory social-networking-portlet
19/09/2012 2:11:45 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory tunnel-web
19/09/2012 2:11:45 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory web-form-portlet
19/09/2012 2:11:45 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory wsrp-portlet
19/09/2012 2:11:46 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8585
19/09/2012 2:11:46 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8559
19/09/2012 2:11:46 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/13 config=null
19/09/2012 2:11:46 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 11942 ms

I can start tomcat, but not browse the http://localhost:8080
László Csontos
RE: Informix connect
September 21, 2012 1:13 PM
Answer

László Csontos

Rank: New Member

Posts: 20

Join Date: June 15, 2012

Recent Posts

Hi Jane,

I'm really sorry, it's not going to work. I have tried to make Liferay 6.1.1 CE work with Informix Innovator-C 11.7, but I experienced SQL errors as well.

My findings are the following:

  • I could not connect it by using the old Informix driver (com.informix.jdbc.IfxDriver)
  • Only the new universal IBM Data Server driver is the one which could connect properly (this also implies that your Informix must speak the DRDA protocol and I do not think that Informix 9.4 has this feature), hibernate dialect should be explicitly specified as well.
  • JDBC properties should look like this way:
     1
     2jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver
     3jdbc.default.url=jdbc:ids://localhost:9089/lportal
     4jdbc.default.username=lportal
     5jdbc.default.password=lportal
     6
     7jdbc.default.acquireIncrement=1
     8jdbc.default.maxPoolSize=50
     9jdbc.default.minPoolSize=10
    10jdbc.default.numHelperThreads=4
    11
    12hibernate.dialect=org.hibernate.dialect.InformixDialect
  • The default DB block size (2K on UNIX) is not enough, I think at least 8K is necessary.
    1
    2$ touch /path/to/lportaldbs
    3$ chmod 660 /path/to/lportaldbs
    4$ onspaces -c -d lportaldbs -p /path/to/portaldbs -k 8 -o 0 -s 102400
    5$ dbaccess - -
    6> create database lportal in lportaldbs with log;
  • InformixDB.java has a bug and some database columns (longer than 255 bytes) get generated as VARCHAR instead of LVARCHAR and this behaviour prevents the portal from creating its schema properly.
     1
     219:35:52,386 WARN  [pool-2-thread-1][BaseDB:428] IDS SQL Error: [url=http://www.oninit.com/errorcode/index.php?pageid=650][b]SQLCODE=-650[/b][/url], SQLSTATE=IX000, SQLERRMC=null, DRIVER=3.57.110:
     3create table QUARTZ_SIMPROP_TRIGGERS (   
     4SCHED_NAME varchar(120) not null,      
     5TRIGGER_NAME varchar(200) not null,   
     6 TRIGGER_GROUP varchar(200) not null,   
     7[b]STR_PROP_1 varchar(512),       
     8STR_PROP_2 varchar(512),       
     9STR_PROP_3 varchar(512),[/b]
    10INT_PROP_1 int,
    11INT_PROP_2 int,
    12LONG_PROP_1 int8,      
    13 LONG_PROP_2 int8,      
    14DEC_PROP_1 NUMERIC(13,4),      
    15 DEC_PROP_2 NUMERIC(13,4),      
    16BOOL_PROP_1 boolean,   
    17BOOL_PROP_2 boolean,   
    18primary key (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP));


Informix support has been introduced by LEP-3685, however I have not found any bug reports about malfunctions on Informix. So I would say, if the community needs Liferay on Informix, please go ahead and file an LPS for it in JIRA.

With best wishes,
Laszlo
Hitoshi Ozawa
RE: Informix connect
September 22, 2012 7:42 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Jane's trying to use informix 9.40 which should be have been supported by the ticket.
jane g
RE: Informix connect
September 23, 2012 10:47 PM
Answer

jane g

Rank: New Member

Posts: 13

Join Date: September 9, 2012

Recent Posts

If the liferay can't work with informix9.4, can i build my website on mysql database and connect to informix database from some of the pages in the website?
László Csontos
RE: Informix connect
September 24, 2012 2:09 AM
Answer

László Csontos

Rank: New Member

Posts: 20

Join Date: June 15, 2012

Recent Posts

jane g:
If the liferay can't work with informix9.4, can i build my website on mysql database and connect to informix database from some of the pages in the website?


Hi Jane,

Yes, in theory it's possible to feed your custom-built portlets from a database other than Liferay's own repository, however I wouldn't recommend to do so, because it's going to add extra complexity and needs advanced configuration. If you have the chance, please try to use a single database for Liferay. (DB2 9.7, MySQL 5.x, Oracle 10gR2/11gR2, PostgreSQL 8.x, 9.x, SQL Server 2005/2008 and Sybase ASE 15 will be working for sure according to the current compatibility matrix).

With best regards,
Laszlo
jane g
RE: Informix connect
September 24, 2012 2:25 PM
Answer

jane g

Rank: New Member

Posts: 13

Join Date: September 9, 2012

Recent Posts

hi Laszlo,
The website i am building with Liferay need to connect to informix to get the data. I can't easily decide to change the informix to mysql since informix also serves a lot of our existing applications. So how difficult to "feed your custom-built portlets from a database other than Liferay's own repository"? Or is it possible that liferay staff can fix the liferay bug and make it work with informix 9.4?
Hitoshi Ozawa
RE: Informix connect
September 24, 2012 3:16 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

To get liferay.com to fix it, you'll need to create a new ticket in jira. They sometimes fix it and sometimes do not so just creating a ticket does not imply that it will get fixed.

While waiting, can you executing sql commands to create liferay database? The sql script to create tables are available under sql directory in liferay source.
László Csontos
RE: Informix connect
September 24, 2012 11:54 PM
Answer

László Csontos

Rank: New Member

Posts: 20

Join Date: June 15, 2012

Recent Posts

Hi Jane,

So how difficult to "feed your custom-built portlets from a database other than Liferay's own repository"?

Liferay has a tool Service Builder which is capable of generating the data access and service layer of your custom applications. (Liferay Portal uses it internally for its built-in portlets as well). It can also create database objects (tables) for the application and that part seems to be broken in Liferay as I have previously mentioned.
So difficulty stems from the fact that (most likely) you will have to design your data access and service layer by yourself, if you want your custom applications to be connected to Informix. If you already have other Java-based applications within your organization connecting to Informix databases, this step should not be so difficult.

Or is it possible that liferay staff can fix the liferay bug and make it work with informix 9.4?

Hitoshi is right, you will have to file the problem you have experienced in our issue tracker. As he pointed out, community issues do not get fixed right away, Liferay's program management will prioritize and schedule that depending on how the community is affected by that particular issue.
Even if Informix support were already fixed, you would have to change Liferay's code base and merge the fix by yourself, because patches are provided only for EE (Enterprise Edition). There are however initiatives to gather members of the community and provide patches for CE.

While waiting, can you executing sql commands to create liferay database? The sql script to create tables are available under sql directory in liferay source.

Yes, that's a possibility that you can give a go. Download Liferay portal's SQL scripts from here and ask your DBAs to try to create a schema for you.

With best wishes,
Laszlo
Hitoshi Ozawa
RE: Informix connect
September 25, 2012 5:50 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Another method that may be easier is to just use mysql for liferay's database and still use informix for your existing application. Just create a web service to access your existing applications and just call these services from liferay (from methods in impl classes generated by service builder). This is the preferred way to integrate liferay with existing applications.
David H Nebinger
RE: Informix connect
September 25, 2012 6:50 PM
Answer

David H Nebinger

Community Moderator

Rank: Liferay Legend

Posts: 13013

Join Date: September 1, 2006

Recent Posts

László Csontos:
in theory it's possible to feed your custom-built portlets from a database other than Liferay's own repository, however I wouldn't recommend to do so, because it's going to add extra complexity and needs advanced configuration.


Wow, I can't believe a Liferay employee is saying this...

Well, let's consider what the 'extra complexity and advanced configuration' actually is...

First, you need to add some spring beans to the ext-spring.xml in the plugin that is going to implement the service. You'll define a datasource bean, a hibernate session factory, and a portlet session factory. The details for these beans to add can be found using a simple google search for "service builder different database".

Second, in your service.xml file you're going to point your entities at these alternate beans. For this you're just specifying the data-source and session-factory attributes on the entities to use the beans you defined in ext-spring.xml.

Maybe I'm missing where Laszlo was going, but this is basically it.
jane g
RE: Informix connect
September 26, 2012 8:05 PM
Answer

jane g

Rank: New Member

Posts: 13

Join Date: September 9, 2012

Recent Posts

Thanks for all your advise. I will try "executing sql commands to create liferay database", but i have to modify the sql script to make it work with informix9.4.
As a java developer without any web service, spring and hibernate experience, how difficult it's to use "service builder different database"?
László Csontos
RE: Informix connect
September 28, 2012 10:59 AM
Answer

László Csontos

Rank: New Member

Posts: 20

Join Date: June 15, 2012

Recent Posts

Hi,

Here is a pretty decent write-off, how to set it up: Using a Legacy DB with Service Builder

Please let me know, if you have further questions.

Regards,
Laszlo
Hitoshi Ozawa
RE: Informix connect
September 29, 2012 3:40 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

That's a common question and you'll be able to find some pages explaining how to do it on the net.

Check the following wiki. It's written for liferay 5.2 but the basic principle is the same.

http://www.liferay.com/community/wiki/-/wiki/Main/Connecting+to+an+External+Database+and+Building+Services+Against+It

External site pages:
http://liferayatglance.blogspot.jp/2011/11/connecting-to-different-database-using.html#!/2011/11/connecting-to-different-database-using.html

http://stackoverflow.com/questions/9570318/using-liferays-service-builder-to-access-existing-tables-in-the-database
jane g
RE: Informix connect
October 10, 2012 1:22 AM
Answer

jane g

Rank: New Member

Posts: 13

Join Date: September 9, 2012

Recent Posts

I follow the steps on
http://liferayatglance.blogspot.jp/2011/11/connecting-to-different-database-using.html#!/2011/11/connecting-to-different-database-using.html
and change my service.xml, ext-spring.xml and portal-ext.properties to connect to existing informix database. I also copy jdbc .jars to /docroot/WEB-INF/lib, but i still get
errors:

Loading file:/C:/programs/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/temp/0-hubsu
ite-portlet/WEB-INF/classes/service.properties
07:34:01,554 ERROR [pool-2-thread-1][ContextLoader:227] Context initialization f
ailed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'liferayHibernateSessionFactory' defined in ServletContext resource [/WEB
-INF/classes/META-INF/ext-spring.xml]: Cannot resolve reference to bean 'myDatas
ource' while setting bean property 'dataSource'; nested exception is org.springf
ramework.beans.factory.BeanCreationException: Error creating bean with name 'myD
atasource' defined in ServletContext resource [/WEB-INF/classes/META-INF/ext-spr
ing.xml]: Cannot create inner bean 'com.liferay.portal.dao.jdbc.util.DataSourceF
actoryBean#58adf9' of type [com.liferay.portal.dao.jdbc.util.DataSourceFactoryBe
an] while setting bean property 'targetDataSource'; nested exception is org.spri
ngframework.beans.factory.BeanCreationException: Error creating bean with name '
com.liferay.portal.dao.jdbc.util.DataSourceFactoryBean#58adf9' defined in Servle
tContext resource [/WEB-INF/classes/META-INF/ext-spring.xml]: Invocation of init
method failed; nested exception is java.lang.ClassNotFoundException: com.inform
ix.jdbc.IfxDriver
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1327)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1085)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:516)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:455)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:192)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:567)
at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:282)
at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:204)

In service.xml, i add:
<namespace></namespace>
<entity name="user" local-service="true" remote-service="false" table="user" data-source="myDatasource">

In ext-spring.xml,
<?xml version="1.0" encoding="UTF-8" ?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" default-destroy-method="destroy" default-init-method="afterPropertiesSet" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
<bean id="myDatasource" class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy">
<property name="targetDataSource">
<bean class="com.liferay.portal.dao.jdbc.util.DataSourceFactoryBean">
<property name="propertyPrefix" value="jdbc.custom.default." />
</bean>
</property>
</bean>
<bean id="liferayHibernateSessionFactory" class="com.liferay.portal.spring.hibernate.PortletHibernateConfiguration">
<property name="dataSource" ref="myDatasource" />
</bean>
</beans>

In portal-ext.properties,
jdbc.custom.default.driverClassName=com.informix.jdbc.IfxDriver
jdbc.custom.default.url=jdbc:informix-sqli://informix02:9500/myportal:INFORMIXSERVER=portal02;DB_LOCALE=en_us.utf8
jdbc.custom.default.username=xxxxxxx
jdbc.custom.default.password=xxxxxxx

Please help!
Mika Koivisto
RE: Informix connect
March 11, 2013 5:48 PM
Answer

Mika Koivisto

Rank: Liferay Legend

Posts: 1518

Join Date: August 7, 2006

Recent Posts

02:11:39,428 ERROR [PortalHibernateConfiguration:95] java.lang.RuntimeException:
No dialect found
java.lang.RuntimeException: No dialect found
at com.liferay.portal.spring.hibernate.DialectDetector.getDialect(Dialec
tDetector.java:124)


Based on that Hibernate can't detect your database dialect. Just define the dialect manually in portal-ext.properties like this:

1hibernate.dialect=org.hibernate.dialect.InformixDialect