I have some ticket numbers that may have numbers and letters mixed. I'll be passing in the ticketNumberIds into this method (user input) and I want it to query against the Oracle database and have the query pick up tickets that differ by upper and lower cases.

How do I make the following a case-insensitive query?

public List<TicketDO> getTicketDOsById(final List<String> ticketNumberIds) {

    String myQuery = "from TicketDO t where t.ticketNumberId in (:ticketNumberIds)";

    return getEntityManager().createQuery(myQuery).setParameter("ticketNumberIds", ticketNumberIds)
    .getResultList();

}
Edit
Report