Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: No display folder list after logon

  1. #1
    Join Date
    Jul 2009
    Posts
    10

    Unhappy Pentaho3.0 in Jboss 5.1 with Postgres Repository - No display folder list after logon

    After logon this pentaho no display folder list and say this error on log:

    2009-09-23 15:11:47,281 ERROR [org.hibernate.transaction.JDBCTransaction] (http-0.0.0.0-80-1) Could not toggle autocommit
    java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@1690c0
    at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:81)
    at org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:454)
    ...
    2009-09-23 15:11:47,281 ERROR [org.hibernate.transaction.JDBCTransaction] (http-0.0.0.0-80-1) JDBC commit failed
    java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@1690c0
    at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:81)
    ...
    2009-09-23 15:11:47,281 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] (http-0.0.0.0-80-2) Returning cached instance of singleton bean 'IAclVoter'
    2009-09-23 15:11:47,281 DEBUG [org.hibernate.jdbc.ConnectionManager] (http-0.0.0.0-80-1) aggressively releasing JDBC connection
    2009-09-23 15:11:47,281 DEBUG [org.hibernate.jdbc.ConnectionManager] (http-0.0.0.0-80-1) releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
    2009-09-23 15:11:47,281 ERROR [org.pentaho.platform.repository.hibernate.HibernateUtil] (http-0.0.0.0-80-1) HIBUTIL.ERROR_0008 - [pt_53] commitTransaction() failed.
    org.hibernate.TransactionException: JDBC commit failed
    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:161)
    at org.pentaho.platform.repository.hibernate.HibernateUtil.commitTransaction(HibernateUtil.java:431)
    ...
    at java.lang.Thread.run(Thread.java:619)
    Caused by: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@1690c0
    at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:81)
    at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:482)
    at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:170)
    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:146)
    ... 68 more
    2009-09-23 15:11:47,281 DEBUG [org.pentaho.platform.util.logging.Logger] (http-0.0.0.0-80-2) misc-org.pentaho.platform.web.http.context.WebSpringPentahoObjectFactory: got an instance of [IAclVoter]: org.pentaho.platform.engine.security.acls.voter.PentahoBasicAclVoter@1f592d8
    2009-09-23 15:11:47,296 DEBUG [org.pentaho.platform.repository.hibernate.HibernateUtil] (http-0.0.0.0-80-1) [pt_56] Tyring to rollback database transaction of this thread.
    2009-09-23 15:11:47,296 DEBUG [org.hibernate.transaction.JDBCTransaction] (http-0.0.0.0-80-1) rollback
    Any idea for this problem?

    log file is atached

    system: pentaho 3.0, jboss 5.0.1 and postgres 8.3

    The databases: sampledata, hibernate, quartz and shark is postgresql

    This configuration works fine with Tomcat only with jboss is bad.


    best regards

    Alex
    Attached Files Attached Files
    Last edited by numsey; 09-25-2009 at 10:51 AM.

  2. #2
    gmoran Guest

    Default

    Your server log shows that you have a collision between the commons-collections jar that is deployed with the pentaho webapp, and another commons-collections jar in another webapp deployed to the same server.

    My recommendation is to find the other commons-collections.jar and replace it with the one from Pentaho's webapp. Not sure how this will impact your other app, but it will make JBoss happier.

    cheers,
    G

  3. #3
    Join Date
    Jul 2009
    Posts
    10

    Smile Problem solved!

    Quote Originally Posted by gmoran View Post
    Your server log shows that you have a collision between the commons-collections jar that is deployed with the pentaho webapp, and another commons-collections jar in another webapp deployed to the same server.

    My recommendation is to find the other commons-collections.jar and replace it with the one from Pentaho's webapp. Not sure how this will impact your other app, but it will make JBoss happier.

    cheers,
    G
    Problem solved!

    Thank gmoran, I followed your advice and it worked! My installation of pentaho30 in jboss5.1.0 with postgresql is running smoothly.

    For those who want to make the installation of pentaho30 or 35 in jboss5.1.0 also read the post: http://forums.pentaho.org/showthread.php?t=72351

    best regards

    Alexsandro

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.