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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org