How can I execute complex SQL -Queries like joins involving multiple tables using OfBiz delegator?

[rams-2]

Hi,
I want to use OfBiz delegator to execute complex queries.
It seems OfBiz entity framework is having some limitations when it comes to
executing complex data base queries?
Is there any way I can execute a stored procedure using OfBiz delegator?
Pls let me know how to execute joins ?
Thanks and Regards
Ram



This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient or received it in error, please contact the sender by reply e-mail and destroy all copies of the original message. Please do not copy it for any purpose or disclose its contents.

Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved

[BJ Freeman]

http://incubator.apache.org/ofbiz/docs/entity.html
look down the page for entity view.


rams sent the following on 4/19/2004 10:06 AM:

> Hi,
> I want to use OfBiz delegator to execute complex queries.
> It seems OfBiz entity framework is having some limitations when it comes to
> executing complex data base queries?
> Is there any way I can execute a stored procedure using OfBiz delegator?
> Pls let me know how to execute joins ?
> Thanks and Regards
> Ram
>
>
>
> This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient or received it in error, please contact the sender by reply e-mail and destroy all copies of the original message. Please do not copy it for any purpose or disclose its contents.
>
> Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved

[BJ Freeman]

as far as stored procedure, not directly.
however a trick I use is when data is updated in the sQL Database, a
trigger activated the Stored procedure, to create a new table.
i then create a entity for the new table and a view of the new table.


BJ Freeman sent the following on 7/19/2006 5:37 AM:

> http://incubator.apache.org/ofbiz/docs/entity.html
> look down the page for entity view.
>
>
> rams sent the following on 4/19/2004 10:06 AM:
>> Hi,
>> I want to use OfBiz delegator to execute complex queries.
>> It seems OfBiz entity framework is having some limitations when it
>> comes to executing complex data base queries?
>> Is there any way I can execute a stored procedure using OfBiz delegator?
>> Pls let me know how to execute joins ?
>> Thanks and Regards
>> Ram
>>
>>
>>
>> This e-mail and any files transmitted with it are for the sole use of
>> the intended recipient(s) and may contain confidential and privileged
>> information. If you are not the intended recipient or received it in
>> error, please contact the sender by reply e-mail and destroy all
>> copies of the original message. Please do not copy it for any purpose
>> or disclose its contents.
>>
>> Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights
>> Reserved
>

[David E Jones-2]

Just use JDBC. You can get a Connection through the ConnectionFactory using the Entity Engine settings to share in the context.

-David


rams wrote:

> Hi,
> I want to use OfBiz delegator to execute complex queries.
> It seems OfBiz entity framework is having some limitations when it comes to
> executing complex data base queries?
> Is there any way I can execute a stored procedure using OfBiz delegator?
> Pls let me know how to execute joins ?
> Thanks and Regards
> Ram
>
>
>
> This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient or received it in error, please contact the sender by reply e-mail and destroy all copies of the original message. Please do not copy it for any purpose or disclose its contents.
>
> Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved

[Jacques Le Roux]

Hi Rams,

I use date to sort incoming email and your machine have a peculiar one isn't ?
;o)

Jacques

----- Original Message -----
From: "rams" <[hidden email]>
To: <[hidden email]>
Sent: Monday, April 19, 2004 7:06 PM
Subject: How can I execute complex SQL -Queries like joins involving multiple
tables using OfBiz delegator?

> Hi,
> I want to use OfBiz delegator to execute complex queries.
> It seems OfBiz entity framework is having some limitations when it comes to
> executing complex data base queries?
> Is there any way I can execute a stored procedure using OfBiz delegator?
> Pls let me know how to execute joins ?
> Thanks and Regards
> Ram
>
>
>
> This e-mail and any files transmitted with it are for the sole use of the

intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient or received it in error, please contact
the sender by reply e-mail and destroy all copies of the original message.
Please do not copy it for any purpose or disclose its contents.
>
> Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved