Hello Oleg,
I guess now I understand the problem, I'll try to fix it tonight.
Oleg
Oleg V Alexeev wrote:
> Hello Oleg,
> Thursday, August 09, 2001, 1:05:47 AM, you wrote:
ON>> Hello Oleg,
ON>> Can you turn the Castor log on and send the full SQL query that is generated?
> Yes - result is here -
> SELECT dm.cat_lang.cont_id,dm.cat_lang.lang_id,dm.cat_lang.cont_id,dm.cat_l
> ang.cat_name,dm.cat_lang.cat_descr FROM dm.cat_lang,dm.cat dm.cat_0 WHERE dm.cat
> _lang.cont_id=dm.cat_0.cont_id AND (not dm.cat_0.parent_id IS NOT NULL and dm.c
> at_lang.lang_id = ?)
> result -
> COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/2] SQL0104N An
> unexpected token "." was found following "m.cat_lan
> g,dm.cat dm". Expected tokens may include: ",". SQLSTATE=42601
> I try to query database with generated SQL - result is same...
> I think that error is in generated SQL - DB2 can not use table aliases
> in FROM section with dot sign - 'dm.cat_0', for example...
ON>> Oleg
ON>> On Wednesday 08 August 2001 12:05, Oleg V Alexeev wrote:
>>> Hello Low,
>>>
>>> Wednesday, August 08, 2001, 12:40:28 PM, you wrote:
>>>
>>> LHS> Have u try this
>>>
>>> LHS> select c from com.id.dm.dbeans.CategoryLang c where is_undefined(
>>> LHS> c.boss.parent )
>>>
>>> Yes, of course. Castor parse it and pass to the DB2. And DB2 raise
>>> error -
>>>
>>> COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/2] SQL0104N An
>>> unexpected token "." was found following "m.cat_lang,dm.cat dm".
>>> Expected tokens may include: ",". SQLSTATE=42601
>>>
>>> LHS> -----Original Message-----
>>> LHS> From: Oleg V Alexeev [mailto:[EMAIL PROTECTED]]
>>> LHS> Sent: Wednesday, August 08, 2001 4:27
>>> LHS> To: [EMAIL PROTECTED]
>>> LHS> Subject: [castor-dev] Complex query
>>>
>>>
>>> LHS> Hello castor-dev,
>>>
>>> LHS> How can I write a query with complex predicate in WHERE section of
>>> LHS> OQL? For example - I try to query database with such OQL as -
>>>
>>> LHS> select c from com.id.dm.dbeans.CategoryLang l where is_defined(
>>> LHS> c.boss.parent )
>>>
>>> LHS> com.id.dm.dbeans.CategoryLang class has getBoss() method and section
>>> LHS> in mapping.xml -
>>>
>>> LHS> <field name="boss" type="com.id.dm.dbeans.Category" require="true">
>>> LHS> <sql name="cont_id"/>
>>> LHS> </field>
>>>
>>> LHS> com.id.dm.dbeans.Category has getParent() method.
>>>
>>> LHS> How can I query such com.id.dm.dbeans.CategoryLang objects as for
>>> LHS> that objects getBoss().getParent() returns null?
ON>> -----------------------------------------------------------
ON>> If you wish to unsubscribe from this mailing, send mail to
ON>> [EMAIL PROTECTED] with a subject of:
ON>> unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
