StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POspring + hibernate + data base connection pooling and high availability
primarykey
Id
12395826
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-09-12T20:35:01.523
FavoriteCount
0
LastActivityDate
2018-04-23T10:28:18.420
LastEditDate
2018-04-23T10:28:18.420
LastEditorUserId
1033581
OwnerUserId
1666886
ParentId
0
PostTypeId
1
Score
1
ViewCount
947
LastEditorDisplayName
text
Body
I'm trying to configure my web application like this: 1 tomcat server 2 mysql data bases in master/ master replication for failover purpose. I also succeded to set up a pooled connexion using c3p0, thus avoiding to open a new connexion for each request(when no failover is involved) I would like to use the failover support porvided by the jdbc connector in order to route request to the second database when the first one is unavailabe. Thus i'm using the fail over capability of the jdbc driver, simply by providing extra configuration parameters. For the moment, when one server is unvailable, the requst are routed to the second available server. However, i'm facing a problem with a new opened connexion on the database for each request. It seems that combaining connexion pooling and jdbc failover dosen't work toogther ? Please advice, also regarding configuration parameters <pre><code><bean id="mydataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="com.mysql.jdbc.Driver"/> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306,myOtherServer:3306/zeus?autoCommit=true&amp;autoReconnect=true&amp;autoReconnectForPools=true&amp;failOverReadOnly=false"/> <property name="user" value="root" /> <property name="password" value="root" />   <property name="minPoolSize" value="6" /> <property name="maxPoolSize" value="10" /> <property name="maxIdleTime" value="100" /> </bean> </code></pre>
Tags
<mysql><spring><hibernate><cluster-computing><failover>
Title
spring + hibernate + data base connection pooling and high availability
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCœur
UserOwnerUserId
1. USuser1666886
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POspring + hibernate + data base connection pooling and high availability
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.