I believe what you are asking for is already available. See inline comments below.
> -----Original Message----- > From: Vijay Kumar [mailto:vijy.gan...@gmail.com] > Sent: Monday, June 01, 2015 7:48 AM > To: Tomcat Users List > Subject: Re: can we pass OS username while connection Database from > Tomcat > > 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. > > 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. > V$SESSION already contains the columns MACHINE and OSUSER and these values should be populated by the Oracle driver. They are on all my systems. Should be everything you need to meet your requirement, unless you are running on the same box and same O/S user as your client's legacy programs. > 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" This is the V$SESSION column PROGRAM, which the Oracle Thin Client does not set automatically. The Thick client (OCI drivers) will set it for you. I think you can modify your code to set it when creating the connection, but I'm not sure how. For this use case, Google is your friend. Or ask on an Oracle/Java forum. > > Thanks, > Vijay G > > On Fri, May 29, 2015 at 8:48 PM, Jeffrey Janner > <jeffrey.jan...@polydyne.com > > wrote: > > > Please see response below post: > > > > > -----Original Message----- > > > From: Vijay Kumar [mailto:vijy.gan...@gmail.com] > > > Sent: Thursday, May 28, 2015 7:22 AM > > > To: Tomcat Users List > > > Subject: Re: can we pass OS username while connection Database from > > > Tomcat > > > > > > Hi , > > > > > > I am referring User_Id as Linux User_id where we installed Tomcat. > > > > > > My Oracle Database don't know about this user_id. > > > > > > > > > Thanks, > > > Vijay G > > > > > Vijay - > > As another tomcat->oracle integrator, I do have to ask, exactly what > is it > > your client is trying to monitor and what tool is he going to use? > > But first let's clarify the question: > > 1) Tomcat is running as the O/S user "apps" and your client > wants > > to see the connections from O/S user apps? And why? This may already > be > > available in the database structures. > > or > > 2) Tomcat is connecting to the database using the schema name > > "apps" and the client want to see these connections? That's already > > available on the Oracle side. This depends on what tool the client is > > using. > > Or > > 3) the client wants to see the user names of the application > users > > in the monitoring tool? Depending on this answer and the tool used, > you > > are really getting into Oracle programming territory, as there are > several > > ways to do this. > > > > As for answering the straight-forward question, a quick Google search > > found several replies, all requiring changes to the application code > that > > connects to the database. Actually from what I understand, the Oracle > > drivers already provide this, at least the latest versions. > > > > Jeff > > > > > > > On Thu, May 28, 2015 at 3:20 PM, André Warnier <a...@ice-sa.com> > wrote: > > > > > > > Vijay Kumar wrote: > > > > > > > >> Hi Mark, > > > >> > > > >> Please find below my exact requirement. > > > >> > > > >> I have Oracle Database where my objects are installed and I have > also > > > a > > > >> Linux instance where i installed Tomcat. > > > >> I am currently creating connection to the Oracle database from > Tomcat > > > >> using > > > >> 'apps' user as this schema is having all permissions. > > > >> > > > >> One of my client want to monitor the connections that are created > > > from my > > > >> application. For this i want to pass my Linux user information > > > (userid) > > > >> while creating the connection from my application or in > context.xml > > > file. > > > >> > > > >> Please suggest the approaches? If SPENGO can you redirect me any > > > doc/post > > > >> how to achieve this? > > > >> > > > >> Vijay, > > > > you are repeating yourself (and still top-posting), but you are > not > > > > providing the crucial information which would enable someone to > really > > > help > > > > you. > > > > For example, what "Linux user information (userid)" are you > talking > > > about ? > > > > > > > > Is it the Linux user-id under which Tomcat is running ? > > > > That would probably be "tomcat", so that is probably not going to > help > > > you > > > > fulfill your customer's wishes. > > > > > > > > Is it the user-id of the /user/ of your Tomcat application ? > > > > In that case, how does Tomcat know this user-id ? Do the users > login > > > into > > > > your application ? How ? What is the user authentication mechanism > > > being > > > > used, now, at the Tomcat level ? > > > > > > > > Does the Oracle database also know this user-id ? How ? > > > > > > > > What does "One of my client want to monitor the connections" mean, > > > exactly > > > > ? what does the customer want to know, and when ? Is this customer > the > > > only > > > > user/manager of the Oracle database, or are there multiple > > > users/managers > > > > of the Oracle database ? > > > > > > > > > > > > > > > > ------------------------------------------------------------------ > --- > > > > 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
