StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20463752
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-12-09T05:26:59.770
FavoriteCount
0
LastActivityDate
2013-12-09T05:26:59.770
LastEditDate
LastEditorUserId
0
OwnerUserId
179630
ParentId
20415638
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
In my opinion hibernate isn't really designed for such scenario. Hibernate requires a pre-defined java class types to map to on compile-time so it knows how to generate SQL. You can however try writing a JDBC ResultSet data access class without hibernate that allows schema changes without requiring java compilation by utilizing ResultSet <a href="http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getMetaData%28%29" rel="nofollow">getMetadata() method</a> and storing all the columns in a Map. The key of the map is the SQL column name: <pre><code>public class Animal { private Map<String,Object> properties = new HashMap<String,Object>(); // getters & setters.. } </code></pre> One problem when using this approach is again you don't know which of the jdbc ResultSet get method you should use: rs.getString(), rs.getInt(), rs.getLong()... ?? You can try the generic <a href="http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getObject%28java.lang.String%29" rel="nofollow">rs.getObject(columnName)</a> method. Querying & mapping result set using Spring <a href="http://docs.spring.io/spring/docs/3.0.x/api/org/springframework/jdbc/core/JdbcOperations.html" rel="nofollow">JdbcOperations</a> might look like this: <pre><code>List<Animal> animals = jdbcOperation.query("select * from animal", new RowMapper<Animal>() { @Overrides Animal mapRow(ResultSet rs, int rowNum) throws SQLException { Animal animal = new Animal(); ResultSetMetaData meta = rs.getMetaData(); for(int i = 1; i <= meta.getColumnCount(); i++) { String columnName = meta.getColumnName(i); animal.getProperties().put(columnName, rs.getObject(columnName)); } return animal; } }); </code></pre> Code above will not require re-compilation if you add/remove a column. You can also apply the same concept for updates / insertion. However retrieving the column value gets ugly. Since everything is stored as Object, you need to know what to cast it to. <pre><code>// Getting this animal's name String name = (String) animal.getProperties().get("name"); </code></pre> Other approach I can think of is to use <a href="http://en.wikipedia.org/wiki/NoSQL" rel="nofollow">NoSQL</a> approach with which you don't even need to define a data schema.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHibernate how to implement dynamic data structure
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USgerrytan
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. 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.