hibernate

Suppress ORA-00942 errors in ddl create scripts

Say you generate ddl to create all your db tables etc via Hibernate SchemaExport etc. What you get is a script which starts with drop statements at the beginning. Not a problem, as I want this. But running this script produces a crapload of ORA-00942 errors running on an Oracle db. Since they're not really errors if the tables just...

org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

HI i am using struts and hibernate. i have a parent and child relation using set in hbm. in the action i am using session.saveOrUpdate() method to save but while saving it is showing the below error. can anyone help regardng this with explanation where i made the mistake here is my hbm.file <?xml version="1.0"?> <!DOCTYPE hibernate-m...

Multi-user Datasources - Spring + Hibernate

Hi, I'm writing a web app that supports multiple users. Each user has their own database - using H2. all database schemas are the same. I wish to use Spring + Hibernate for this application. So I'm stuck at how to associate a user's database with that user - maybe associated it in the HTTPSession, and extend spring's AbstractRoutingDa...

Is it mandatory to instantiate collection fields in JPA?

I was reading an article in which the author had implemented an Entity class like this: @Entity public class Product { @OneToMany private List<Part> parts; // note the missing "= new ArrayList<Part>();" public Product() { } // getters and setters } I always used to instantiate collection fields, in this case parts, either inl...

JPA/Hibernate Static Metamodel Attributes not Populated -- NullPointerException

I would like to use JPA2 Criteria API with metamodel objects, which seems to be pretty easy: ... Root<JPAAlbum> albm = cq.from(JPAAlbum.class); ... albm.get(JPAAlbum_.theme) ... ; but this Root.get always throws a NullPointerException. JPAAlbum_.theme was automatically generated by Hibernate and looks like public static volatile Sing...

How to implicitly join across collections in Hibernate?

The object structure is like below- Entity A - Collection <B> Entity B - Collection <C> Entity C -Collection <D> Entity D CompositePrimaryKey Class CompositePrimaryKey String id; In the HQL, the query is like from A a where a.B.C.D.CompositePrimaryKey.id = 'input'; I am getting the below exception- org.hibernate.QueryE...

Grails: Querying Associations causes groovy.lang.MissingMethodException

Hi, I've got an issue with Grails where I have a test app with: class Artist { static constraints = { name() } static hasMany = [albums:Album] String name } class Album { static constraints = { name() } static hasMany = [ tracks : Track ] static belongsTo = [artist: Artist] String name } class Track { static constraints...

What is wrong with my JPA Criteria API code (taken from JEE6 Tutorial)?

This is my code, which I can't even compile: /** * Find a project that has NO employee assigned yet. */ public Project findEmptyProject() { // getting criteria builder CriteriaBuilder cb = this.em.getCriteriaBuilder(); // gathering meta information about left-joined entity Metamodel m = this.em.getMetamodel(); EntityType<Emp...

Filter Lazily Initialized Hibernate Collection

This might be a super easy answer, since I'm sure it's not uncommon. I see some similar questions, but nothing that seems to describe my problem. I have two objects: a car and person. They're in a many-to-many relationship, i.e. a car can be owned by multiple people, and a person can own multiple cars. Car has a lazily initialized se...

Grails: sum of field within criteria builder

I'm at a loss of how to create a running sum of particular field after creating a criteria within a controller I'm currently creating a set of set of records using: def b = Tapes.createCriteria() def yesterday = b.list(sort: 'migratedDate', order: 'asc') { between ("migratedDate", dat.minus(1), dat) } and counti...

Hibernate nextval get id

I use Hibernate with annotations. I need to insert object into the database using a method who needs one parameter that I need to calculate, to do this I use: SQLQuery sqlQuery = getSession().createSQLQuery(queryString); sqlQuery.executeUpdate(); The queryString contains: INSERT INTO TABLE(ID, NUMBER) VALUES (SEC_TABLE.NEXTVAL, 549) ...

Mapping column and table names in EclipseLink

I used ImprovedNamingStrategy in hibernate, to mapping Java field name to MySQL column name. ex) birthDate field -> birth_date column, AccountRole class -> account_role table I'm doing test migrating hibernate code to eclipselink code. What is the equivalent in EclipseLink to hibernamte's ImprovedNamingStrategy ? ...

Custom property serialization

Hello, I have a class that contains a list of objects, say a list of cars : class Garage { public virtual List<Car> cars { get; set; } } The reason I can't directly serialize this list is that the type Car could have a lot of subclasses, and themselves could have other subclasses, and I'd like to avoid upd...

Hibernate lazy loading in detached objects

I have created a class in which I have set some of it's fields (other entities) to be LAZY loaded. Now I need to use this object after it has been detached from the session, so I obviously need to make sure all the fields that I need are populated before detaching it. I tried just calling the getters to these lazy fields but that didn't ...

Hibernate, NamedQuery & Handlling NamedParamater in the case of it is Null or not available

Hi, I am using one named query to search some result in my Project. e.g ( from StructureEventDAO as se where se.Structure.StructureId = :StructureId and se.eventMaster.eventName =:eventName ). This is giving proper result if I pass required both the named parameter value. I just wanted to know what if runtime I have one of the parame...

Why does this HQL delete fail, when an HQL select with same terms works?

Why does the following HQL query fail? string hql = @"delete MyLog log where log.UtcTimestamp < :threshold and log.Configuration.Application = :application"; session.CreateQuery(hql) .SetDateTime("threshold", threshold) .SetEnum("application", this.application) ...

Issue: Table per sub class using discriminator

Hi All Short Summary of Problem Hibernate is assuming that whenever someone is using subclass all the columns should be created in the top root of the class hierarchy irrespective of what table name has been provided. Can someone please explain the reasoning behind it and if there is way to bypass this code and somehow avoid invoice_id...

Hibernate Join Table with Child

Hello I have two tables (folder and document) which have a many to many relationship with a join table in between, this join table then also has another one to many relationship with a third table (document_title). I want to be able to fetch a document_title from a document, what is the correct way to model this in hibernate? The obj...

Explicit constructor using Lombok?

Hello there, I'm rewriting some messy code that manages a database, and saw that the original programmer created a class mapped to the database like so: (I've removed unnecessary code that has no purpose in this question) @Entity @Data @EqualsAndHashCode(callSuper = false, of = { "accessionCode", "header", "date" }) @SuppressWarnings(...

Hibernate annotation unnecessary delete and insert

I have a class A which has set of class B. class A and class B has their own table. When i insert class A it also insert class B. When i update class B, Hibernate deletes everything from class B which belongs to that instance of A and then insert all values in current set B. I want that if only 2 new values are added in set b, then it on...