tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chris derham <ch...@derham.me.uk>
Subject Re: Populating Oracle v$session.program from Tomcat Context.xml
Date Wed, 16 Mar 2011 19:40:39 GMT
> 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?

Chris

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message