This discussion is archived
3 Replies Latest reply: Oct 11, 2012 6:43 PM by Davin Fifield RSS

Connecting Database

Rajan.Panchal Newbie
Currently Being Moderated
Hi,
I am using OPA 10.2 and I want to connect to database to fetch values into dropdown. I have implemented ListProviderPlugin in java for the same. However, the implementation of ListProviderPlugin interface makes connection to database for each and every dropdown. This results into exhaustion of connection pool and is not able to get connection.

Is there any way to get the connection only once and use the object through out the application? Can we create objects on application level?
I should be able to use this connection object in other event handlers also.

Thanks,
Rajan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points