Hibernate Community • View topic - HQL huge problem with cutting query

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL huge problem with cutting query

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

MirekSz

Post subject: HQL huge problem with cutting query

Posted: Thu Aug 19, 2010 4:01 am

Newbie

Joined: Thu Sep 10, 2009 5:43 am
Posts: 15

Hello,
I have simple HQL query

Code:

DELETE FROM DocDefParamValueFlat dcp
WHERE dcp.docDefParam.idDocDefParam = 16
AND dcp.orgCompanyGroup.idOrgCompanyGroup = 2

which generates correct SQL

Code:

delete
 from
  next."DOC_DEF_PARAM_VALUE_FLAT"
 where
  "ID_DOC_DEF_PARAM"=16
  and "ID_ORG_COMPANY_GROUP"=2

Now problem when I put bracket ")" by mistake

Code:

DELETE FROM DocDefParamValueFlat dcp
WHERE dcp.docDefParam.idDocDefParam = 16 ) <-------------- HERE
AND dcp.orgCompanyGroup.idOrgCompanyGroup = 2

hibernate generates SQL like that

Code:

delete
 from
  next."DOC_DEF_PARAM_VALUE_FLAT"
 where
  "ID_DOC_DEF_PARAM"=16

He cuts everything after ")"

How to resolve this problem

Best regards
Mirek

Top

Page 1 of 1

[ 1 post ]

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