#158 Support for H2 Database Engine

2.1final
closed
General (118)
5
2006-03-01
2006-02-22
No

Hi,

I wrote a new Java database engine 'H2'
(http://www.h2database.com). It would be cool if you
can add support for this database. I suggest 3 or 4
drivers: In-Memory, Embedded, Server, and maybe Cluster.

Driver Names:
H2 In-Memory
H2 Embedded
H2 Client
H2 Client (Cluster)

URL format In-Memory:
jdbc:h2:mem:

URL format Embedded:
jdbc:h2:<databaseName>

URL format Client:
jdbc:h2:tcp://<server>[:<9092>]/<databaseName>

URL format Client (Cluster):
jdbc:h2:tcp://<server1>:<9101>,<server2>:<9102>/<databaseName>

Driver Class:
org.h2.Driver [for all cases]

Maybe you can add a link called 'Web Site' for all
drivers? Or 'Remarks'?
http://www.h2database.com

I can also write a patch if you want to, but maybe you
want to discuss first how many drivers (and which) to
add first.

Thanks,
Thomas

Discussion

  • Rob Manning

    Rob Manning - 2006-02-22

    Logged In: YES
    user_id=1287991

    Thomas,

    Let me just say it's a fine piece of work. I had it installed
    and connected to it with SQuirreL in minutes on WinXP.
    I'm working on updating the default definitions. Will let
    you know when it's available.

    I like the website idea. We could add another textfield
    to the add-driver dialog for this. Then maybe update
    the context menu to add "visit website" and maybe a little
    world icon in the toolbar.

    Rob

     
  • Rob Manning

    Rob Manning - 2006-02-23

    Logged In: YES
    user_id=1287991

    The definitions are in CVS, and will be available in the
    next Snapshot. To incorporate them into your drivers list,
    you will need to press the "Copy default driver defintions
    ... " button in the drivers dialog. Still looking into the
    website link portion of the request.

    Rob

     
  • Rob Manning

    Rob Manning - 2006-02-23
    • milestone: --> 2.1final
     
  • Rob Manning

    Rob Manning - 2006-03-01
    • status: open --> closed
     
  • Rob Manning

    Rob Manning - 2006-03-01

    Logged In: YES
    user_id=1287991

    The change is in CVS. The drivers window now has a "Launch
    the website for the selected driver" which will use the
    system default web browser to display a website - whichever
    website is configured for the selected driver. The default
    definitions have also been updated to have a website. These
    should get merged into your existing driver defs, so it is
    not necessary to start over. The drivers config change
    dialog also has a new text field to create a new or change
    an existing website value for a given driver.

    Rob Manning

     

Log in to post a comment.