> -----Original Message----- > From: Dan > Sent: Wednesday, March 16, 2011 14:34 > 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).
I want to put a fram of reference on this. Remember the OCI client uses OS resources to connect, as such it is going to pull the process name from the OS and java applications are not OS level precesses, you do not see them in the output of /bin/ps or taskmgr.exe. > > So far though we've had no luck in getting it to work with > OCI. Most of the suggestions and info out on the web imply > that the best way to do it with OCI is programmatically from > the java app. That's the dilemma. Do we have to take the time > to change our apps to populate the program field, or can we > do it from the context.xml file from our app? > > On Tue, Mar 15, 2011 at 8:23 PM, Jorge Medina > <cerebrotecnolog...@gmail.com> wrote: > > What is the problem that you are trying to solve? > > > > On Mon, Mar 14, 2011 at 4:25 PM, Dan <random.da...@gmail.com> wrote: > >> On Mon, Mar 14, 2011 at 11:25 AM, Dan > <random.da...@gmail.com> wrote: > >>> On Mon, Mar 14, 2011 at 10:57 AM, chris derham > <ch...@derham.me.uk> wrote: > >>>>> We have some working tomcat 6 instances that we'd like > to identify > >>>> > >>>> > >>>> Can you use the combination of machine and schema name > to identify > >>>> the instance? You didn't detail your environment, but if > you have a > >>>> cluster, then the machine name would uniquely identify the > >>>> instance. If you have multiple different instances on the same > >>>> machine, then surely the schema name would allow you to identify > >>>> which user it is? This covers all possibilities unless you have > >>>> different apps on the same machine in different tomcat > instances talking to the same schema. > >>>> > >>>> Chris > >>>> > >>> > >>> We are running all of our web-applications from two machines, and > >>> they all use the same schema/username, so unfortunately I > need the > >>> program, client_info, module, etc field to identify them. > >>> > >>> We are running a RAC, and I'm querying gv$session which > should get > >>> me all cluster member connections. > >>> > >>> As David said, this does work with the thin driver, but I > need the > >>> service/load balancing functionality from OCI. Any more > suggestions > >>> are welcome! > >>> > >> > >> Does anyone else have any additional thoughts on this? I'd sure > >> appreciate more input. > >> > >> TIA, > >> > >> Dan -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - 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
