> 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
