JDBC Connect Client

[cleanair4me]

I use Oracle 9i for my database back end working with ColdFusion web applications.

I generally monitor the web application's database connections in SQL Plus using v$session such as:

select username,program from v$session where username = 'MY_SCHEMA_NAME'

ColdFusion is suppose to automatically close the connection in its CFQuery tag.
But I am not sure if ColdFusion closes the connection right away after someone uses (read or write) a ColdFusion web site.
For example I usually check the above v$session sql for about 20 to 30 minutes consistently after the user exits the web application and it shows this output:

username               program
MY_SCHEMA_NAME         JDBC Connect Client

Does the JDBC Connect Client program mean the connection is still open?

 

[sem]

Actually JDBC connections may be cached by DataSource object not closing connections immediately to minimize the amount of (quite heavy) log on operations required. Moreover, it's possible to share single database connection between multiple concurrent client applications. Thus you should not expect that each your database call opens or closes physical database connection, only its logical wrapper.

Regards, Dima

http://seminihin.narod.ru