Where did the (+) come from? Mark
On Fri, Jul 3, 2009 at 2:35 AM, Dan Vega <[email protected]> wrote: > > 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 > > > -- E: [email protected] T: http://www.twitter.com/neurotic W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
