tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan <random.da...@gmail.com>
Subject Populating Oracle v$session.program from Tomcat Context.xml
Date Mon, 14 Mar 2011 15:15:49 GMT
Hello all...

We have some working tomcat 6 instances that we'd like to identify by
querying the v$session.program field the oracle database they connect
to. While there are no errors on startup for the tomcat instance, and
we can connect to the database, nothing gets populated in v$session.
This functionality seems to work for the oracle thin driver, but when
I try using OCI nothing happens. The original field values persist.
I've also tried the module and client_info fields, also with no luck.

Here’s a sample from my resource block minus the extra stuff.

<Resource name="jdbc/resource"
                auth="Container"
                type="javax.sql.DataSource"
                driverClassName="oracle.jdbc.OracleDriver"
                connectionProperties="v$session.program=MyApp;"
                url="jdbc:oracle:oci:@MyService"/>

I’ve posted this question to the oracle support forums with no luck,
but I’m assuming more people here are running oracle than people there
running tomcat. Any help would be greatly appreciated.

Thanks,

Dan

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message