Hi everybody,
I just joined, and although I don't know if I can contribute more than the occasional silly question, I will try ;)
(yeah I know, there is no try, only do or not do ;)
So here's my current question:
I'm working on a program that uses H2, and I use Intellij IDEA. The database design is pretty stable for now, and I want to use jOOQ's code generation to generate classes right into my IDEA project. I have managed so far, although I'm fairly new to jOOQ. There is one funny thing though. My H2 database uses multiple schemas, and oddly enough the PUBLIC schema comes up as
after code generation. i.e. as package/directory in IDEA as well as part of the package declaration in the generated classes.
Although it doesn't seem to be a major issue, it's bothering. I already tried to get around it by using a <schema> section in the XML file that I use for generation:
<schema>
<inputSchema>PUBLIC</inputSchema>
<outputSchema>public</outputSchema>
<outputSchemaToDefault>false</outputSchemaToDefault>
</schema>
Oddly enough, the schema isn't even recognised/processed if I don't specify it in caps as input schema.
However, even the code above causes the PUBLIC schema to appear as
after generation.
Things that make you go 'hmmmm'.
Any ideas, anyone?