[jboss-user] [JCA/JBoss] - Re: one data source with multiple database users

[PeterJ]

I hope you don't expect decent performance from your application, or that you have very few users. Establishing a database connection is a very expensive operation. Getting a new connection each time you need to access the database is a definite performance killer.

You do not, by any chance, have a mainframe background? What you want is typical in mainframes - the end user's identity is used to access the database thus enabling the db admin to lock down the database based on users or their roles.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4164280#4164280

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4164280