database « Fetch « JPA Q&A





1. Left join fetch and prefetching    stackoverflow.com

I have a question , when we have a query like Select DISTINCT A from A a left join fetch a.b JPA will bring the object A populated, and the object b, ...

2. hibernate and jpa weirdness; unexpected lazy fetching    stackoverflow.com

I'm using a rather old version of Hibernate (3.2.4) so it's possible this is related to that. Unfortunately the project requirements prevent me from upgrading. I have a class Foo with ...

3. Hibernate reverse engineering process not fetching database metadata    stackoverflow.com

My Hibernate reverse engineering process is not fetching database metadata at all. If I use the hibernate tools eclipse wizard, the process works fine, but outside of eclipse, am unable to do ...

4. Retrieve unread posts from database    stackoverflow.com

I've got a simple web application with two persistent classes, User and Post, both managed by Hibernate. I'd like the User to be able to list the posts which he hadn't ...

7. Hibernate - How to retrieve data from the database    coderanch.com

Here's a little class I call my CrudRunner. It demonstrates how to use Hibernate to do the basic Create Retrieve Update and Delete (destroy?) methods. Here's the very simple table it works with: drop table if exists examscam.user create table examscam.user (id integer not null auto_increment, login_name varchar(255) unique, password varchar(255) not null, primary key (id)) Here is the entity that ...

8. Eager-fetch on case-insensitive database    forum.hibernate.org

I'm having an issue with Hibernate "JOIN FETCH" behaviour on a SQL Server database defined with a case-insensitive collation. The version of Hibernate is 3.2.4. Whilst it would be interesting to know if any later version "fixes" this problem upgrading is not a viable short-term option. Our code performs a query where a number of entity types are joined. One pair ...

9. How can i retrieve structure of a database?    forum.hibernate.org

yes i can retrieve tables' names by using APIs of MiddleGen. Unfortunate it doesn't work when running as a servlet. code fragment is pasted below: Middlegen middlegen = new Middlegen(null); Database database = new StandardDatabase("com.mysql.jdbc.Driver", "jdbc:mysql://localhost/test", "root", ""); MiddlegenPopulator middlegenPopulator = new MiddlegenPopulator(middlegen, database, "test", "", new HashMap()); // read all regular tables middlegenPopulator.addRegularTableElements(); middlegenPopulator.populate(middlegen.getTableElements()); //above line will throw an exception ...





10. fetch still hit the database with queries    forum.hibernate.org

Beginner Joined: Fri Apr 16, 2004 10:25 am Posts: 44 Location: Brazil I'm trying to fetch to table so hibernate dont keeping hitting the DB but it seems that the fetch doesnt work Hibernate version: 2.1.6 Mapping documents: Code: ...

11. How to retrieve several collections in one DB query    forum.hibernate.org

Suppose I have a class representing a list of other entities. I would like to initialize several lists with thier items in a minimum number of queries. Currently, I can fetch all lists with a single query but fetching each list items requires a separate query for each list. Hibernate version: 2.1.4 Mapping documents: Code:

12. fetching database metadata fails    forum.hibernate.org

13. can't fetch data from database    forum.hibernate.org

14. cannot retrieve database    forum.hibernate.org

i use mysql database. i have try to run mysql server in DOS prompt to retrieve the database but no database can be fetched. my hibernate.cfg.xml is as shown below: ...

15. Unable to retrieve data from DB    forum.hibernate.org

Hi, I am unable to retrieve field values from the mysql db. My POJO is in package pack.Hris DB table is candidate, field in the table is firstname. On executing the following code my result object is empty. here is a piece of code under pack.HrisManager : "id" is private Long id in pack.Hris List result = session.createQuery("select hris.firstname from pack.Hris ...

16. Improving the Fetching of data from DB    forum.hibernate.org

Regular Joined: Wed Oct 15, 2008 6:59 am Posts: 103 Location: Chennai Hi Friends! I am new to hibernate. now i am working in hibernate enhancement project. For this project we are using MyEclipse 5.5 and MySQL 5.0. where i am using HQL queries to retrieve data from mysql database. the code like as Code: public String[] checkSecurityCode(String code){ ...