Solution to convert Quarter expression as param value before execute EJB2 query
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.