connecting to Multiple DataBase Schemas.

[sirip]

I am new to Jboss Community and Jboss.

Can we connect to more than 2 schemas using JBoss and JBoss Seam.

I have seen some posts which are already there... every example i have seen two DB connections. can we do more than two. My requirement is to connect to 10 to 12 Schemas at the same time.

Thanks

Siri

[wdfink]

You might use such number of different connections but it will increase the complexity.

If you use entities (EJB2 or EJB3) you have to deploy the entity for each schema/connection in one jar.

Also I don't surveying the performance impacts, it bring more overhead and synchronization work ...

[sirip]

Thank you Wolf-Dieter Fink. Is there any that we can increase Performence and reduce complexity.

All my schemas have same tables but different data.

[wdfink]

No,

because

- many persistence jar's

- it will be complex to understand at runtime

- enlist more than one datasource in a transaction

For example the access to connection pool and transaction manager must be done (just duration) and in case of parallel access these must be synchronized. So that might become as a bottleneck and scalability blocker.

[sirip]

Thank you Wolf-Dieter Fink.