« Return to Thread: SQL module using JNDI resource

SQL module using JNDI resource

by Danny Kruitbosch :: Rate this Message:

Reply to Author | View in Thread

Hi,

We're currently in a project in which we're going to use exist and  
xquery to aggregate data from several sources like external web  
services, data stored in exist and data stored in RDBMS-es.

We're using the httpclient module to call the external web services  
and are going to use the sqlmodule for getting the data from the  
RDBMS-es.

eXist will be run from within tomcat or jetty.
For the SQL connections, it would be nice if I was able to reference a  
jndi resource that is managed by tomcat/jetty. This way tomcat/jetty  
will be responsible for maintaining and cleaning up the connections to  
the databases and it will result in a more scalable solution as  
compared to opening and closing a connection for each query that is run.

Since I'm no programmer, I would like to know if someone has done this  
already or what needs to be changed/added to the sql module to  
implement this.

Any feedback on this idea will be much appreciated.


Kind regard,

Danny

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Exist-open mailing list
Exist-open@...
https://lists.sourceforge.net/lists/listinfo/exist-open

 « Return to Thread: SQL module using JNDI resource

LightInTheBox - Buy quality products at wholesale price