Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.0

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: db2

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Hello...

Can somebody please tell me how to create an association for two tables that need to be joined like substr(table1.field1,4,10) = table2.field1


How can I define that association in Hibernate..?

<one-to-one ..?

I would use a "one to many / many to one" relation. See Manual chapter 7.

Thanks, but, how can I specify an association like substr(table1.field,4,10) = table2.field, I mean the value of field for table2 is contained in the field of table1, that's why I need to take only the characters from position 4 to 10 in the string field for table1.

Both fields are primary keys in their respective tables...

Thanks,

chapter 5.1.5. composite-id

I think you can use this to construct your own primary key.

Thanks for you answer again, I did look but I guess that what I need is not there... I don't know if I explain myself crearly, so here I go again...

Let suppose that I have this two tables...

create table table1 (field1 varchar(10) not null primary key, field2 int)
create table table2 (field1 varchar(8) not null primary key, field2 int null, field3 int null)

field1 in table1 contains what's on field1 in table2, the only different is two characters on field1 in table1, that I do not want to take into consideration.

Need to join them, taking only 8 of the 10 characters from field1 in table1 and the 8 character of field1 in table2

How do I create this association, so I only have to use a join in a query


Thanks,

To be free from Database Implementations I wold write a methos to the object with the cropped String (here Object2) and use this property for you HQL.

Sth. like

select o1 from Object1 as o1, Object2 as o2 where o1.pk = o2.croppedFk;

If you want to be close to your database use a native sql query and the given substr('field',startIndex,endIndex) function.

Now closer to your problem?