Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-2391

Dashbuilder not closing ResultSets and Statements

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 7.5.1.GA
    • 7.4.1.GA
    • BAM
    • CR1
    • +
    • Hide

      1. Install RHPAM 7.4 with kie-server and business-central

      2. Add the following to the datasource used by kie-server:

          <statement>
        <track-statements>true</track-statements>
    </statement>

      3. Start the server - the "IJ030042: Closing a result set you left open" show up during the registration of the queries

      4. (Optional) - Navigate to 'Process instances'

      Show
      1. Install RHPAM 7.4 with kie-server and business-central 2. Add the following to the datasource used by kie-server: <statement> <track-statements>true</track-statements> </statement> 3. Start the server - the "IJ030042: Closing a result set you left open" show up during the registration of the queries 4. (Optional) - Navigate to 'Process instances'
    • 2019 Week 41-43 (from Okt 7)

      Dashbuilder code fails to close ResultSet or Statement instances. This has been raised in the past for BPMS 6.4.x as RHBPMS-5121, and fixed by:
      https://github.com/dashbuilder/dashbuilder/commit/c9df8b4ea202ff1d3d2c76d58f171dedbe7324d7

      This fix, however, is missing in kie-soup and thus in RHPAM 7.x.

      This is the WARN message upon navigating to the Process Instances view:

      14:55:33,788 WARN  [org.jboss.jca.adapters.jdbc.WrappedConnection] (default task-4) IJ030042: Closing a result set you left open, please do your own housekeeping for: rs320: org.h2.result.LocalResult@12464c39 columns: 1 rows: 0 pos: 0: java.lang.Throwable: STACKTRACE
	at org.jboss.jca.adapters.jdbc.WrappedStatement.registerResultSet(WrappedStatement.java:1528)
	at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:398)
	at org.dashbuilder.dataprovider.sql.JDBCUtils.executeQuery(JDBCUtils.java:108)
	at org.dashbuilder.dataprovider.sql.model.Select.fetch(Select.java:183)
	at org.dashbuilder.dataprovider.sql.SQLDataSetProvider$LookupProcessor.run(SQLDataSetProvider.java:742)
	at org.dashbuilder.dataprovider.sql.SQLDataSetProvider._lookupDataSet(SQLDataSetProvider.java:441)
	at org.dashbuilder.dataprovider.sql.SQLDataSetProvider.lookupDataSet(SQLDataSetProvider.java:236)
	at org.dashbuilder.dataset.DataSetManagerImpl.lookupDataSet(DataSetManagerImpl.java:154)
	at org.jbpm.kie.services.impl.query.QueryServiceImpl.query(QueryServiceImpl.java:307)
	at org.jbpm.kie.services.impl.query.QueryServiceImpl.query(QueryServiceImpl.java:249)
	at org.kie.server.services.jbpm.QueryDataServiceBase.queryFiltered(QueryDataServiceBase.java:187)
	at org.kie.server.services.jbpm.QueryDataServiceBase.queryFiltered(QueryDataServiceBase.java:146)
	at org.kie.server.remote.rest.jbpm.QueryDataResource.runQueryFiltered(QueryDataResource.java:371)

              rhn-support-wsiqueir William Siqueira
              rhn-support-mputz Martin Weiler (Inactive)
              Dominik Hanak Dominik Hanak
              Dominik Hanak Dominik Hanak
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: