Hello, > I tried out jOOQ a while ago (sometime last year) but didn't go far because > Firebird was not supported but is coming SOON. (ref > http://sourceforge.net/apps/trac/jooq/ticket/430
Yes, that ticket has become #430 on GitHub, now: https://github.com/jOOQ/jOOQ/issues/430 > Last week i took another look and it seems that it's still not supported. That is correct. > The documentation and tutorial all heavily rely on the generated artifacts > so this is becoming a bit of a chicken-and-egg problem for me. True, I'm currently reworking the documentation. It will still heavily rely on generated artefacts, as that is the main use-case for using jOOQ (support for aliasing, type-safety, IDE-support, etc.). I've met a couple of users on this group as well as on conferences, who prefer to use jOOQ just as a mere SQL builder, without source code generation, but as you put it: > At the moment, I can already connect and issue queries to firebird using > "plain sql" approach, but i suppose this is not even close to the full > potential of jOOQ. Yes, the full potential is available only when source code is generated. > TL;DR: Assuming nobody is working on it, Is there a guide somewhere on how > to implement a proper support for Firebird? (or a custom database) I'm currently not working on that, and I doubt anyone else is, right now. There are a couple of hints about implementing your own code generation support here: http://www.jooq.org/community.php If you wish to provide an initial contribution, that would be very nice. I can take over any working parts to make the whole lot of integration tests run (around 1000 queries for new databases). So far, Firebird support was only stalled by the simple fact that I didn't succeed in installing Firebird on my Windows machine... I'll try to re-install it again some time this week. Firebird would be a nice database to support. It has 650 questions tagged with it on Stack Overflow, which is more than Derby, H2 or HSQLDB, three popular Java databases http://stackoverflow.com/questions/tagged/firebird http://stackoverflow.com/questions/tagged/h2 http://stackoverflow.com/questions/tagged/hsqldb http://stackoverflow.com/questions/tagged/derby Cheers Lukas
