Uploaded image for project: 'Alfresco'
  1. Alfresco
  2. ALF-11206

Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@4cbb2bec

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Not a bug
    • Affects Version/s: 4.0.b Community
    • Fix Version/s: 4.0 Enterprise
    • Component/s: Installer
    • Security Level: external (External user)
    • Labels:
      None
    • Environment:

      Description

      1. Made changed to jboss installation/configuration as per the instruction mentioned in the alfreco 3.4 enterprise installation guide.
      2. Initially we had alfresco 3.4 enterpriese version installed. Removed alfresco.war file and deployed alfresco.war (alfresco-4.0.b community) on jboss eap 5.1. Before deploying the file dropped the database and recreated again on mysql.
      3. Copied the keystore supplied by alfresco to proper locaiton and updated alfresco-global.properties file.
      4. We are using lucene as of now and hence update alfresco-global.properties file to relfect lucene instead of sole.
      5. Noticed below exceptions in the logs while starting alfresco deployed on jboss.

      2011-10-31 10:12:08,153 INFO [STDOUT] (main) 2011-10-31 10:12:08,150 WARN [jdbc.support.SQLErrorCodesFactory] [main] Error while extracting database product name - falling back to empty error codes
      org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@4cbb2bec
      at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:296)
      at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:320)
      at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:213)
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:141)
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<init>(SQLErrorCodeSQLExceptionTranslator.java:104)
      at org.mybatis.spring.MyBatisExceptionTranslator.initExceptionTranslator(MyBatisExceptionTranslator.java:84)
      at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:70)
      at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
      at $Proxy251.insert(Unknown Source)
      at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:231)
      at org.alfresco.repo.domain.propval.ibatis.PropertyValueDAOImpl.createClass(PropertyValueDAOImpl.java:140)
      at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyClassCallbackDAO.createValue(AbstractPropertyValueDAOImpl.java:320)
      at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyClassCallbackDAO.createValue(AbstractPropertyValueDAOImpl.java:299)
      at org.alfresco.repo.cache.lookup.EntityLookupCache.getOrCreateByValue(EntityLookupCache.java:432)
      at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getOrCreatePropertyClass(AbstractPropertyValueDAOImpl.java:292)
      at org.alfresco.repo.domain.propval.ibatis.PropertyValueDAOImpl.createPropertyValue(PropertyValueDAOImpl.java:404)
      at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyValueCallbackDAO.createValue(AbstractPropertyValueDAOImpl.java:762)
      at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyValueCallbackDAO.createValue(AbstractPropertyValueDAOImpl.java:712)
      at org.alfresco.repo.cache.lookup.EntityLookupCache.getOrCreateByValue(EntityLookupCache.java:469)
      at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getOrCreatePropertyValue(AbstractPropertyValueDAOImpl.java:705)
      at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.createPropertyUniqueContext(AbstractPropertyValueDAOImpl.java:1097)

      Caused by: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@4cbb2bec
      at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:82)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.getMetaData(WrappedConnection.java:525)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
      at $Proxy250.getMetaData(Unknown Source)
      at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:285)
      ... 109 more

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                closedissues Closed Issues
                Reporter:
                ecmadmin aditya (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Date of First Response: