Page History

...

Changing a field type in Derby
Browsing a Derby database and more using Squirrel
Use cvv codes in OFBiz
Patching on Windows
Running OFBiz as a Windows service

...

1. Export the table to xml
2. Drop the table
3. Start OFBiz - table recreated with new structure
4. Import xml data from #1

Advice from Adrian Crum.

http://db.apache.org/derby/integrate/SQuirreL_Derby.html#N101C7^{Image Added}
For the URL use something like jdbc:derby:c:/ofbiz/runtime/data/derby/ofbiz (of course using your right path)

Link from Sundeep Ray

...