Here's a part of a SQL statement being generated by OpenJPA using Oracle
database:
... WHERE (t0.ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR t0.ID IN
() OR t0.ID IN () OR t0.ID IN () OR t0.ID IN ())
ORDER BY t0.ID ASC
Can you provide some more context? What is the JPQL that is being executed?
What version of OpenJPA are you running?
Thanks,
Rick
On Mon, Apr 16, 2012 at 8:39 AM, mwalter marc.wal...@sbb.ch wrote:
Here's a part of a SQL statement being generated by OpenJPA using Oracle
database:
... WHERE
We're using OpenJPA 1.2.3.
The JPQL query is generated by Querydsl and looks like that:
select exportOrder from ExportOrder exportOrder left join
exportOrder.exportConfiguration as exportConfiguration where exportOrder.fp
= :a1 order by exportOrder.exportDate desc
After this JPQL is executed
Hi folks,
I'm wondering whether there is any non-native support for MySQL spatial in
OpenJPA?
It would be sufficient to have a perimeter search in Criteria API, e.g. based
on lon/lan stored as decimals.
Best regards thx for any suggestions.
Hi Daniel,
There is no direct support for the MySQL spatial extensions in OpenJPA.
You could maybe model the support by wrappering the constructs in an
embeddable, but that may not give you the full support you are looking
for. You could always help develop this support in OpenJPA and contribute
Hello Kevin,
thanks for the @Embeddable annotation. However, I reviewed MySQL status and
it seems their spatial extension does not yet support a distance()
function. It looks like I have to contribute there, before contributing
here - because especially the distance function would be something I
Good evening, Kevin,
thanks for you explanations - I will investigate Object-to-XML mapping a
bit to gain further insights.
When you say JPQL and Criteria API are specified by JPA - does it mean that
JPA API already ships with lexing, tokenizer, etc.- and by that hard to
modify?
I'd more expect