Hibernate Community • View topic - SQL query w/ subselect in join -> bad paren injection

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

SQL query w/ subselect in join -> bad paren injection

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

Nels_P_Olsen

Post subject: SQL query w/ subselect in join -> bad paren injection

Posted: Fri Sep 07, 2007 12:11 pm

Expert

Joined: Fri Oct 28, 2005 5:38 pm
Posts: 390
Location: Cedarburg, WI

I am trying to run a SQL query with a subselect in a JOIN. NHibernate decides it wants to put parentheses around the main WHERE clause, but it gets mixed up. It puts the open parenthesis after the first where clause it finds, which is not the main WHERE clause. It then puts a closing parenthesis at the end of the statement. The parentheses don't match up correctly and the SQL statement fails ...

Anyone else seen this?

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » NHibernate 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