Hello, You guys seem to be fighting for the right to implement this MSSQL support :-)
In general, it is described here: https://sourceforge.net/apps/trac/jooq/wiki/Contribute In detail, you have to do these steps (I'll add them to the contribution page for future reference): - Migrate create.sql and reset.sql scripts to MSSQL dialect - Create the above schema and data in your test database - Override org.jooq.util.AbstractDatabase. Ideally, you'll use the jOOQ API to navigate through the SQL Server meta-schema in order to discover your test schema. Apart from the integration tests, this adds an additional layer of "proof of concept". See for instance org.jooq.util.oracle.OracleDatabase, where rather complex nested queries are used to navigate through Oracle foreign key relationships. - For a minimal implementation, check out org.jooq.util.sqlite.SQLiteDatabase, which only implements loadPrimaryKeys0() and getTables0(). All other implementations are optional extensions. Once you've done these steps, in order to be sure that everything works fine you'll also have to do this: - Let jOOQ generate the integration test schema - Extend the org.jooq.test.jOOQAbstractTest for MSSQL - Run the integration tests for MSSQL - Fix all issues. You should get syntax errors, SQLDialectNotSupportedExceptions, etc If you provide me with instructions how to set up the MSSQL instance and any partial implementation of the above, I'm going to take that into the jOOQ code base (giving you credit, of course) and guaranteeing implementation integrity in the future. 2011/4/20 FractalizeR <[email protected]>: > What classes needs to be implemented to add MSSQL support, BTW? > > On 20 апр, 13:34, Lukas Eder <[email protected]> wrote: >> > thanks for your answer, I really like jOOQ but I definitely need MSSQL >> > support, so I was considering to try to develop it... >> >> That is great news! I was starting to implement that, actually. But >> then some urgent tasks came up which were more important for release >> 1.5.7. I was having a bit of trouble to actually connect to a SQL >> Server with JDBC. I probably didn't set up my instance correctly. If >> you could do that for me, that would be really great. Do you need any >> help / hints other than those mentioned >> onhttps://sourceforge.net/apps/trac/jooq/wiki/Contribute >> >> Feel free to tell me. Also, if you could help me set up my instance >> correctly, maybe I can give you a hand with that SQL Server >> integration >> >> Cheers >> Lukas
