We are using the org.apache.commons.dbcp.BasicDataSource as parent class for our datasources in Spring.
Is it possible to specify which schema to use in either the "url" or in another property in the DBCP datasource?
I don't think it's possible to specify the schema since this is a function of the user, not the JDBC session. You should probably create a user with their default schema set to each schema you want to use, and then specify the user in the dbcp configuration.