Thanks for any suggestions!
Originally posted by James Adams:
I want to specify that this DataSource bean use a specific schema, but I can't find any information on how I can specify which schema I will be using through this DataSource. For example I have the production schema duplicated as a development schema, and I want to use the development schema for my development so I don't step on ay production data. How can I configure my DataSource so that the correct (development) schema is used for JDBC operations when I do my development and testing?
Depends on the database you use, but in general:
You can create a test database account that points to your test schema,
and a production database account that points to your production schema.
Switching schemas can be done by selecting a different user in your DataSource setup.
What database are you using?