Re: [xwiki-dev] Connection Pooling

Hi Ludovic, Thanks for the reply. That is a lot of dbs running on one server, very interesting to see mysql scale this well. I am not sure if setCatalog would work the same with Postgres and Oracle. Last I check on Postgres a call to setCatalog created a different db connection (socket level stuff). You can get the multi database stuff to work with postregres and oracle but you would instead need to qualify your table names with the corresponding namespace. Postgres has an explicit namespace feature while Oracle's is more tied to the owner of the class. This would work the same with mysql also for the most part. -Sam Ludovic Dubost <ludovic(a)xwiki.com> wrote: Hi, There is some information here on how to setup virtual wikis with xwiki http://www.xwiki.com/xwiki/bin/view/Doc/HowToSetupVirtualWikis This currently works with mysql and hasn't been tested with other DBs.. It relies on the setCatalog() function of JDBC so it should work with most DBs.. Using setCatalog does not need a separate connection pool for each DB even on mysql. The switch of database happens on the same connection. It works perfectly fine and we are running this with 4400 databases on xwiki.com Ludovic Sam Taha wrote: -- Ludovic Dubost XPertNet: http://www.xpertnet.fr/ Blog: http://www.ludovic.org/blog/ XWiki: http://www.xwiki.com Skype: ldubost AIM: nvludo Yahoo: ludovic -- You receive this message as a subscriber of the xwiki-dev(a)objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click.