[jira] Commented: (AMQ-728) Active MQ is creating great number of Oracle processes

["Hiram Chirino (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/activemq/browse/AMQ-728?page=comments#action_36300 ] 

Hiram Chirino commented on AMQ-728:
-----------------------------------

Hans,

Could you try setting up activemq to use the c3p0 http://sourceforge.net/projects/c3p0 datasource instead of the commons datasource?
We have had reports that it works much better.  Could you confirm?



> Active MQ is creating great number of Oracle processes
> ------------------------------------------------------
>
>          Key: AMQ-728
>          URL: https://issues.apache.org/activemq/browse/AMQ-728
>      Project: ActiveMQ
>         Type: Bug

>   Components: Message Store
>     Versions: 3.2.1
>  Environment: Sun Solaris 8, Oracle 9i2, Java 1.4.2_08
>     Reporter: Hans Huber
>  Attachments: OracleAfter.png, OracleBefore.png
>
>
> We migrated from derby to Oracle as message persistence layer. We discoverd now, that ActiveMQ is creating a lot of Oracle resource intensive processes. Please see attached diagrams:
> OracleBefore.png = Orace processes with derby as persistence layer
> OraceAfter.png = Oracle processes with Oracele as persistence layer
> Any help is much appreciated. If you need any additional information, pls don't hesitate to contact me
> Best regards, Hans Huber

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   https://issues.apache.org/activemq/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira