Eclipse Community Forums: EclipseLink » JPQL Question

Help

Home

Home » Eclipse Projects » EclipseLink » JPQL Question - empty string

Show: Today's Messages :: Show Polls :: Message Navigator

JPQL Question - empty string [message #1066318]

Tue, 02 July 2013 07:28

Reiner Lott

Messages: 7
Registered: April 2013

Junior Member

Hi,

in my SQL Client i used the following statement:

select * from mytable where value = ''

--> returns resultset

====================================

the JPQL pendant would be:

select m from entityname m where m.value = ''

--> returns nothing

====================================

but this works:

select m from entityname m where m.value = ' '

is this a bug?

Cheers
Reiner

Report message to a moderator

Re: JPQL Question - empty string [message #1066640 is a reply to message #1066318]

Wed, 03 July 2013 14:20

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

My guess is your JDBC driver is doing some odd translation of the SQL. You can enable logging to see the SQL that EclipseLink generates.
EclipseLink does not do anything special with '' or ' '.

Also try using a parameter instead of inlining the string.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	Nulling an embedded object does not affect the database upon merge
Next Topic:	Eclipse link DBWS -Connection is null

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:11:14 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter