[
https://issues.apache.org/jira/browse/AMQ-2215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Claus Ibsen resolved AMQ-2215.
------------------------------
Resolution: Invalid
> Using beehive jdbc control creates db connection issue.
> -------------------------------------------------------
>
> Key: AMQ-2215
> URL: https://issues.apache.org/jira/browse/AMQ-2215
> Project: ActiveMQ
> Issue Type: Improvement
> Components: Performance Test
> Environment: SANDBOX
> Reporter: Bhabani sankar Biswas
> Fix For: 5.x
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
