aspose file tools*
The moose likes JBoss/WildFly and the fly likes datasource for multiple database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "datasource for multiple database" Watch "datasource for multiple database" New topic
Author

datasource for multiple database

akshay pandit
Ranch Hand

Joined: Jun 15, 2003
Posts: 44
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
Ranch Hand

Joined: Jun 15, 2003
Posts: 44
I'm using Jboss 3.2.3
Jeff Shelley
Ranch Hand

Joined: May 21, 2003
Posts: 70
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


It's almost Friday
akshay pandit
Ranch Hand

Joined: Jun 15, 2003
Posts: 44
thanks jeff.. It worked
akshay pandit
Ranch Hand

Joined: Jun 15, 2003
Posts: 44
thanks jeff.. It worked
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: datasource for multiple database