Environment:
-JDK21 (but even 17 is KO)
- Oracle DB 19c
- Oracle driver ojdbc11 (23.3.0.23.09) but it happens also with ojdbc10 as
well
- Jooq 3.17 (Enterprise)
Hi,
we have an issue with model generator (by "org.jooq.codegen.GenerationTool"
direct call) when generating code for an Oracle View. The whole generated
java object looks fine except for one of the private costructor, the one
with the TableOptions.view("[ ..... ]") parameter, which contains a string
with the whole view's DML Sql code.
At some point of this very long String with DML (the view has something
like 600+ fields) the generator put an extra ".toString()" with the wrong
escaping like:
"...... ds.div_espressione_valori AS* tcy,\".toString() + "n *
NVL(div4.coddiv, '') AS tcy_str,\n ...."
and then, after another 1k charcter or so, the String is closed, but
wronlgy again:
"......... rivalutazione = 1\n".toString() + ""));
Problem is that the bold part make the string illegal (since the "+" is
inside " and not outside, so the strings are not concatenated correctly).
It looks like there is an extra \" or a missing one.. one way or another
they look not balanced and this brake the code.
We have no idea why this happens, our best guess is that the SQL string is
too long, since this string break after more than 16k characters. By the
way the view works like a charm in SQL direclty and once we manually fix
this issue, also the rest of JOOQ mapping is fine.
Any Idea? are we hitting some hard limit?
Thank you.
Alessandro
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/2ca6364f-901e-4548-887c-6140d99180ccn%40googlegroups.com.
