Uploaded image for project: 'ActiveMQ'
  1. ActiveMQ
  2. AMQ-2215

Using beehive jdbc control creates db connection issue.

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: 5.x
    • Component/s: Performance Test
    • Labels:
      None
    • Environment:

      SANDBOX

      Description

      hi,
      I am new to this area but, I use JIRA for issue tracking and task management.

      I am facing some issues while using org.apache.beehive.controls.system.jdbc.JdbcControl sql statement.
      The details are as
      1. Using only SELECT statement; can be considered as non complex.

      "SELECT a.NODE_ID,a.FULL_PATH,a.

      {sql: orderField}

      FROM CM_NODE a,CM_PROPERTY b,CM_PROPERTY c " +
      "WHERE a.NODE_ID=b.NODE_ID AND a.NODE_ID=c.NODE_ID AND a.LIFECYCLE_STATUS!=

      {life_cycle_status}

      AND a.EFFECTIVE_DATE<=SYSDATE AND a.FULL_PATH LIKE

      {fullPathStart}

      "+
      "AND (c.property_name=

      {expiration_vcrDate_field_name}

      AND c.DATETIME_VALUE>=SYSDATE ) "+
      "AND (b.property_name=

      {content_type_field_name}

      AND b.text_value =

      {contentTypeCondition}

      ) "+
      "ORDER BY

      {sql: orderField}

      {sql: sort}

      , a.NODE_ID

      {sql: sort}

      "

      2. Define the db datasource as Connection notation as
      @ControlExtension
      @JdbcControl.ConnectionDataSource(jndiName = "contentDataSource")
      @JdbcControl.ConnectionOptions(
      resultSetHoldability=org.apache.beehive.controls.system.jdbc.JdbcControl.HoldabilityType.DRIVER_DEFAULT)
      3. not opening nay connection nor closing any connection.
      4. Connection on the server i noticed is very larger numbers.

      Could you please suggest something to get rid of this issue.
      Should I close the db connection; if so how should i close the connection.

      Thanks
      Bhabani.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              biswabh1 Bhabani sankar Biswas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: