Oracle to Sdf join does not work

[bscott]

Joining an sdf to an oracle feature class does not work. There is a nabble thread that discuss the issue ​http://n2.nabble.com/Joining-Oracle---SDF-defect-%3A-Possible-fix-to-validate-td3273905.html#a3273905

I need a GWS expert to validate that small patch

Bruno Scott

[brucedechant]

I tested Oracle (Primary) joined to SDF (secondary) using a single join key that was a string property and it worked. This was a Left-Outer 1-Many join.

Can you clarify if you are using a composite key for the join? What is the data type of the join property? Also, what type of join are you doing - Inner/Outer, 1-1, 1-Many?

A specific test case that shows this failing would be helpful as the test cases I have are passing.

[bscott]

I have attached a small zip file that contains everything to reproduce. In the zip, there is an ORACLE folder that has SQL script to create and load the table in oracle. You will have to modify the LoadData.bat file to set the proper ORABIN et LOGIN parameters. There is also an SDF folder that contains the sdf. To reproduce

Create the SDF connection to the COMMUNE.sdf Create the Oracle Connection On the Oracle connection add a join to the SDF

Left Column : INSEE Right Column : INSEE_COMMUNE Type of join: Keep only left-side records Relationship : One-to-One

In the zip there is also a SHP version of the Oracle table. If you try the same join using the SHP table instead of the Oracle one, it works.

Bruno

[brucedechant]

Thanks Bruno - I can replicate your issue now.

I have further optimized your patch by removing some unneeded code.

Could you please rerun your performance test to see if it improves your initial timings once I submit the update?

[brucedechant]

sandbox/adsk/2.1 r4078
branches/2.1 r4079
trunk r4080