Re: 10.2.1.1 beta now available for testing

2006-08-26 Thread Daniel John Debrunner
Stephen Caine wrote: Rick, Is there a process for updating an existing 10.1 database? I get this error: Yes, the process is described here for 10.0 to 10.1, but it's the same for 10.1 to 10.2. http://wiki.apache.org/db-derby/UpgradingTen It's also documented:

Re: 10.2.1.1 beta now available for testing

2006-08-26 Thread Stephen Caine
Dan, Is there a process for updating an existing 10.1 database? Yes, the process is described here for 10.0 to 10.1, but it's the same for 10.1 to 10.2. http://wiki.apache.org/db-derby/UpgradingTen It's also documented: http://db.apache.org/derby/docs/10.1/devguide/cdevupgrades.html

Re: 10.2.1.1 beta now available for testing

2006-08-26 Thread Stephen Caine
Knut, Upgrade is disabled in alpha and beta releases of Derby, but you can enable it by setting the derby.database.allowPreReleaseUpgrade property (java -Dderby.database.allowPreReleaseUpgrade=true ). If you set that property, your 10.1 database is booted in soft upgrade mode, which

Re: 10.2.1.1 beta now available for testing

2006-08-26 Thread Knut Anders Hatlen
Stephen Caine [EMAIL PROTECTED] writes: Knut, Upgrade is disabled in alpha and beta releases of Derby, but you can enable it by setting the derby.database.allowPreReleaseUpgrade property (java -Dderby.database.allowPreReleaseUpgrade=true ). If you set that property, your 10.1 database

Re: 10.2.1.1 beta now available for testing

2006-08-26 Thread Stephen Caine
Knut, Can I set the derby.database.allowPreReleaseUpgrade property in the Derby properties file? Yes, you can. Did this and it worked just fine, except that for a 40,000 record database, I am getting timeout errors. I gather that the update is dynamic, performing its tasks as the

Re: delete a column feature

2006-08-26 Thread Bryan Pendleton
Stephen Caine wrote: What we are waiting for is the ability to delete a table column. It's great to hear that you are having success using Derby! Regarding the ability to delete a column from a table, you may want to follow the progress of http://issues.apache.org/jira/browse/DERBY-1489

Re: delete a column feature

2006-08-26 Thread Stephen Caine
Bryan, Regarding the ability to delete a column from a table, you may want to follow the progress of http://issues.apache.org/jira/browse/ DERBY-1489 Note that there is a patch currently available for this issue. If possible, it would be wonderful if you could apply this patch in your

Re: delete a column feature

2006-08-26 Thread Bryan Pendleton
Where is the patch and how do I 'apply' it? The patch is an attachment to the JIRA issue. Go to http://issues.apache.org/jira/browse/DERBY-1489 and look at the File Attachments section of the web page. You can download the patch just by clicking on it. To apply the patch, you'll need to learn

Re: delete a column feature

2006-08-26 Thread Stephen Caine
Bryan, The patch is an attachment to the JIRA issue. Go to http:// issues.apache.org/jira/browse/DERBY-1489 and look at the File Attachments section of the web page. You can download the patch just by clicking on it. OK To apply the patch, you'll need to learn how to build Derby from

good visual schema browser for derby?

2006-08-26 Thread Michael McCutcheon
Can anyone recommend a good visual schema browser that works well with derby? Additionally, are there any graphical tools that allow me to create tables, relationships, etc.? I'm just tired of using IJ. It feels like using 'bear skins and knives' to do database development. (stolen from