> 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 a
Chris,
> You can use the following in the connectionInitSqls to make sure a suitable
> variable it set
>
> exec dbms_application_info.set_action('INSERTING');
>
> The site http://psoug.org/reference/sys_context.html references a bucket
> load of different context parameters that can be set - CLI
>
>
> The problem he appears to be encountering is that he is unable to customize
> the
> value in v$session.program. The reason for the problem is that he does not
> know
> how to do it either when using the OCI jdbc driver (it is likely not
> possible).
>
Jason,
So oci or thin driver is largely
> -Original Message-
> From: chris derham
> Sent: Wednesday, March 16, 2011 15:41
> To: Tomcat Users List
> Subject: Re: Populating Oracle v$session.program from Tomcat
> Context.xml
>
> > We'd like to be able to tell apart database sessions from
> th
> 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 ab
> -Original Message-
> From: Dan
> Sent: Wednesday, March 16, 2011 14:34
> To: Tomcat Users List
> Subject: Re: Populating Oracle v$session.program from Tomcat
> Context.xml
>
> We'd like to be able to tell apart database sessions from the
> 15 o
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
What is the problem that you are trying to solve?
On Mon, Mar 14, 2011 at 4:25 PM, Dan wrote:
> On Mon, Mar 14, 2011 at 11:25 AM, Dan wrote:
>> On Mon, Mar 14, 2011 at 10:57 AM, chris derham wrote:
We have some working tomcat 6 instances that we'd like to identify
>>>
>>>
>>> Can you use t
> > We have some working tomcat 6 instances that we'd like to identify
>
> > >> 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!
>
You didn't say what connection pool you are usi
> Subject: Re: Populating Oracle v$session.program from Tomcat Context.xml
> From: dfis...@jmlafferty.com
> Date: Mon, 14 Mar 2011 18:08:53 -0700
> To: users@tomcat.apache.org
>
> >>>> We have some working tomcat 6 instances that we'd like to identify
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. I
On Mon, Mar 14, 2011 at 11:25 AM, Dan wrote:
> On Mon, Mar 14, 2011 at 10:57 AM, chris derham 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 environme
On Mon, Mar 14, 2011 at 10:57 AM, chris derham 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 nam
> Hello all...
>
> We have some working tomcat 6 instances that we'd like to identify by
> querying the v$session.program field the oracle database they connect
> to. While there are no errors on startup for the tomcat instance, and
> we can connect to the database, nothing gets populated in v$ses
> 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 dif
15 matches
Mail list logo
