Re: [opennms-devel] Firebird DB support

On Nov 2, 2005, at 6:42 PM, William L. Thomson Jr. wrote:

> I really want to install and use OpenNMS. However I really do not want
> to install and use PostgreSQL. I have nothing against PostgreSQL but
> prefer Firebird.

Thank you for your enthusiasm about OpenNMS and your willingness to  
donate precious time.  As far as adding support for Firebird, I would  
wait for the commits and proceedings from this week's DevJam where  
you will see our commitment to moving to Hibernate as an ORM.  Even  
though the focus of this conference is improving the Web MVC  
framework and various view technologies, much work in the domain  
model is required.  Hibernate is playing a major role and is helping  
us tremendously.  I see Hibernate has support for Firebird.  You may  
want to investigate any potential issues with Hibernate and Firebird,  
too.

After this week, brozow and the OGP will be more than happy to get  
more help migrating the entire domain model, if you want to jump in  
drop them a note (careful, the water is a bit chilly (grin)).

> Are there any Java bindings or is it straight JDBC from there? Aside
> from stored procs, and etc.

The stored procs will probably need to go.  I haven't given this a  
lot of thought, though.  We have added our stored procedures to HSQL  
(easy because they are Java) in our JUnit tests and could do the same  
of other databases, but this would tie us down to DBs that support  
this functionality.  Is that an issue?  I don't know, yet.

> Thanks, and be kind I am an OpenNMS newb and have not spent much time
> with the sources yet. This weekend, I plan to get somewhat intimate.
> Just after my first date with OpenNMS. :)

I would Eclipse IDE as a chaperon on your first date (grin).

Thanks again,

-David


David Hustace
The OpenNMS Group, Inc.
Main  : +1 919 545 2553   Fax:   +1 503-961-7746
Direct: +1 919 827 1201   Skype: dhustace
Key Fingerprint: 8EC1 F319 2C1D 3197 AAB9  580F FACD 1D19 175E D903




-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/wiki/index.php?page=MailingListFaq

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this 
page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel