Login DB Connections

[Miguel Sartori]

Hi everyone,

I'm having a problem with DB in my jrun. often my db starts to throw "exceded sessions per user limit". I want to know how can i log the pool connection behavior in my jrun.

Thanks for your time!!!!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: http://www.houseoffusion.com/groups/JRun-Talk/message.cfm/messageid:5821
Subscription: http://www.houseoffusion.com/groups/JRun-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.8

[Kathy Vance]

1. check the license you are using
2. check the setting in Jrun properties file.

Online document may help.
--- Miguel Sartori <miguel.sartori@...> wrote:

> Hi everyone,
>
> I'm having a problem with DB in my jrun. often my db
> starts to throw "exceded sessions per user limit". I
> want to know how can i log the pool connection
> behavior in my jrun.
>
> Thanks for your time!!!!
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: http://www.houseoffusion.com/groups/JRun-Talk/message.cfm/messageid:5822
Subscription: http://www.houseoffusion.com/groups/JRun-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.8

[Miguel Sartori]

>1. check the license you are using
>2. check the setting in Jrun properties file.
>
>Online document may help.
>--- Miguel Sartori <miguel.sartori@...> wrote:


Hi Kathy,

Thanks for your time. Maybe i don't explain it well. I want to log the db behavior, like active connections, returned to pool etc.

Here is my resourse file where i config the debugging property to true, but it didn't work.

jrun-resourse.xml


............... </maximum-soft>
    <debugging>true</debugging>
    <disable-pooling> ..............

do i have to do something more?

thanks

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: http://www.houseoffusion.com/groups/JRun-Talk/message.cfm/messageid:5823
Subscription: http://www.houseoffusion.com/groups/JRun-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.8

[Douglas Knudsen]

take a look at
http://livedocs.adobe.com/jrun/4/JRun_Administrators_Guide/logging.htm
You can modify the logging format to add DB info.  These are set in jrun.xml
file.

DK

On Tue, Apr 15, 2008 at 8:39 AM, Miguel Sartori <miguel.sartori@...>
wrote:

> >1. check the license you are using
> >2. check the setting in Jrun properties file.
> >
> >Online document may help.
> >--- Miguel Sartori <miguel.sartori@...> wrote:
>
>
> Hi Kathy,
>
> Thanks for your time. Maybe i don't explain it well. I want to log the db
> behavior, like active connections, returned to pool etc.
>
> Here is my resourse file where i config the debugging property to true,
> but it didn't work.
>
> jrun-resourse.xml
>
>
> ............... </maximum-soft>
>    <debugging>true</debugging>
>    <disable-pooling> ..............
>
> do i have to do something more?
>
> thanks
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: http://www.houseoffusion.com/groups/JRun-Talk/message.cfm/messageid:5824
Subscription: http://www.houseoffusion.com/groups/JRun-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.8

[Miguel Sartori]

>take a look at
>http://livedocs.adobe.com/jrun/4/JRun_Administrators_Guide/logging.htm
>You can modify the logging format to add DB info.  These are set in jrun.xml
>file.
>
>DK
>
>On Tue, Apr 15, 2008 at 8:39 AM, Miguel Sartori <miguel.sartori@...>
>wrote:
>
>>

Thanks Douglas that was that i need.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: http://www.houseoffusion.com/groups/JRun-Talk/message.cfm/messageid:5825
Subscription: http://www.houseoffusion.com/groups/JRun-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.8