[jboss-jira] [JBoss JIRA] Commented: (JBPORTAL-2203) CMS exception with PostgreSQL on startup (again)

[Prabhat Jha (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBPORTAL-2203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12434424#action_12434424 ] 

Prabhat Jha commented on JBPORTAL-2203:
---------------------------------------

BTW, after enabling db tests with CMS, I saw some failures with postgresql. I think it should be in ML as well but here is the link: http://hudson.qa.jboss.com/hudson/view/JBoss%20Portal/job/jboss-portal-cms-trunk-db/lastBuild/testReport/

> CMS exception with PostgreSQL on startup (again)
> ------------------------------------------------
>
>                 Key: JBPORTAL-2203
>                 URL: https://jira.jboss.org/jira/browse/JBPORTAL-2203
>             Project: JBoss Portal
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Portal CMS
>    Affects Versions: 2.7.0 CR1 
>         Environment: Linux FC8 + JBoss 4.2.3 + postgresql-8.3-603.jdbc3.jar + PostgreSQL 8.2.10
>            Reporter: Przemyslaw Sztoch
>            Assignee: Sohil Shah
>             Fix For: 2.6.7 Final, 2.7.0 Final
>
>
> There is a JBoss log:
> --------------------......................------------------ >8
> 2008-10-17 04:32:13,097 INFO  [org.jboss.portal.cms.impl.jcr.JCRCMS] JBossCache Version=1.4.1
> 2008-10-17 04:32:13,097 INFO  [org.jboss.portal.cms.impl.jcr.JCRCMS] Starting JCR CMS
> 2008-10-17 04:32:13,333 INFO  [org.apache.jackrabbit.core.RepositoryImpl] Starting repository...
> 2008-10-17 04:32:13,542 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 25P01
> 2008-10-17 04:32:13,542 ERROR [org.hibernate.util.JDBCExceptionReporter] Large Objects may not be used in auto-commit mode.
> 2008-10-17 04:32:13,543 ERROR [org.jboss.portal.cms.hibernate.HibernateStore] failed to check existence of folder: /meta/rep.prop
> org.hibernate.exception.GenericJDBCException: could not execute query
>         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>         at org.hibernate.loader.Loader.doList(Loader.java:2223)
>         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>         at org.hibernate.loader.Loader.list(Loader.java:2099)
>         at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>         at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>         at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>         at org.jboss.portal.cms.hibernate.HibernateStore.isFolder(HibernateStore.java:512)
>         at org.jboss.portal.cms.hibernate.HibernateStore.getOutputStream(HibernateStore.java:960)
>         at org.apache.jackrabbit.core.fs.BasedFileSystem.getOutputStream(BasedFileSystem.java:135)
>         at org.apache.jackrabbit.core.fs.FileSystemResource.getOutputStream(FileSystemResource.java:179)
>         at org.apache.jackrabbit.core.RepositoryImpl.storeRepProps(RepositoryImpl.java:1137)
>         at org.apache.jackrabbit.core.RepositoryImpl.loadRepProps(RepositoryImpl.java:1117)
>         at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:261)
>         at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:557)
>         at org.jboss.portal.cms.impl.jcr.jackrabbit.JackrabbitJCRService.start(JackrabbitJCRService.java:107)
>         at org.jboss.portal.cms.impl.jcr.JCRCMS.startJCR(JCRCMS.java:326)
>         at org.jboss.portal.cms.impl.jcr.JCRCMS.startService(JCRCMS.java:291)
>         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:597)
>         at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.execute(JBossServiceModelMBean.java:486)
>         at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.startService(JBossServiceModelMBean.java:452)
> --------------------......................------------------ >8

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira