Pulling a field from another table in Hibernate

Tin Wizard Published at Dev

Tin Wizard

I have two tables, which have a one-to-one relationship and look something like this:

OrderItem

ID    data1   data2   data3
1     a       b       c
2     d       e       f
3     g       h       i

DisputedItem

ID    data4
1     q
3     r

Is there a way to pull data4 into my Hibernate model for OrderItem without having a separate DisputedItemModel? Preferably using annotations.

Johnson Abraham

You can use Hibernate @Formula annotation, if you have annotation based mappings or <formula> tag if you are mapping by XML.

What formula can do is help you extract a value by a query and map it to a field in your OrderItem domain model. This field can be from any table but the query thats used to map the property should return the indented field type.

You can use following URL for reference Hibernate Formula

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-20

Comments

0 comments

From Dev

Related Related

Article

Pulling a field from another table in Hibernate

Pulling a field from another table in Hibernate

Adding a field from another table to results

How to create new field in view with some offset (field of table) from existing field (another field of table)?

Copy Field contents from one Table to another table - FileMaker

SQLite, select where field 'like' field from another table

Conditional update pulling from another table - Access syntax error

Pull field from another table in MVC

Pulling posts from another WordPress site

Field involving multiple rows from another table

Pulling a field from mysql table with php

Refresh a field from another table [Django]

Set field to random value from another table

Hibernate HQL query get data from table associated with another table

Pulling records from one table (products) depending on a value in another (department)

MYSQL Copy field from one table to another table

Pulling results from one function into another function

Pulling a field from a list based on second list

Using values from a field in one table as column name for field in another

Adding a field from another table to results

select field from table in another field from another table

Pulling data from one table to use in another query for SQL Server?

Pull field from another table in MVC

sql - show count of field from another table

Select Additional Field from another Table

Pulling a field from mysql table with php

Add field in a Gii form from another table

Limit values for a field to entries in another table in hibernate

Delete trigger and getting field from another table

Call field from another table in select firebase

DRF: validate a field from another table