StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4919116
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-02-07T08:01:35.753
FavoriteCount
0
LastActivityDate
2011-02-07T09:03:10.123
LastEditDate
2011-02-07T09:03:10.123
LastEditorUserId
594349
OwnerUserId
594349
ParentId
4726512
PostTypeId
2
Score
18
ViewCount
0
LastEditorDisplayName
text
Body
You should really go for C3P0 connection pooling: <a href="http://www.mchange.com/projects/c3p0/index.html#hibernate-specific">http://www.mchange.com/projects/c3p0/index.html#hibernate-specific</a> There is a section in C3P0 documentation on that subject: <a href="http://www.mchange.com/projects/c3p0/index.html#configuring_recovery">http://www.mchange.com/projects/c3p0/index.html#configuring_recovery</a> First you have to properly configure c3p0, which in case of using hibernate must happen in c3p0.properties file. In your c3p0.properties put these properties to retry to reconnect indefinitely every 3 seconds when database is down: <pre><code>c3p0.acquireRetryAttempts = 0 c3p0.acquireRetryDelay = 3000 c3p0.breakAfterAcquireFailure = false </code></pre> Also, to avoid broken connections lying in your pool indefinitely, use connection age management: <pre><code>c3p0.maxConnectionAge = 6000 c3p0.maxIdleTime = 6000 c3p0.maxIdleTimeExcessConnections = 1800 c3p0.idleConnectionTestPeriod = 3600 </code></pre> These may be quite expensive, but helpful if above is not enough: <pre><code>c3p0.testConnectionOnCheckout = true c3p0.preferredTestQuery = SELECT 1; </code></pre> You may also want to check for connection leaks which prevent recovery: <pre><code>c3p0.debugUnreturnedConnectionStackTraces = true </code></pre> And finally, make sure that C3P0 is hooked with hibernate correctly, enable debug logging for "com.mchange" package and see if C3P0 tells you anything about itself. It should state configuration properties which are loaded, so see if it's all there. I hope this helps.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PORecover Hibernate connection
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSpajus
UserOwnerUserId
1. USSpajus
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 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.