aspose file tools*
The moose likes JForum and the fly likes Will JForum Work With Firebird 2.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Will JForum Work With Firebird 2.1" Watch "Will JForum Work With Firebird 2.1" New topic
Author

Will JForum Work With Firebird 2.1

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Will JForum Work With Firebird 2.1