Re: Re: Support for H2Database

Oops, I see what you have done, just extended HSQL Driver.  I'll 
refactor a bit and add it.

Please confirm the unit tests pass.

Anthony

At 07:39 PM 25/09/2008, Anthony Berglas wrote:
>Hello Harry,
>
>Thanks for that.
>
>But before I include your code, what about the other things in 
>SDriverHSQL?  In particular, is the support for SEQUENCES the same 
>in H2 as it is in HSQL?  Did you remove the code deliberately?
>
>Your loading code is OK, but if you look at the beginning of 
>SDriver.java you will see where drivers are loaded 
>automatically.  I'll do that when your done.
>
>Anthony
>
>At 07:25 PM 23/09/2008, you wrote:
>
>>Hi,
>>
>>I've been using this just as you described, and it works fine.
>>Here is the class I use :
>>
>>package org.hmn.jrsd.demo;
>>
>>import simpleorm.drivers.SDriverHSQL;
>>import simpleorm.sessionjdbc.SDriver;
>>
>>/*
>>*
>>* Cree par Harry Karadimas a 9 sept. 08
>>*/
>>/**
>>* The H2 is mostly HSQL (H2 is a fork, by the original author of HSQLDB)
>>*/
>>public class H2Driver
>>extends SDriverHSQL
>>{
>>@Override
>>protected String driverName() {
>>return "H2 JDBC Driver";
>>}
>>
>>}
>>
>>To use the driver, it must first be registered when the
>>application starts :
>>
>>//we register the H2 driver
>>new H2Driver().registerDriver();
>>
>>You can then connect to the H2 database as usual :
>>
>>try {
>>Class.forName("org.h2.Driver");
>>driverLoaded = true;
>>}
>>catch (Exception ex) {
>>throw new SQLException("Could not load H2 driver ("+ex+")");
>>}
>>Connection cxn = DriverManager.getConnection(url, user, password);
>>
>>I don't really know if that is the best way to do it, however.
>>
>>Harry
>>
>>--- In 
>><mailto:SimpleORM%40yahoogroups.com>[email protected], 
>>Anthony Berglas <anthony@...> wrote:
>> >
>> > Have not done this yet. But if you copy the HSQL driver it should
>> > only require trivial changes. SimpleORM minimizes database
>>dependent code.
>> >
>> > If you do this and it runs through the test cases then please post it
>> > back to the list and I'll add it to the source.
>> >
>> > Anthony
>> >
>> > At 06:15 AM 23/09/2008, alspaughb wrote:
>> > >Does SimpleORM support H2Database? I can't find an SDriver subclass
>> > >for it.
>> > >
>> > ><http://www.h2database.com>http://www.h2database.com
>> > >
>> > >I like the fact that H2 is lightweight, pure Java, and supports multi
>> > >version concurrency.
>> > >
>> > >Bruce
>> >
>> > Dr Anthony Berglas, anthony@... Mobile: +61 4 4838 8874
>> > Just because it is possible to push twigs along the ground with ones
>>nose
>> > does not necessarily mean that is the best way to collect firewood.
>> >
>>
>>
>
>Dr Anthony Berglas, [email protected]       Mobile: +61 4 4838 8874
>Just because it is possible to push twigs along the ground with ones nose
>does not necessarily mean that is the best way to collect firewood.

Dr Anthony Berglas, [email protected]       Mobile: +61 4 4838 8874
Just because it is possible to push twigs along the ground with ones nose
does not necessarily mean that is the best way to collect firewood.


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/SimpleORM/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/SimpleORM/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[email protected] 
    mailto:[email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/