StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12372615
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-09-11T14:56:56.383
FavoriteCount
0
LastActivityDate
2012-09-11T14:56:56.383
LastEditDate
LastEditorUserId
0
OwnerUserId
1306891
ParentId
12370246
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
[From the <a href="http://wiki.cloudbees.com/bin/view/RUN/DatabaseGuide" rel="nofollow">Database Guide</a> on the CloudBees Wiki] MySQL includes a timeout that will close connections that have been idle for long periods of time. For improved Database performance, CloudBees DataSources use the Apache DBCP connection pool to reuse JDBC connections after they are closed by the application. If you use a connection that has been in the pool idle for too long, your application will likely experience the following error: "The last packet successfully received from the server was XXX seconds ago". The connection pool includes a setting the will validate and throw out dead connections when calling javax.sql.DataSource.getConnection(). To use this setting, add the following XML params to your DataSource definition in cloudbees-web.xml. <pre><code><param name="validationQuery" value="SELECT 1" /> <param name="testOnBorrow" value="true" /> </code></pre> So for your resource, you should be able to do the following: <pre><code><resource name="jdbc/myapp" auth="Container" type="javax.sql.DataSource"> <param name="username" value="myuser" /> <param name="password" value="mypass" /> <param name="url" value="jdbc:cloudbees://myurl /> <param name="validationQuery" value="SELECT 1" /> <param name="testOnBorrow" value="true" /> </resource> </code></pre> If you are using the bees app:bind command instead of cloudbees-web.xml to inject your datasources, you can use these params as arguments to the command <pre><code>bees app:bind -a APP_ID -db DB_NAME -as JNDI_ALIAS validationQuery="SELECT 1" testOnBorrow=true </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POResuming an application from sleep causes 'Communications link failure'
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USswashbuck1r
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POResuming an application from sleep causes 'Communications link failure'
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
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.