Evan Leonard wrote:
So for my scenario does it sound like this would work:
1. startup application
2. use softupgrade connection to determine database schema version
3. user confirms upgrade via UI
4. issue db shutdown connection
5. issue db upgrade connection
6. continue on using the application with the upgraded database
This would all be in one JVM instance, without ever restarting the
JVM. Anyone know of a reason this won't work?
That sounds like a good plan, but just remember that your existing
connections that were established before shutdown will no longer be
usable and you will have to make new ones.
Kathey
