how to write innerjoin query using hibernate?

user_18733038 0
Viewed 45

I was trying to query using hibernate and im getting some alias and some other errors. can anyone help me to write code for below query

select columnA,x.columnB ,* from Table_A 
inner join Table_B  on x.tableA_ID = y.TableB_id
where x.columnC in (3,6) and x.columnD <> 1 and
y.Column2 >= '2021-02-05 15:47:01.000'

I have tried the below code,

String date="2021-02-05 15:47:01.000"
Query query = session.createSQLQuery("select x.columnA,x.columnB ,* from Table_A x\n" +
                "inner join Table_B y on x.tableA_ID = y.TableB_id\n" +
                "where x.columnC in (1,2) and x.columnD <> 1 and\n" +
                "y.Column2 >= '"+date+"'");
resultList= query.list();

error:

Encountered a duplicated sql alias [columnB] during auto-discovery of a native-sql query; nested exception is o

hibernate java
2 Answers

Could you clarify if you are using native SQL or HQL? It seems to me that you specified table names instead of entity classes in the query.

user_43450060

The issue is resolved by removing the ",*".

Query query = session.createSQLQuery("select x.columnA,x.columnB from Table_A x\n" +
                "inner join Table_B y on x.tableA_ID = y.TableB_id\n" +
                "where x.columnC in (1,2) and x.columnD <> 1 and\n" +
                "y.Column2 >= '"+date+"'");
user_187330380
Related