Ruby and H2/HSqlDb

Hi,

Any way to actually get the H2 or HSQLDB working under rails (instead
of MySQL)? Looking at the supported databases right now for
ActiveRecord:

RAILS_CONNECTION_ADAPTERS = %w( mysql postgresql sqlite firebird
sqlserver db2 oracle sybase openbase frontbase )

H2/HSQLDB are not supported. Is there a driver for these? What about
Derby if not? Also, they seem to support JDBC, but I couldn’t find
JDBC driver also (there is one for JRuby, but it won’t work under
Rails - at least I couldn’t make it work).

On 5/11/07, dt [email protected] wrote:

H2/HSQLDB are not supported. Is there a driver for these? What about
Derby if not? Also, they seem to support JDBC, but I couldn’t find
JDBC driver also (there is one for JRuby, but it won’t work under
Rails - at least I couldn’t make it work).

I’m not aware of any non-java jdbc driver.

If you want an embedded db, and using JRuby is not an option, consider
SQLite3.

Isak

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs