Hello all,
I am new to Hibernate and also this Forum.
can anyone tell what is the difference if I use native SQL using "session.createSQLQuery()" and use of JDBC Connection using "session.connection()" ??

is there any performance issue or anything else?

Thanks in advance

Session.connection returns an javax.sql.Connection through which one can create either statement or prepared statement manually and manage jdbc transaction manually as well.

Where as in Hibernate the SQLQuery object's query will depend how the sql string is created. If the string is created with parameters in that case the statement internally created by hibernate is a prepared statement and if the query is hitting the DB relatively more frequently that other queries than it is benefecial otherwise not as it will take a lot of space.
On the other if the query string is formed of string concatenation than it will be normal jdbc statement. Further you can manage the transaction from hibernate of Spring .

I think you will get the rest of the picture from here on. Let me know if you find anything interesting

Thank you.