Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-13907

JDBC Statement not closed

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 12.1.11.Final, 13.0.10.Final
    • Loaders and Stores
    • None

    Description

      When I use the infinispan-cachestore-jdbc with a configured MariaDB database and set the configuration TableManipulationConfigurationBuilder.createOnStart(false) to false I get warnings in my log file that ResultSets are not closed. You have to set JBoss datasource configuration to:
      <subsystem xmlns="urn:jboss:domain:datasources:6.0">
      ...
       <statement>
               <track-statements>true</track-statements>
        </statement>
      ...
      </datasource>
      <track-statements> will inform you that Statement is not closed.
       
      I identified the method which will bring up a warning:
      Class org.infinispan.persistence.jdbc.impl.table.AbstractTableManager
      Method:
      public TableManager.Metadata getMetadata(Connection connection)

      doesn't close the statement:

      https://github.com/infinispan/infinispan/blob/12.1.x/persistence/jdbc/src/main/java/org/infinispan/persistence/jdbc/impl/table/AbstractTableManager.java#L184

       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            thaefner Tobias Häfner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: