Is it platform independant if I use upper() and like '%'?

[ZZZ Liu <z2...@yahoo.com>]

Hi All,

I am using ojb as the persistence layer and assume
that I don't need to re-write my code if I need to
switch to a different database. However, if I use 

Criteria crit = new Criteria();
crit.addEqualTo("upper(firstname)", "TOM");
crit.addLike("firstname", "T%");

Is it still platform independant?

Thanks in advance for you reply.

Zhe


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Re: Is it platform independant if I use upper() and like '%'?

[Jakob Braeuchi <jb...@gmx.ch>]

hi zhe,

upper is not platform independent. i'm not sure about the '%' most dbms accept 
it but ms-access uses '*' .

jakob

ZZZ Liu wrote:

> Hi All,
> 
> I am using ojb as the persistence layer and assume
> that I don't need to re-write my code if I need to
> switch to a different database. However, if I use 
> 
> Criteria crit = new Criteria();
> crit.addEqualTo("upper(firstname)", "TOM");
> crit.addLike("firstname", "T%");
> 
> Is it still platform independant?
> 
> Thanks in advance for you reply.
> 
> Zhe
> 
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> http://taxes.yahoo.com/filing.html
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org