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