Custom sql code

[Roberto Cosenza-5]

Hi.
Could you please give me a pointer in how to customize the generated  
sql code?
I'm for instance using a "performFind" service call which generates  
some sql which is not valid for my database (in this specific case it  
uses "UPPER" to convert the search string into uppercase)
Regards
/Roberto

[Adrian Crum]

It would be preferable to do some research to find out why your database
doesn't support the SQL UPPER function.

OFBiz generates generic ANSI SQL, so usually if you run into problems
it's because the database or the JDBC driver is not compliant.

-Adrian

Roberto Cosenza wrote:
> Hi.
> Could you please give me a pointer in how to customize the generated sql
> code?
> I'm for instance using a "performFind" service call which generates some
> sql which is not valid for my database (in this specific case it uses
> "UPPER" to convert the search string into uppercase)
> Regards
> /Roberto
>

[Roberto Cosenza-5]

Well...it just doesn't!
Altough I could speculate on why it doesn't, it will not help me. It  
would be easier to instruct ofbiz not to use upper.
Or maybe the correct approach is not to use the "performFind" (which  
would make my work harder...) ?
Thanks for any suggestions
/r

On Mar 13, 2008, at 3:57 PM, Adrian Crum wrote:

> It would be preferable to do some research to find out why your  
> database doesn't support the SQL UPPER function.
>
> OFBiz generates generic ANSI SQL, so usually if you run into  
> problems it's because the database or the JDBC driver is not  
> compliant.
>
> -Adrian
>
> Roberto Cosenza wrote:
>> Hi.
>> Could you please give me a pointer in how to customize the  
>> generated sql code?
>> I'm for instance using a "performFind" service call which generates  
>> some sql which is not valid for my database (in this specific case  
>> it uses "UPPER" to convert the search string into uppercase)
>> Regards
>> /Roberto

[Jacques Le Roux]

Which database are you using ?

Jacques

From: "Roberto Cosenza" <[hidden email]>

> Well...it just doesn't!
> Altough I could speculate on why it doesn't, it will not help me. It  
> would be easier to instruct ofbiz not to use upper.
> Or maybe the correct approach is not to use the "performFind" (which  
> would make my work harder...) ?
> Thanks for any suggestions
> /r
>
> On Mar 13, 2008, at 3:57 PM, Adrian Crum wrote:
>
>> It would be preferable to do some research to find out why your  
>> database doesn't support the SQL UPPER function.
>>
>> OFBiz generates generic ANSI SQL, so usually if you run into  
>> problems it's because the database or the JDBC driver is not  
>> compliant.
>>
>> -Adrian
>>
>> Roberto Cosenza wrote:
>>> Hi.
>>> Could you please give me a pointer in how to customize the  
>>> generated sql code?
>>> I'm for instance using a "performFind" service call which generates  
>>> some sql which is not valid for my database (in this specific case  
>>> it uses "UPPER" to convert the search string into uppercase)
>>> Regards
>>> /Roberto
>