Websphere, DB2, EJB and case insensitive queries 
Author Message
 Websphere, DB2, EJB and case insensitive queries

Hi, I have developed a CMP entity bean which saves to a DB2 database.  I
have several find methods defined in the home interface, trouble is they
are case sensitive.  I have tried changing the where clause in my finder
helper class to something like:

public final static String findByPersonWhereClause = "upper(T1.lastname
) LIKE upper(?) AND T1.status = ?";

...but I get some CORBA transaction rolled back exception.  I have tried
typing the SQL directly into IBM's DB2 console and it works fine, but
not when I do it from the bean.  Any ideas what I'm doing wrong, or
better yet, is there a better way to do this (without just storing all
the data in DB2 as in upper case).

Thanks,
Andy

Sent via Deja.com http://www.***.com/
Before you buy.



Sat, 11 Jan 2003 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Case sensitvie query on case insensitive database.

2. How to make DB2 V8.1 case insensitive

3. Collation to Accent Insensitive and Case Insensitive

4. How do I make queries case insensitive?

5. Case insensitive querying

6. How to make SQL query case insensitive?

7. Case insensitive SQL query

8. EJB, Java Beans, WebSphere, Weblogic, C++/CORBA, Java/CORBA.-F/T and Contract

9. How to make InterBAse query case insensitive?

10. How to perform a case-insensitive query?

11. Case-insensitive queries

12. Case Insensitive Query


 
Powered by phpBB® Forum Software