Search code examples
javahibernatehqljpqlquerydsl

Get Querydsl Oracle Rowid when we have more than one table

I have a problem when using OracleGrammar.rowid in querydsl where we need to join multiple tables and the rowid column is getting ambigous in the query. i searched ways to specify the table of rowid and still could not found an answer, please help me

query.select(OracleGrammar.rowid, Q1.a, Q2.b).from( Q1, Q2)

OracleGrammar.rowid => ambigous column

Thank you.

Solution

  • You could create a template using stringTemplate(): 

    Expressions.stringTemplate("{0}.rowid", Q1.a)