openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rade Martinović <>
Subject openjpa-kernel : using PostgreSQL's inet operators in JPQL
Date Tue, 06 Nov 2012 15:53:50 GMT
Hello all.

For past few days am I investigating the possibility of using postgres' inet datatype in JPQL

Of course, I can use NativeQuery, but I would like to refrain from using it if not absolutely

I've created InetFieldStrategy which extends StringFieldStrategy and I've mapped it as default
for all IPAddresses in my model. Loading, merging and persisting inets work fine. (of course,
it would be nice if only there was some example how to create strategies, I've had some rough

Now I would like to use inet operators to query database. All standard JPQL operators (such
as <, >, <=, >=, <>, =) work fine. I guess that this is due to fact that
OpenJPA now treats inet fields internally as Strings. 

But I would like also to use <<, >> (contains subnet, subnet contains) operators.
JPQL parser complains that it does not recognize literals "<<" or ">>". 

Do I need to patch openjpa and extend JPQL.jjt and Is there another

Thank you for your answer.
Rade Martinović, M.Sc.E.E
Software architect

Belgrade University Computer Center
Kumanovska 7, 126119 Beograd

Tel:            +381-11-3031258
Fax:            +381-11-3031259
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message