You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Roberto Cosenza <ro...@infoflexconnect.se> on 2008/03/13 14:39:12 UTC
Custom sql code
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
Re: Custom sql code
Posted by Jacques Le Roux <ja...@les7arts.com>.
Which database are you using ?
Jacques
From: "Roberto Cosenza" <ro...@infoflexconnect.se>
> 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
>
Re: Custom sql code
Posted by Roberto Cosenza <ro...@infoflexconnect.se>.
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
Re: Custom sql code
Posted by Adrian Crum <ad...@hlmksw.com>.
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
>