Can hibernate execute JDBC SQL directly?

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Hi everyone:

I want to know if hibernate can execute jdbc SQL directly.For example,I want to execute a sql query like

Code:

"insert into tablename values('343','test','hello');"

or

Code:

"update tablename set... ...,set...".

Can hibernate support it ? If it can how to do? I find that the Session object don't give me such method. Could someone give me an idea?

tq · **Posted:** Thu Sep 09, 2004 5:29 am

try session.createSQLQuery

max · **Posted:** Thu Sep 09, 2004 7:41 am

Correction:

createSQLQuery is for *Querying*, not data manipulation.

To do the above simply use the jdbc Connection available via the connection() method on Session.

tq · **Posted:** Thu Sep 09, 2004 8:24 am

max wrote:

Correction:

createSQLQuery is for *Querying*, not data manipulation.

To do the above simply use the jdbc Connection available via the connection() method on Session.

thank you, still learning something daily here

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

max wrote:

Correction:

createSQLQuery is for *Querying*, not data manipulation.

To do the above simply use the jdbc Connection available via the connection() method on Session.

Thank you .You mean that I can't using this method for insert a record directly. I have to get a connection and get a resultset using this connection.