On the same subject I am having issues grabbing a single record. Here is my transfer.xml file
<?xml version="1.0" encoding="UTF-8"?> <transfer xsi:noNamespaceSchemaLocation="../transfer/xsd/transfer.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <objectDefinitions> <object name="device" decorator="quickconnects.model.device"> <id name="DeviceId" type="numeric" generate="true"/> <property name="device" type="string"/> <manytoone name="Manufacturer"> <link to="manufacturer" column="manufacturerId"/> </manytoone> <property name="active" type="numeric"/> </object> <object name="manufacturer" decorator="quickconnects.model.manufacturer"> <id name="manufacturerId" type="numeric" generate="true"/> <property name="manufacturer" type="string"/> </object> <object name="users" decorator="quickconnects.model.user"> <id name="userId" type="numeric" generate="true"/> <property name="firstname" type="string"/> <property name="lastname" type="string"/> <property name="username" type="string"/> <property name="password" type="string"/> <property name="email" type="string"/> <property name="active" type="numeric"/> </object> </objectDefinitions> </transfer> If I just write out the sql it seems to work ok. select d.DEVICE,m.MANUFACTURER FROM DEVICE d LEFT OUTER JOIN MANUFACTURER m ON m.MANUFACTURERID = d.MANUFACTURERID ORDER BY DEVICEID Here is the generated sql though and I am confused on why it grabs the manufacturer as null. Generated SQL SELECT NULL as manufacturer, NULL as manufacturerId, device_1.active, device_1.deviceTypeId, device_1.quickConnectId, device_1.seriesId, device_1.device, device_1.DeviceId, NULL as transfer_parentKey, 1 as transfer_orderIndex,'device' as transfer_className,'' as transfer_parentClassName,'' as transfer_parentParentClassName,'' as transfer_parentCompositeName,'false' as transfer_isArray,'' as transfer_compositeName, 'false' as transfer_isProxied FROM device device_1 WHERE device_1.DeviceId = (param 1) AND device_1.DeviceId IS NOT NULL UNION ALL SELECT manufacturer_2.manufacturer, manufacturer_2.manufacturerId, NULL as active, NULL as deviceTypeId, NULL as quickConnectId, NULL as seriesId, NULL as device, NULL as DeviceId, CAST(device_1.DeviceId as varchar2(1000)) as transfer_parentKey, 2 as transfer_orderIndex,'manufacturer' as transfer_className,'device' as transfer_parentClassName,'' as transfer_parentParentClassName,'' as transfer_parentCompositeName,'false' as transfer_isArray,'Manufacturer' as transfer_compositeName, 'false' as transfer_isProxied FROM device device_1, manufacturer manufacturer_2 where device_1.DeviceId = manufacturer_2.manufacturerId (+) WHERE device_1.DeviceId = (param 2) AND manufacturer_2.manufacturerId IS NOT NULL ORDER BY transfer_orderIndex ASC Error Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---