Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

datasource for multiple database

 
akshay pandit
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm using Jboss 3.2.3
 
Jeff Shelley
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks jeff.. It worked
 
akshay pandit
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks jeff.. It worked
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic