Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Query Delete

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

alohse

Post subject: Query Delete

Posted: Tue May 11, 2004 8:28 am

Beginner

Joined: Tue May 11, 2004 8:24 am
Posts: 23

Hi,

I need to fire SQL "DELETE" Statements from our Application. I would most preferably do this using NamedQuerys.

This is not possible currently right?
Is the a timescale of this feature?
Is there an alternative way how to do this?

Maybe anyone can explain to me how to fire a direct JDBC-Query using the Hibernate Session Connections?

Regards,

Alex

Top

shl

Post subject:

Posted: Tue May 11, 2004 11:05 am

Expert

Joined: Fri Feb 06, 2004 7:49 am
Posts: 255
Location: Moscow, Russia

For that purposes I use Session's method

Quote:

public int delete(String query) throws HibernateException
Delete all objects returned by the query. Return the number of objects deleted.

where query is an ordinal HQL select query.

http://www.hibernate.org/hib_docs/api/net/sf/hibernate/Session.html#delete(java.lang.String)

Top

shl

Post subject:

Posted: Tue May 11, 2004 11:09 am

Expert

Joined: Fri Feb 06, 2004 7:49 am
Posts: 255
Location: Moscow, Russia

To execute low-level SQL queries use Session.createSQLQuery(..) methods.

Top

alohse

Post subject: Thank you.

Posted: Wed May 12, 2004 3:07 am

Beginner

Joined: Tue May 11, 2004 8:24 am
Posts: 23

that helped me.

Regards,

Alex

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum