I am running ejb3 on a Jboss 4.0.5 server that accesses data on an iseries.

I am wondering, how one can dynamically set a schema (library) to retrieve table data.

I am able to get data back if I use a single schema inside a data source, but this does not help me. The system is set up, where Table A exists in Schema 1 and Table B exists in Schema 2, and my JSF component needs to access both Table A & B. There also cases where I need to dynamically set the schema for a certain Table.

I do this with JDBC with no problems, but I am not sure with EJB 3 and the persistance API.

Brian