Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question
0

Change the Gigaspaces Database Connection Pool

HI all,

For performance issues, we need to change the gigaspaces' Database Connection Pools from DBCP ( https://commons.apache.org/proper/com... ) to HikariCP ( https://github.com/brettwooldridge/Hi... ).

We have to chage the dataSource configuration space persistency ( http://docs.gigaspaces.com/xap102/hib... ):

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="org.hsqldb.jdbcDriver"/>
    <property name="url" value="jdbc:hsqldb:hsql://localhost:9001"/>
    <property name="username" value="sa"/>
    <property name="password" value=""/>
</bean>

And right now, looks like:

 <bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource"  destroy-method="close">
    <property name="jdbcUrl" value="${jdbc.url}" />
    <property name="username" value="${jdbc.user}" />
    <property name="password" value="${jdbc.password}" />
    <property name="driverClassName" value="${jdbc.driver}" />
</bean>

Someone have changed the Gigaspaces' database conneciton Pool? Can you help me and give me some advises ?

Thanks.

asked 2016-08-21 22:25:44 -0500

guedim gravatar image
edit retag flag offensive close merge delete

3 Answers

Sort by ┬╗ oldest newest most voted
0

Hi

There are a number of guides online that explain how to configure hibernate in spring to use other connection pools. The most common connection pool we see is C3P0. Please look here for guidance:

http://josdem.blogspot.com/2012/12/c3...

The following also explain some of the fine points:

http://stackoverflow.com/questions/17... http://stackoverflow.com/questions/55...

Regards

John

answered 2016-08-22 07:56:04 -0500

jb gravatar image
edit flag offensive delete link more
0

Hi John.

Thanks for the response. However the question is not about "how to configurate C3PO or HikariDataSource".

The question is about the risk for changing the Gigaspaces┬┤ Database Connection Pool because Gigaspaces is using the Apache Commons DBCP Library: ($GS_HOME$\lib\platform\ext\commons-dbcp-1.4.jar), but we need to change that library for Hikari.

Kind Regards.

answered 2016-08-22 10:51:38 -0500

guedim gravatar image
edit flag offensive delete link more

Comments

"The most common connection pool we see is C3P0". This means that the most common connection pool we encounter at clients using Hinbernate is not Apache Commons, but C3P0. As far as we know there is no risk involved in changing the pool.

jb gravatar imagejb ( 2016-08-22 11:01:01 -0500 )edit

Thanks for the response.

guedim gravatar imageguedim ( 2016-08-22 11:48:42 -0500 )edit
0

Hi,

We already have changed the database connection pool and everithing is ok. We are monitoring the database connections (idle and open) and we get a good performance.

Thanks.

answered 2016-09-24 11:39:07 -0500

guedim gravatar image
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2016-08-21 22:25:44 -0500

Seen: 181 times

Last updated: Sep 24 '16