Re: How to maintain a schema per user?

2008-11-18 Thread David Blevins
On Nov 10, 2008, at 2:35 PM, Paul Spencer wrote: Dain, I am using OpenJPA. Do you know if, and how, they support per user connections? OpenJPA will use whatever DataSources we give it. You might be able to use the Commons DBCP PerUserPoolDataSource as Dain suggests but it'll take

How to maintain a schema per user?

2008-11-10 Thread Paul Spencer
I have an application that requires a logged in user be restricted to a schema within the database. For the sake of illustration, the application is an address book and their is one schema per user. The database structure of the table and views within each schema are exactly same. My

Re: How to maintain a schema per user?

2008-11-10 Thread Dain Sundstrom
Assuming you are using straight JDBC or a persistence framework designed for per-user connections, I believe that the org.apache.commons.dbcp.datasources.PerUserPoolDataSource pool can do what you want, but I've never used per-user pools myself. Also, I bet that c3p0

Re: How to maintain a schema per user?

2008-11-10 Thread Paul Spencer
Dain, I am using OpenJPA. Do you know if, and how, they support per user connections? Paul Spencer Dain Sundstrom wrote: Assuming you are using straight JDBC or a persistence framework designed for per-user connections, I believe that the