-------- Original Message -------- Subject: Fw: Can anyone help me with this Join question? Date: Thu, 29 Jan 2004 08:43:49 -0800 From: Jay Xu <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>
Tom,
I saw your posting quite frequently on the board. So maybe you can help me on this or send me to the right person. I am struggling with creating Join in OJB. I followed turtorial exatly, but no luck. One of my co-work tried in RC2, he told me it worked in RC2, but not in RC4 and RC5. (Please see attached email)
Please help. Thanks
>
>
> -----Original Message-----
> From: Jay Xu [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 28, 2004 5:33 PM
> To: OJB Users List
> Subject: Can anyone help me with this Join question?
>
>
>
> I am using OJB to do a simple 1:1 mapping and would like to create a Join
> between these two tables. The OJB works and I got all database fields I
> want. But instead of creating a Join, OJB creates TWO SQL statement. From
> P6Spy,
>
> 1075339115137|571|0|statement|SELECT
>
A0.MSVBY,A0.MSDBY,A0.MSTIME,A0.MSDTIME,A0.MSCHTM,A0.MSPACCT#,A0.MSTO,A0.MSVT
>
IME,A0.MSTEXT,A0.MSRSTS,A0.MSFROM,A0.MSFLAG,A0.MSSTS,A0.MSPREL,A0.MSCHDT,A0.
> MSDATE,A0.MSID,A0.MSDDATE,A0.MSCHBY,A0.MSVDATE,A0.MSPUREF,A0.MSTYPE FROM
> JMPIBMS2 A0|SELECT
>
A0.MSVBY,A0.MSDBY,A0.MSTIME,A0.MSDTIME,A0.MSCHTM,A0.MSPACCT#,A0.MSTO,A0.MSVT
>
IME,A0.MSTEXT,A0.MSRSTS,A0.MSFROM,A0.MSFLAG,A0.MSSTS,A0.MSPREL,A0.MSCHDT,A0.
> MSDATE,A0.MSID,A0.MSDDATE,A0.MSCHBY,A0.MSVDATE,A0.MSPUREF,A0.MSTYPE FROM
> JMPIBMS2 A0
>
> And
>
> 1075339117740|460|0|statement|SELECT
> A0.USEX,A0.UREF#,A0.UBRMM,A0.UBRCY,A0.UBRDD FROM PHPUNIT A0 WHERE
A0.UREF#
> IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ?
,
> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
,
> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
,
> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
,
> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
,
> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
,
> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
,
> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
,
> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
,
> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
,
> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )|SELECT
> A0.USEX,A0.UREF#,A0.UBRMM,A0.UBRCY,A0.UBRDD FROM PHPUNIT A0 WHERE
A0.UREF#
> IN ( '2197' , '2196' , '2 ....
>
> This actually created 1+n SQL statements on the server.
>
> I followed the turtorial and did exactly what the turtorial said. But
still
> no Join created by OJB. Could anyone please help me on this? We are
in the
> process to decide if we would use OJB in our project.
>
> Thanks
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
>
>
--------------------------------------------------------------------------
-----
> This message and any included attachments are from Siemens Medical
Solutions
> USA, Inc. and are intended only for the addressee(s).
> The information contained herein may include trade secrets or privileged
or
> otherwise confidential information. Unauthorized review, forwarding,
printing,
> copying, distributing, or using such information is strictly prohibited
and may
> be unlawful. If you received this message in error, or have reason to
believe
> you are not authorized to receive it, please promptly delete this message
and
> notify the sender by e-mail with a copy to
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
>
> Thank you
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
