Hibernate Community • View topic - Non-portable HQL with LIKE clause

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Non-portable HQL with LIKE clause

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

peterjust

Post subject: Non-portable HQL with LIKE clause

Posted: Thu Aug 17, 2006 11:49 am

Newbie

Joined: Thu Aug 17, 2006 11:30 am
Posts: 1

I want to escape characters used in a LIKE clause of my HQL query with a backslash but I have a problem.
MS SQL Server requires ESCAPE '\' but MySQL does not understand ESCAPE.
Both JDBC drivers accept { escape '\' }, but it looks like hibernate does not use jdbc escaping for the LIKE clause.
So I cannot write portable HQL for both MS SQL Server and MySQL.

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