Creating A Datasource

[kvarnerexpress 0]

This is a little confusing for me but:In my current configuration everytime I want to run a query on my db I create a new datasource. Should I be creating a new datasource every time that I wish to launch a query, or do I just create one (put it into the application scope) and have everyone use it? Would that cause problems with multiple users attempting to launch queries?Can someone explain the datasource a little better for me.kvarnerexpress

[patelg 0]

Using what technology are you trying to achieve this?It is always good to agve some conecctions available and then keep using them rather then coneccting and disconnecting for each and every query. It will be expensive to do that.If it is possible to use datasource then you should use that approach....but it also depends how you implements this...