We are building an ERP web app where each client company will have its data in a separate PostgreSQL database (all hosted in the same database server instance).
We plan to use JBoss AS 7.1 or 7.0 with Hibernate JPA to access that database. After the initial login at the web front-end a lookup at a table will provide the connection string to connect to the right database depending on who the user is.
So I was wondering, what is the maximum number of datasources that can be configured in file standalone/configuration/standalone.xml ? We would need a few hunderd at the most.