Mailing-List: contact dev-help@activemq.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@activemq.apache.org
Message-ID: <6189677.20261284828257215.JavaMail.jira@thor>
Date: Sat, 18 Sep 2010 12:44:17 -0400 (EDT)
From: "Bruce Snyder (JIRA)" <jira@apache.org>
To: dev@activemq.apache.org
Subject: [jira] Updated: (AMQ-2215) Using beehive jdbc control creates db
 connection issue.
In-Reply-To: <73111248.1240326332407.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/activemq/browse/AMQ-2215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bruce Snyder updated AMQ-2215:
------------------------------

    Fix Version/s: 5.5.0
                       (was: 5.4.1)

> Using beehive jdbc control creates db connection issue.
> -------------------------------------------------------
>
>                 Key: AMQ-2215
>                 URL: https://issues.apache.org/activemq/browse/AMQ-2215
>             Project: ActiveMQ
>          Issue Type: Improvement
>          Components: Performance Test
>         Environment: SANDBOX
>            Reporter: Bhabani Sankar Biswas
>             Fix For: 5.5.0
>
>
> 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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.