activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bhabani Sankar Biswas (JIRA)" <j...@apache.org>
Subject [jira] Created: (AMQ-2215) Using beehive jdbc control creates db connection issue.
Date Tue, 21 Apr 2009 15:05:32 GMT
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


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.


Mime
View raw message