JDBC Adapter support for Outer Join

Guest · July 31, 2003, 1:13am

Does anyone know if the JDBC Adpater supports Outer Joins using the SelectSQL template or do I have to use the CustomSQL template?

Using WM 6.0, Oracle 9i on Sun Solaris 9.

Thanks.

-Scott

Guest · August 1, 2003, 8:27pm

No worries on this one. I used the CustomSQL template and built the outer join by hand. A total pain (since I had to do it all three times to hit three different instances of the same database) but it works.

That’s it.

-Scott

Guest · October 16, 2003, 5:03pm

Hi Scott,
Have you find any other way to Outer Join in SelectSQl Service or just hard coding it. It will be greatful if you help me out.
Thanks and Regards,
Raghu

Marcus_Fuchs · March 7, 2018, 11:23am

Hi Scott and Raghu,
even 15 years later I haven’t found another way neither - apart from CustomSQL templates. Too bad.

Best regards,
Marcus

Rakesh_Kumar3 · March 7, 2018, 11:37am

For Oracle JDBC connections , we used “(+)” operator in the where condition of the select adapter template for Outer joins

Marcus_Fuchs · March 7, 2018, 1:12pm

Hi Rakesh,
thank you for this hint! Good to know that this workaround works - even though several restrictions apply to Oracle’s (+) operator, but most of them apply to webMethods’ SelectSQL template anyway.

Best regards,
Marcus