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