Hi,
I'm sorry, I looked at the log file that I attached and realized that it has
gotten truncated due to some character in between (I copy pasted it from
eclipse console). Here is the entire log file on a different run.
Pinaki, your observation is correct but the thing is the very reason that
t
In Section 2.7.4.1. JPQL Aggregate Examples of the latest OpenJPA manual
http://openjpa.apache.org/docs/latest/manual.html
has this example query
SELECT SUM(mag.price) FROM Publisher pub JOIN pub.magazines mag
pub.firstName = 'Larry'
Shouldn't there be a WHERE token between mag and pub.firstN
Hi,
Thanks, I really appreciate you took time to answer such a "general"
question!
I try to persist a graph in database and I found your link, Pinaki, really
interesting. My concern is a little bit different as my "main entity" is the
Node (a Node is potentially connected to other Node(s), but n
Hello, Milosz.
> Have you compared the actual SQL statements being issued by PostgreSQL
and MySQL versions?
I switched to traditional join syntax and performance is better.
SQL statements are very similar compared to SQL and JPA implementations
excepts number of fields which are selected and
Georgi,
Have you compared the actual SQL statements being issued by PostgreSQL and
MySQL versions? If I remember correctly, setting the
autoGenerateTestcaseScript=true Connector/J property will show you all the
statements including the implicit ones coming from the driver/transaction
manager.
> Can someone please confirm that Inheritance JOINED works?
Yes.
Many of the insert statements for CREDITOR in the log shows PBS_NO 668.0. No
wonder DB2 is complaining about SQL ERROR 23505 which is violation of
database unique constraint as PBS_NO happens to be the primary key.
What are the pe
