• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Bear Bibeault
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh

Will JForum Work With Firebird 2.1

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi

I have to have a forum that can run in the Firebird 2.1 database. It's a very standard database that uses jdbc. I am capable of changing any database scripts to Firebird syntax.

I don't see any problems, do you?

Regards


[originally posted on jforum.net by Infomedia]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The DAO mechanism should make this fairly easy. To do this correctly, you will need to create your own "FireBird" DAO package. Start off with all the classes being just simple subclasses of the GenericDAO implimentations.

You can then also start creating your own firebird.sql queries in association with this new DAO. If you can "tweak" the SQL to work, then the code can stay the same. Otherwise, you may have to modify the specific DAO methods as needed.

Probably the biggest "gotcha" in getting jForum to work with a DB is the use of Limits and Offsets in some of the
queries. Not all DB's support them. This is the main reason that it's hard to get jForum to support older MS SQL versions.

Of course, the other issue is how to test your new DAO... unfortunately, this is a pretty manual process. I'd suggest having access to a supported DB (e.g MySQL) so you can easily compare query results for differences.

Finally, all this is about 2.1.x.. jForum 3.0 uses hybernate so supporting Firebird should be as simple as changing the SQL dialog (or what ever hybernate calls it now).
[originally posted on jforum.net by monroe]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Monroe

Thanks for your pointers, I'd sort of already worked out that it's a no go for Firebird 1.5. I does not have the paging capabilities.

Firebird 2.1 does and so I'll go ahead with that.

I've done the database scripts but I'll have to get JForum set up in Eclipse to sort any coding out.

When I've cracked it, I'll donate the scripts to you guys.

It's sort of a back burner thing but I want to get this done fairly soon.

I'm sure that I'll be asking some questions shortly.

Regards

Lyndon
[originally posted on jforum.net by Infomedia]
 
reply
    Bookmark Topic Watch Topic
  • New Topic