Seems to be a mapping problem, could you send your mapping file ? Yasuhiko Yoshikawa(Sakakibara) wrote:
Hi, I am new to castor JDO and found it wonderful.
However, when I try it out, I encountered a problem that the JDO creates
incorrect SQL statement:(line breaks and spaces are inserted for
readability)
SELECT
a2.city,
a2.companyName,
a2.customerId,
customer.objectId,
customer_f4.objectId,
a2.faxNumber,
a2.name,
a2.namePhonetic,
a2.postalCode,
a2.stateProvince,
a2.street,
a2.suite,
a2.telephoneNumber,
a2.timeCreated,
a2.timeUpdated
FROM address a1 LEFT OUTER JOIN customer ON
(a1.objectId=customer.primaryAddress),
address a2 LEFT OUTER JOIN customer_f4 ON
(a2.objectId=customer_f4.shippingAddress) WHERE
a2.objectId=a1.objectId AND a2.objectId=1
When there is no customer_f4 table. My OQL is a very simple one
select c from sakura.data.user.Customer c
When the JDO starts up the message on the Standard Out reads [test] SQL for loading sakura.data.user.Customer: SELECT customer.emailAddress,
customer.password,
customer.primaryAddress,
customer .shippingAddress,
shoppingcart.objectId,
customer.timeCreated,
customer.timeUpdated
FROM customer LEFT OUTER JOIN shoppingcart ON (customer.objectId=shoppingcart.customer) WHERE customer.objectId=?
Does anyone know what is causing the JDO to think there is customer_f4
table?
I tried with both 0.9.3.21 and 0.9.4 and my database is HyperSonicDB.
I would appreciate any input.
------------------------
Yasuhiko YOSHIKAWA
[EMAIL PROTECTED]
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
--
Mickael Guessant
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
