row « Column « JPA Q&A





1. Single row/column database table to hold an auto-incremented counter with Hibernate?    coderanch.com

I want to keep a counter in a database which I can use for computing a value in my Java code. Each time I use the counter value I want to have it auto-incremented, that way if another thread reads the counter value it will be sure to be unique. I want to use Hibernate to do this, but it's not ...

2. transpose table rows to columns    forum.hibernate.org

I have table with data as below columnname: name| start_time| download_time row1: 'Home Page'| '2009-09-23 00:06:28'| 25 row2: 'Hotmail Home Page'| '2009-09-21 14:20:20'| 25 row3: 'Logout Page'| '2009-09-23 00:06:28'| 1 row4: 'Netbanking After Login Page'| '2009-09-23 00:06:28'| 6 row5: 'Home Page'| '2009-09-23 00:08:53'| 0 row6: 'Netbanking After Login Page'| '2009-09-23 00:08:53'| 0 i have to transpose this table in to something ...

4. common practice : generating a multiple row/column report    forum.hibernate.org

Hibernate version: 3.1.3 Hi, would like to seek some advice on how to support this: - i need to generate a multi row/column report (with the # of items match row and column condition). - I am thinking of using criteria API to dyunamically generate the query the logic seems like this one: for (every row condition) { for (every column ...

5. Tables and Columns represented as rows in DB?    forum.hibernate.org

All, This is a bit leftfield but worth asking. I've been through the docs but here goes: Is there a way to map tables and their columns onto a (say) TABLE table that has a row for each table type, and the columns of an entity onto a (say) COLUMN table that contains the definition of the columns. The actual 'rows' ...

6. Returning a single (object , row, or column)    forum.hibernate.org

Hi All I am using Hibernate version2. I am currently using HQL , Criteria & createSQLQuery to fetch data. What I observed is all these return List & never a single object. From the calling client I have to unnecessarily sift through a list even when I know the underlying query is going to return only 1 instance. Does any one ...

7. Convert row to columns (pivot table)    forum.hibernate.org