Solution to convert Quarter expression as param value before execute EJB2 query

Solution Verified - Updated -

Issue

  • In a query a date search criteria includes quater information like '2010q3'.
    With the help from DBA, we realized that the view,  which app queries from, requires a date format to be set correctly in the session level. When we use jdbc, we can easily use "alter session  set nls_date_format='YYYYMMDD'", but now because we are using entity bean, we want to know how we can achieve it in JBoss when using EJB2 CMP Entity beans?

Environment

  • JBoss Enterprise Application Platform (EAP) 4.x

  • JBoss Enterprise Application Platform (EAP) 5.1.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content