Using beehive jdbc control creates db connection issue.

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.