No String Function opf JPQL working in Web Service

[Former Member]

Hello Friends ,

I am trying to use String functions of JPQLin one of my session bean which I am later exposing as web service , but the problem is that whenever I am using any of the String functions like Lehgth, Upper of locate I am getting the same error

The generated SQL statement is not valid for the underlying database platform (platform no. 99)

please help me to get rid of this error as soon as possible

Thanks a lot

[adrian_goerler · Accepted solution]

Hi Smriti,

this works as designed.

You are using Open SQL for Java. Open SQL for Java rejects constructs which don't execute with equal semantics on all supported data. The restrictions are documented [here|http://help.sap.com/saphelp_nwce10/helpdata/en/45/c8baeb5f0c2e97e10000000a155369/frameset.htm]:

-Adrian

[Former Member · Accepted solution]

Thanks a lot Adrian , I never even thought of it that this might have been a design issue