datasource for multiple database

[akshay pandit]

hi ,

hello to all.. I'm facing a problem I have three different database and webapplications on posgres 7.3 and have single posgres-ds.xml, Posgres-ds.xml needs to be in server-->default-->deploy directory.. I've kept it there only.. Whether I can keep single posgres-ds.xml for all the three webapplications ? If yes then how should I configure ? and if no then what can be the alternate solution as all the three webapplications need to access the posgres itself.. I'm stuck pls help me . A sample posgres-ds.xml and code snippet would be a gr8 help..

thanks in advance

Regards
Akshay

[akshay pandit]

I'm using Jboss 3.2.3

[Jeff Shelley]

Hi! you should only need one, assuming they are all using the same database. the -ds.xml file will set up a connection pool that you will be able to use from your application.

in docs/examples/jca, there's a postgres-ds.xml that you should be able to change and put in the deploy directory to set up the pool.

Best of luck!

--Jeff

[akshay pandit]

thanks jeff.. It worked

[akshay pandit]

thanks jeff.. It worked