Hi Karam,
Yes, it's probably a good idea. :)
Unfortunately I'm not an expert in this area. Since you're using
GlassFish, which is a Java EE 5 container... you have access to EJB 3.
It's annotations make it easy to use. There are a number of other
approaches people take. I'm curious to know what you decide to do...
but I'm not the best person to tell you what approach is best. Others
on this list are likely to have more experience than me.
If you don't get an answer, post a question on the JSF forum, or do some
Google searches to see what people recommend.
Ken
Karam Singh Badesha wrote:
> Hi,
> I have setup a jdbc resource in the appserver for oracle. Now I want
> to use this from the handlers. Currently each function in my handler
> connects to the database and then execute the query. But I am
> wondering if there is a way to avoid this reconnection for every
> handler call?
>
> thanks
> Karam