My apologies, I just never saw that first <element> line. (Possibly
because I dislike xml. A lot)
One-off Toggling of this sort of config is so much easier as Properties
applied on the command line or driving script. Just sayin'
Thank you for you patience.
rjs
On 3/30/21 12:05 PM, Lukas Eder wrote:
Please check the XSD.
- The root element is "settings".
- The contents are always text nodes, never attributes (for better
interoperability with e.g. Maven, where applicable)
You can use any online XSD validator (e.g.
https://www.liquid-technologies.com/online-xsd-validator
<https://www.liquid-technologies.com/online-xsd-validator>) to
validate your XML. For example, this should work:
<settings xmlns="http://www.jooq.org/xsd/jooq-runtime-3.14.0.xsd
<http://www.jooq.org/xsd/jooq-runtime-3.14.0.xsd>">
<executeLogging>false</executeLogging>
</settings>
JAXB by default doesn't validate XSD but just ignores invalid content,
which makes debugging a bit hard. But any XSD validator works, too.
Just to be clear, turning executeLogging off will turn off the
LoggerListener. There are still many other places where jOOQ logs
things. If you want to turn off *everything*, just configure your
logger (slf4j, log4j, jul, etc.) accordingly.
I hope this helps,
Lukas
On Tue, Mar 30, 2021 at 7:24 PM Rob Sargent <[email protected]
<mailto:[email protected]>> wrote:
On 3/29/21 2:22 PM, Lukas Eder wrote:
Are you perhaps confusing the two XSDs? You seem to be looking
for this one (root element "settings"):
https://www.jooq.org/xsd/jooq-runtime-3.14.0.xsd
<https://www.jooq.org/xsd/jooq-runtime-3.14.0.xsd>
My usage is as follows:
public void doGet(HttpServletRequest req,
HttpServletResponse resp) {
HashMap<String, ArrayList<String>> pmap =
getParameterMap(req);
try (Connection conn = getDbConn(req, pmap) ){
DSLContext dsl = DSL.using(conn, SQLDialect.POSTGRES);
/* NO Further DSL configuration */
I believe tried this jooq-settings.xml
<annotation
xmlns="http://www.jooq.org/xsd/jooq-runtime-3.14.0.xsd";
<http://www.jooq.org/xsd/jooq-runtime-3.14.0.xsd>>
<all>
<executeLogging value="false"/>
</all>
</annotation>
AND
<annotation
xmlns="http://www.jooq.org/xsd/jooq-runtime-3.14.0.xsd";
<http://www.jooq.org/xsd/jooq-runtime-3.14.0.xsd>>
<executeLogging value="false"/>
</annotation>
in WEB-INF/classes/jooq-settings.xml,
WEB-INF/lib/jooq-settings.xml (since the database is called from
servlets in an embedded tomcat). And also
-Dorg.jooq.settings=<filename>, CLASSPATH for the java command
line but I'm still getting jooq debug output. Where oh where have
I gone wrong?
Thanks,
rjs
But you used this one (root element "configuration"):
https://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
<https://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>
On Mon, Mar 29, 2021 at 9:56 PM Rob Sargent
<[email protected] <mailto:[email protected]>> wrote:
I would prefer -D option to set the property directly but
what would be the property name?
There is none.
--
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]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/CAB4ELO5oDYj8tGLuZOzficTqgKxf8Gz725EeHciSZQh%3DndYavQ%40mail.gmail.com
<https://groups.google.com/d/msgid/jooq-user/CAB4ELO5oDYj8tGLuZOzficTqgKxf8Gz725EeHciSZQh%3DndYavQ%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
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]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/6ee6b9b6-a185-e700-9fd0-9d8e8a3388c3%40gmail.com
<https://groups.google.com/d/msgid/jooq-user/6ee6b9b6-a185-e700-9fd0-9d8e8a3388c3%40gmail.com?utm_medium=email&utm_source=footer>.
--
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]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/CAB4ELO7UfvZfszehRr-Mf2%3DJrmPHBq5eKG46XprB6NWWx0FrFw%40mail.gmail.com
<https://groups.google.com/d/msgid/jooq-user/CAB4ELO7UfvZfszehRr-Mf2%3DJrmPHBq5eKG46XprB6NWWx0FrFw%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
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/1e415477-b5a2-eafa-7908-bc9cc4313dfc%40gmail.com.
