Code generation for large schemas

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

Databases can become very large in real-world applications. This is not a problem for jOOQ's code generator, but it can be for the Java compiler. jOOQ generates some classes for global access. These classes can hit two sorts of limits of the compiler / JVM:

• Methods (including static / instance initialisers) are allowed to contain only 64kb of bytecode.
• Classes are allowed to contain at most 64k of constant literals

While there exist workarounds for the above two limitations (delegating initialisations to nested classes, inheriting constant literals from implemented interfaces), the preferred approach is either one of these:

• Distribute your database objects in several schemas. That is probably a good idea anyway for such large databases
• Configure jOOQ's code generator to exclude excess database objects
• Configure jOOQ's code generator to avoid generating global objects using <globalObjectReferences/>
• Remove uncompilable classes after code generation

Feedback

Do you have any feedback about this page? We'd love to hear it!