Hibernate Community • View topic - String concatination

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

String concatination

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

gstamp

Post subject: String concatination

Posted: Thu Jun 10, 2004 3:11 am

Regular

Joined: Thu Nov 20, 2003 10:04 pm
Posts: 64
Location: Melbourne, Australia

This this valid HQL:

Code:

select distinct u from User u left join u.userGroups ug where (u.firstName || u.lastname) like :partial and (u.primaryGroup.groupId = :groupId or ug.group = :groupId)

The documentation says you can use || for concatination but sql server seems to barf:

Code:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near '|'.

-- Glen

Top

Brannor McThife

Post subject:

Posted: Thu Jun 10, 2004 11:28 am

Senior

Joined: Tue Sep 23, 2003 8:18 am
Posts: 137
Location: Johannesburg, South Africa

I'm guessing that this is more of an SQL 2000 issue. SQL2000 uses the normal + to concatenate text.

e.g.:

Code:

select top 1 customer.firstname + ' ' + customer.lastname
from customer

Try that, and see what you get.

-G

Top

Page 1 of 1

[ 2 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