StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8665188
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-12-29T07:41:13.267
FavoriteCount
0
LastActivityDate
2015-11-13T20:27:40.547
LastEditDate
2015-11-13T20:27:40.547
LastEditorUserId
627727
OwnerUserId
617455
ParentId
8491275
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Maybe this <a href="http://static.springsource.org/spring/docs/3.1.x/spring-framework-reference/html/jdbc.html" rel="nofollow">tutorial</a> will help. BTW, there is one interesting Spring feature to fit your needs - embedded database support. So, I usually just use following construction to create in-memory H2 db, create schema with schema.sql and fill it with some data from test-data.sql: <pre class="lang-xml prettyprint-override"><code><jdbc:embedded-database id="dataSource" type="H2"> <jdbc:script location="classpath:schema.sql"/> <jdbc:script location="classpath:test-data.sql"/> </jdbc:embedded-database> </code></pre> Then you could use this bean as datasource for you EntityManagerFactory bean: <pre class="lang-xml prettyprint-override"><code><bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" p:dataSource-ref="dataSource" p:persistence-xml-location="classpath:META-INF/persistence.xml"> <property name="jpaVendorAdapter"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"> <property name="databasePlatform" value="org.hibernate.dialect.MySQLInnoDBDialect"/> <property name="showSql" value="true" />  </bean> </property> <property name="persistenceUnitName" value="OpenPU" /> </bean> </code></pre> This is very convenient and concise way to create in-memory database for tests with Spring. (don't forget to add H2 in your classpath) See <a href="http://static.springsource.org/spring/docs/3.1.x/spring-framework-reference/html/jdbc.html" rel="nofollow">documentation</a> for details, chapter "13.8 Embedded database support".
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POTesting Spring-JPA
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USmkobit
UserOwnerUserId
1. USGrigory Katkov
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
CommentsPostId
1. COwhat if you don't have the schema.sql script ?
 singulars
 PostPostId
 PO
 UserUserId
 USKhaledE
2. CO@KhaledE just use it without it `<jdbc:embedded-database id="dataSource" type="H2" />`
 singulars
 PostPostId
 PO
 UserUserId
 USGrigory Katkov

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.