Is it possible to insert comment in the generated query ...?

tsmets · **Posted:** Mon Jan 22, 2007 10:15 am

Dear,

Our projects uses mainly spring.
We have request from the developpers to TAG their queries with the name of the DAO.

Code:

  public static final String EXIST_EMPLOYEE_ID =
      "SELECT /* EmployeeDAO S.3 */ FIRST_NAME, LAST_NAME FROM USER WHERE KEY = ?";

The point is to quickly find the DAO where the query "spotted" by Oracle performance tools are. It has proove itself usefull (and very usefull to inform third party that we were monitoring what they were doing in our application).

We also allow third party to query our schema & one of those is written with Hibernate. Is there some mean to do something similar with the query generated by hibernate .... ?

Tia,

\T,

Quote:

-- CONFIG --
Hibernate version: 3.2 (or later the one included in JBoss 4.0.3)
Mapping documents: N/A
Code between sessionFactory.openSession() and session.close(): N/A
Name and version of the database you are using: Oracle 9g
-- CONFIG --

max · **Posted:** Mon Jan 22, 2007 10:28 am

don't use the spring interfaces; then you will see that Hibernate API (especially) Query and Criteria has a setComment method.

also look at the use_sql_comments property.

max · **Posted:** Mon Jan 22, 2007 10:29 am

be warned though that oracles driver can have issues with sql comments.

tsmets · **Posted:** Mon Jan 22, 2007 12:46 pm

Max,

There is however one detail I may not have made obvious but ... which I believe is making your response unusefull (correct me if I am wrong).

As the hibernate devs do not write the query themselves but let Hibernate generate the query... I will look into the setComment(...) to see it that could help !

Tx already,

\T,

( I will rate :) )