Mapping ServiceLookup: Issuess with < condition

[Former Member]

All,

I have implemented a user-defined java function that does a db lookup utilising the LookupService API.

We are on SP 16.

My function works perfectly. So all communication channels, db drivers ets has been configured correctly.

When I noticed that my SQL condition in the program was incorrect I updated it from a '>=' to a '<=' sign, I get an exception.

So when my sql statement is:

- select orgNum from a where orgDate >= sysDate()

my function works, but when I change it to:

- select orgNum from a where orgDate <= sysDate()

I get an exception. This is what is reported in the adapter monitor:

- 2006-08-08 16:58:58 GMT+11:00: Error: TransformException error in xml processor class: ERROR occured parsing request:com.sap.engine.lib.xml.parser.NestedSAXParserException: Fatal Error: com.sap.engine.lib.xml.parser.ParserException: Name expected: 0x3d(:main:, row:1, col:336)(:main:, row=1, col=336) -> com.sap.engine.lib.xml.parser.ParserException: Name expected: 0x3d(:main:, row:1, col:336)

Has anyone else come across this issue?

Any help would be greatly appreciated.

Regards

Yackeen Mallum

[udo_martens]

Hi Yackeen,

the (SQL) operator '<=' is missinterpreted by the XML parser. Try to put '&lt;' instead of '<' or try to put 'le' instead of '<='. Try as well with space: '< ='. Check, which SQL operator is allowed. Or construct with select...where..> sysDate() OR ..=sysDate()

Regards,

Udo