Thank you. I've implemented the plan below and it works well.
I agree that the requirement to have "upgrade=true" be on the first
connection to a db be added to the documentation. Perhaps also include
this trick about shutting down the db first to be able to upgrade the
db in a single jvm instance that's already been connected to the db.
Thank everyone for your help.
Evan
On Jun 2, 2009, at 10:07 AM, Kathey Marsden wrote:
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
