> -----Original Message----- > From: chris derham > Sent: Wednesday, March 16, 2011 15:41 > To: Tomcat Users List > Subject: Re: Populating Oracle v$session.program from Tomcat > Context.xml > > > We'd like to be able to tell apart database sessions from > the 15 or so > > tomcat applications we have running on our web-servers. > Most of them > > use similar logins, so we can't query the username from > gv$session. We > > were hoping to instead query to program field to tell them apart. > > > > We were able to make this functionality work with the thin > client, but > > we'd rather use the OCI client because it allows our web-apps to > > reconnect to the database service after a loss of connectivity (say > > during a cluster node reboot). > > > > You seem to be restating the original question. Did you try > using dbcp > connection pool, and executing a Oracle command as the > connection is created to specify some context parameter? > Without any feedback, its kind of hard to help further. I > assume that it didn't work as you have seem to have asked the > original question again. So what problems did you encounter?
The problem he appears to be encountering is that he is unable to customize the value in v$session.program. The reason for the problem is that he does not know how to do it either when using the OCI jdbc driver (it is likely not possible). -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Principal Consultant 10 West 24th Street #100 - - +1 (443) 269-1555 x333 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is copyright PD Inc, subject to license 20080407P00. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
