This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 116240 - Support JavaDB and Other databases better
Summary: Support JavaDB and Other databases better
Status: RESOLVED FIXED
Alias: None
Product: ruby
Classification: Unclassified
Component: Rails (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Torbjorn Norbye
URL:
Keywords: UI
Depends on:
Blocks:
 
Reported: 2007-09-21 02:10 UTC by Torbjorn Norbye
Modified: 2007-10-08 01:09 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Torbjorn Norbye 2007-09-21 02:10:04 UTC
The "New Rails Project" wizard has a dropdown listing available databases. These list exactly the set of databases
supported by Rails.

However, with the bundled ActiveRecord-JDBC gem, we can actually support any databases supported by JDBC. We should make
this easier.

The specific proposed changes are:

Add "JavaDB" to the list of databases in the drop down. If selected, the "Use JDBC" checkbox will also be checked.
Add "Other (JDBC)" to the list of databases in the drop down. 

If you choose JavaDB and finish the wizard, the IDE will replace the default created database.yml with a file suitable
for JavaDB.

If you choose Other (JDBC), it will replace the default created database.yml with a file suitable for JDBC - it will
default to JavaDB but using a JDBC syntax rather than the cleaner ActiveRecord-JDBC syntax.
Comment 1 Torbjorn Norbye 2007-09-21 02:17:55 UTC
By the way, these two choices are invalid if you're not using the JRuby interpreter (and will generate a wizard warning).

Also, Arun suggested I add JavaDB as the default choice; I'm wondering if that isn't a bit pushy since a lot of Ruby
developers (I suspect a majority) will want MySQL - which is also the default chosen by Rails. It's not as trivial as
checking whether the user is using JRuby to see if they have a Java-bent, since we've discovered that a lot of users
don't realize we've bundled JRuby and are using it rather than their system Ruby interpreter. (Note to self - we've
gotta find a way to make this more obvious - perhaps by putting a "Ruby Interpreter" choice right there in the New
Wizard the way some other Ruby IDEs do.)
Comment 2 Chris Kutler 2007-09-21 02:33:39 UTC
I think that the default should be MySQL because I think that is what most of our Ruby customers are using.

About: "If you choose Other (JDBC), it will replace the default created database.yml with a file suitable for JDBC - 
it will default to JavaDB but using a JDBC syntax rather than the cleaner ActiveRecord-JDBC syntax."

I wonder about defaulting to JavaDB. I would find that confusing. Perhaps you could instead use some sort of pattern
string that would help the person figure out what to put there (in the database.yml).

I will need some help with rewording http://www.netbeans.org/kb/60/ruby/setting-up.html#dbservers to discuss the JDBC
alternative and how to use JDBC instead of ActiveRecord-JDBC.

Note: I still think that there should be some indication in the wizard pane of how the choice in the dropdown affects
the project creation (that all you are really doing is specifying what to put in the database.yml configurations).
Comment 3 Torbjorn Norbye 2007-10-08 01:09:14 UTC
Fixed.

IDE:-------------------------------------------------
IDE: [10/7/07 5:08 PM] Committing started
Checking in railsprojects/src/org/netbeans/modules/ruby/railsprojects/ui/wizards/RailsInstallationPanel.java;
/cvs/ruby/railsprojects/src/org/netbeans/modules/ruby/railsprojects/ui/wizards/RailsInstallationPanel.java,v  <-- 
RailsInstallationPanel.java
new revision: 1.4; previous revision: 1.3
done
Checking in railsprojects/src/org/netbeans/modules/ruby/railsprojects/ui/wizards/PanelOptionsVisual.java;
/cvs/ruby/railsprojects/src/org/netbeans/modules/ruby/railsprojects/ui/wizards/PanelOptionsVisual.java,v  <-- 
PanelOptionsVisual.java
new revision: 1.4; previous revision: 1.3
done
Checking in railsprojects/src/org/netbeans/modules/ruby/railsprojects/ui/wizards/Bundle.properties;
/cvs/ruby/railsprojects/src/org/netbeans/modules/ruby/railsprojects/ui/wizards/Bundle.properties,v  <--  Bundle.properties
new revision: 1.10; previous revision: 1.9
done
Checking in railsprojects/src/org/netbeans/modules/ruby/railsprojects/ui/wizards/PanelOptionsVisual.form;
/cvs/ruby/railsprojects/src/org/netbeans/modules/ruby/railsprojects/ui/wizards/PanelOptionsVisual.form,v  <-- 
PanelOptionsVisual.form
new revision: 1.3; previous revision: 1.2
done
Checking in projects/src/org/netbeans/modules/ruby/rubyproject/ui/wizards/PanelOptionsVisual.java;
/cvs/ruby/projects/src/org/netbeans/modules/ruby/rubyproject/ui/wizards/PanelOptionsVisual.java,v  <-- 
PanelOptionsVisual.java
new revision: 1.3; previous revision: 1.2
done
Checking in projects/src/org/netbeans/modules/ruby/rubyproject/ui/wizards/Bundle.properties;
/cvs/ruby/projects/src/org/netbeans/modules/ruby/rubyproject/ui/wizards/Bundle.properties,v  <--  Bundle.properties
new revision: 1.4; previous revision: 1.3
done
Checking in projects/src/org/netbeans/modules/ruby/rubyproject/ui/wizards/PanelOptionsVisual.form;
/cvs/ruby/projects/src/org/netbeans/modules/ruby/rubyproject/ui/wizards/PanelOptionsVisual.form,v  <-- 
PanelOptionsVisual.form
new revision: 1.2; previous revision: 1.1
done
Checking in platform/src/org/netbeans/api/ruby/platform/Bundle.properties;
/cvs/ruby/platform/src/org/netbeans/api/ruby/platform/Bundle.properties,v  <--  Bundle.properties
new revision: 1.4; previous revision: 1.3
done
Checking in platform/src/org/netbeans/api/ruby/platform/RubyInstallation.java;
/cvs/ruby/platform/src/org/netbeans/api/ruby/platform/RubyInstallation.java,v  <--  RubyInstallation.java
new revision: 1.21; previous revision: 1.20
done
Checking in railsprojects/src/org/netbeans/modules/ruby/railsprojects/RailsProjectGenerator.java;
/cvs/ruby/railsprojects/src/org/netbeans/modules/ruby/railsprojects/RailsProjectGenerator.java,v  <-- 
RailsProjectGenerator.java
new revision: 1.10; previous revision: 1.9
done
IDE: [10/7/07 5:08 PM] Committing finished
IDE: [10/7/07 5:08 PM] Diffing finished
IDE: [10/7/07 5:08 PM] Diffing finished