Uploaded image for project: 'dcm4chee'
  1. DCMEE-1588

Exception during assembling of SQL statement on performing a C-FIND RQ causes leaking DB connections

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: dcm4chee-2.8.2, dcm4chee-2.9.5, dcm4chee-2.10.2, dcm4chee-2.10.3, dcm4chee-2.10.4, dcm4chee-2.10.6, dcm4chee-2.10.7, dcm4chee-2.10.8, dcm4chee-2.10.9, dcm4chee-2.10.10, dcm4chee-2.10.11, dcm4chee-2.10.12, dcm4chee-2.10.13, dcm4chee-2.10.14, dcm4chee-2.10.15, dcm4chee-2.11.0, dcm4chee-2.12.0, dcm4chee-2.13.0, dcm4chee-2.13.1, dcm4chee-2.13.2, dcm4chee-2.13.3, dcm4chee-2.13.4, dcm4chee-2.13.5, dcm4chee-2.13.6, dcm4chee-2.14.0, dcm4chee-2.14.1, dcm4chee-2.14.2, dcm4chee-2.14.3, dcm4chee-2.14.4, dcm4chee-2.14.5, dcm4chee-2.14.6, dcm4chee-2.14.7, dcm4chee-2.14.8, dcm4chee-2.15.0
    • Component/s: DB, DICOM, JBoss
    • Labels:
      None
    • Test Status:
      2-15-1PR01-n-t-n-y tested successfully with build 2011-01-28
    • Sprint:

      Description

      Excpetion during assembling of SQL statement like:

      [org.dcm4chex.archive.dcm.qrscp.QueryRetrieveScpService] Query DB
      failed:
      java.lang.NullPointerException
             at java.util.Calendar.setTime(Calendar.java:1075)
             at java.text.SimpleDateFormat.format(SimpleDateFormat.java:876)
             at java.text.SimpleDateFormat.format(SimpleDateFormat.java:869)
             at java.text.DateFormat.format(DateFormat.java:316)
             at org.dcm4chex.archive.ejb.jdbc.Match$Range.appendBodyTo(Match.java:338)
             at org.dcm4chex.archive.ejb.jdbc.Match.appendTo(Match.java:92)
             at org.dcm4chex.archive.ejb.jdbc.SqlBuilder.appendMatchesTo(SqlBuilder.java:625)
             at org.dcm4chex.archive.ejb.jdbc.SqlBuilder.getSql(SqlBuilder.java:404)
             at org.dcm4chex.archive.ejb.jdbc.QueryCmd.execute(QueryCmd.java:269)
             at org.dcm4chex.archive.dcm.qrscp.FindScp.newMultiCFindRsp(FindScp.java:307)
             at org.dcm4chex.archive.dcm.qrscp.FindScp.doCFind(FindScp.java:160)
             at org.dcm4che.net.DcmServiceBase.c_find(DcmServiceBase.java:154)
             at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:235)
             at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174)
             at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:157)
             at org.dcm4cheri.server.DcmHandlerImpl.handle(DcmHandlerImpl.java:249)
             at org.dcm4cheri.server.ServerImpl.run(ServerImpl.java:279)
             at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174)
             at org.dcm4cheri.util.LF_ThreadPool$1.run(LF_ThreadPool.java:221)
             at java.lang.Thread.run(Thread.java:619)
      

      on performing a C-FIND RQ causes leaking DB connections.

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                gunter Gunter Zeilinger
                Reporter:
                gunter Gunter Zeilinger
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: