-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Vijay,
On 6/1/15 8:47 AM, Vijay Kumar wrote: > Hi, > > Client want to monitor whether the connection is established from > my application or their existing applications. Because all these > are connecting the database from APPS user. > > 1) My Tomcat is installed on a different Linux environment under a > user, so if i could at least pass this user then Client can able to > identify that the connection is established from my Application. What about the most obvious solution to this: simply change the username you use to connect to Oracle from *this particular* application? You don't have to detect the OS user and forward it over to Oracle; just change the <Resource> element to mention whatever username you want to use. ??! > 2) By querying the v$session table in Oracle we can get all the > connection information but we can't identify the connections that > are created from my application because all the applications are > connecting database through APPS user. > > We can achieve this by creating a new schema and providing all the > required permissions to my schema and accessing the database from > the created schema but is there any option where we can achieve my > requirement. I found that by providing a attribute called > 'connectionProperties' in Resource Tag of the context.xml is > achieved this. But am not seeing any information about the Program > name after connecting to database. Eg : > connectionProperties="v$session.program=dev-cs" - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 Comment: GPGTools - http://gpgtools.org iQIcBAEBCAAGBQJVbF2sAAoJEBzwKT+lPKRYAzEP/2v//Ky1N4+vzadsqNej9dt/ KvQv+ZnIN2VYmQKJRmGlG/iW/F3sXnn58qwt4VhRBr5OMOBzfM6bPA7+VxksgSG2 PqLeLvqknET1M87LUb2c6cpaGEZUjereM0S+s68e7mwoneYqrBfIJOJMVbJOmsk+ zd73TZ2+fVw6uKLMQSJ2w+9736YKjtFlzE8kV1sQeqfulioJ+rG7v/msZTGJ9Dp4 t1HW6fOvpZHQVU0pHSzmAG3pIIXCunEmfoBL3PTZYkj9uicli3tFdw/iI3JkqA1L A1hxJ05bEDYimjbI0pA/kbz1Pdtj0aWrEP3Y1/SnTMgP6TOaYSY9Lms+lA5Hza9z V7HtEzjEkWe0PM3qSI31Ib09e2qn4deeJdEtMCSVoZn7MePmmVZ1KmAhvsgAWQ3D HuLuZ2rixyPx0MduNjOUJzjCQQ/8D5igwrscuMAUP7FQcDKWumpVoRBAO6OMKeNF 6OZrzqB+RcLl/xNJh0cWXBmFhA0fnLfdkNpKgOcFcjZiJe7IoFZ/llf2lqzlWEyn tepws4lnbX3qiMlE/oVLHfRZc9KdBnmcO12BmWiPrfFsEIcEjfbL8xGvsOd2tSv3 Cdza7Zg4LTW2/Sh0KKCu7cA6TS/VC/yPr3rHkvGdtmza0PoNXYMHVaSA3R+20TAc tUSotGCdPP/ZkfXKzX7B =AffH -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org