This week's giveaway is in the Threads forum.
We're giving away four copies of Java Concurrency Live Lessons and have Doug Schmidt on-line!
See this thread for details.
Win a copy of Java Concurrency Live Lessons this week in the Threads forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

hql delete join  RSS feed

 
siraj baig
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am able to delete records from a single table.
But when i try to delete from multiple tables using joins Hiberate throws
Exception:

Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: unexpecte d token: , near line 1, column 31

My Query: " delete from org.hib.Table1 t1,org.hib.Table2 t2 where ta.id = t2.id and t2.name=name "

Can you please tell me how to delete records from multiple tables using joins

Thanks
siraj.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!