# Ruby and H2/HSqlDb

**URL:** <https://www.ruby-forum.com/t/ruby-and-h2-hsqldb/103958>\
**Category:** Rails\
**Created:** [May 11, 2007, 11:04pm UTC](https://www.ruby-forum.com/t/ruby-and-h2-hsqldb/103958 "2007-05-11T23:04:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dtdtdt](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/b5ac83/32.png) [@dtdtdt](https://www.ruby-forum.com/u/dtdtdt)\
**Post date:** [May 11, 2007, 11:04pm UTC](https://www.ruby-forum.com/t/ruby-and-h2-hsqldb/103958/1 "2007-05-11T23:04:30Z")

</div>

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).

---

<div class="post-metadata">

**Author:** ![dtdtdt](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/b5ac83/32.png) [@dtdtdt](https://www.ruby-forum.com/u/dtdtdt)\
**Post date:** [May 12, 2007, 5:00pm UTC](https://www.ruby-forum.com/t/ruby-and-h2-hsqldb/103958/2 "2007-05-12T17:00:45Z")

</div>

On 5/11/07, dt [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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