hibernate, created SQL query

Question

I have mapped class, that have ID with custom type

<id name="idPersistent" type="objectID" column="aa_id" > 
         <generator class="ObjectIDSequenceGenerator">
            <param name="sequence">lab_patient_seq</param>
         </generator>
      </id>

Field aa_id have type in DB

number(14)

My ID's sustom type have have types Long and ObjectID (ObjectID is my class). (nullSafeGet return ObjectID, nullSafeSet return Long).

In SQL query, created by hibernate, i have next

select patient0_.aa_id as aa1_1224_1_ ...... and patient0_.aa_id=?

What type will be on "?" position? Where from Hibernate get '?' value?

what code did you write in java to trigger this SQL?

ManuPK
– ManuPK

2012-03-05 14:25:41 +00:00
Commented Mar 5, 2012 at 14:25 — ManuPK
– ManuPK, Commented Mar 5, 2012 at 14:25
Query is created by method merge()

Ilya
– Ilya

2012-03-05 14:46:48 +00:00
Commented Mar 5, 2012 at 14:46 — Ilya
– Ilya, Commented Mar 5, 2012 at 14:46

Firo · Accepted Answer · 2012-03-06 09:32:42Z

1

it should be Long since Hibernate will use your UserType to get the value to compare to.

answered Mar 6, 2012 at 9:32

Firo

30.8k4 gold badges57 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

hibernate, created SQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related