You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by "Robert A. Decker" <de...@robdecker.com> on 2026/02/01 15:33:35 UTC
logging
I'm on cayenne 4.2 running in spring.
I'm building my server runtime in code so that I can have my own pk generator (see below).
I have the following application property which seems to be ignored:
log4j.logger.org.apache.cayenne.access.QueryLogger = WARN
Since I'm building the runtime by hand do I also need to create my own logger?
In my logfiles, it's logging at level INFO, with the logger interface org.apache.cayenne.log.JdbcEventLogger.
2026-02-01T16:24:50.986+01:00 INFO 13688 --- [ai] [ scheduling-1] org.apache.cayenne.log.JdbcEventLogger : === returned 0 rows. - took 18 ms.
Rob
cayenneRuntime = ServerRuntime.builder()
.addConfig("cayenne-project.xml")
.addModule(binder ->
ServerModule.contributePkGenerators(binder)
.put(MySQLAdapter.class.getName(), SmsPkGenerator.class))
.dataSource(DataSourceBuilder
.url(environment.getProperty("org.apache.cayenne.datasource.jdbc.url"))
.driver(environment.getProperty("org.apache.cayenne.datasource.jdbc.driver"))
.userName(environment.getProperty("org.apache.cayenne.datasource.jdbc.username"))
.password(environment.getProperty("org.apache.cayenne.datasource.jdbc.password"))
.pool(Integer.parseInt(Objects.requireNonNull(environment.getProperty("org.apache.cayenne.datasource.jdbc.minConnections"))),
Integer.parseInt(Objects.requireNonNull(environment.getProperty("org.apache.cayenne.datasource.jdbc.maxConnections"))))
.build())
.build();
Re: logging
Posted by "Robert A. Decker" <de...@robdecker.com>.
Ok, I figured this out. I'm doing this in spring which uses logback as the default logger. For this setup, the setting is:
logging.level.org.apache.cayenne.log.JdbcEventLogger=WARN
This applies to other settings too. For example:
logging.level.org.apache.cayenne.util = DEBUG
logging.level.org.apache.cayenne = INFO
So, you change log4j.logger to logging.level
Rob
> On 1 Feb 2026, at 21:42, John Huss <jo...@gmail.com> wrote:
>
> The correct property name is this:
>
> log4j.logger.org.apache.cayenne.log.JdbcEventLogger=WARN
>
> Otherwise, you can do it programmatically for log4j too.
>
> Logger.getLogger(JdbcEventLogger.class).setLevel(Level.WARN);
>
>
> On Sun, Feb 1, 2026 at 9:34 AM Robert A. Decker <de...@robdecker.com>
> wrote:
>
>> I'm on cayenne 4.2 running in spring.
>>
>> I'm building my server runtime in code so that I can have my own pk
>> generator (see below).
>>
>> I have the following application property which seems to be ignored:
>> log4j.logger.org.apache.cayenne.access.QueryLogger = WARN
>>
>> Since I'm building the runtime by hand do I also need to create my own
>> logger?
>>
>> In my logfiles, it's logging at level INFO, with the logger interface
>> org.apache.cayenne.log.JdbcEventLogger.
>> 2026-02-01T16:24:50.986+01:00 INFO 13688 --- [ai] [ scheduling-1]
>> org.apache.cayenne.log.JdbcEventLogger : === returned 0 rows. - took 18
>> ms.
>>
>> Rob
>>
>> cayenneRuntime = ServerRuntime.builder()
>> .addConfig("cayenne-project.xml")
>> .addModule(binder ->
>> ServerModule.contributePkGenerators(binder)
>> .put(MySQLAdapter.class.getName(),
>> SmsPkGenerator.class))
>> .dataSource(DataSourceBuilder
>>
>> .url(environment.getProperty("org.apache.cayenne.datasource.jdbc.url"))
>>
>> .driver(environment.getProperty("org.apache.cayenne.datasource.jdbc.driver"))
>>
>> .userName(environment.getProperty("org.apache.cayenne.datasource.jdbc.username"))
>>
>> .password(environment.getProperty("org.apache.cayenne.datasource.jdbc.password"))
>>
>> .pool(Integer.parseInt(Objects.requireNonNull(environment.getProperty("org.apache.cayenne.datasource.jdbc.minConnections"))),
>>
>> Integer.parseInt(Objects.requireNonNull(environment.getProperty("org.apache.cayenne.datasource.jdbc.maxConnections"))))
>> .build())
>> .build();
>>
Re: logging
Posted by John Huss <jo...@gmail.com>.
The correct property name is this:
log4j.logger.org.apache.cayenne.log.JdbcEventLogger=WARN
Otherwise, you can do it programmatically for log4j too.
Logger.getLogger(JdbcEventLogger.class).setLevel(Level.WARN);
On Sun, Feb 1, 2026 at 9:34 AM Robert A. Decker <de...@robdecker.com>
wrote:
> I'm on cayenne 4.2 running in spring.
>
> I'm building my server runtime in code so that I can have my own pk
> generator (see below).
>
> I have the following application property which seems to be ignored:
> log4j.logger.org.apache.cayenne.access.QueryLogger = WARN
>
> Since I'm building the runtime by hand do I also need to create my own
> logger?
>
> In my logfiles, it's logging at level INFO, with the logger interface
> org.apache.cayenne.log.JdbcEventLogger.
> 2026-02-01T16:24:50.986+01:00 INFO 13688 --- [ai] [ scheduling-1]
> org.apache.cayenne.log.JdbcEventLogger : === returned 0 rows. - took 18
> ms.
>
> Rob
>
> cayenneRuntime = ServerRuntime.builder()
> .addConfig("cayenne-project.xml")
> .addModule(binder ->
> ServerModule.contributePkGenerators(binder)
> .put(MySQLAdapter.class.getName(),
> SmsPkGenerator.class))
> .dataSource(DataSourceBuilder
>
> .url(environment.getProperty("org.apache.cayenne.datasource.jdbc.url"))
>
> .driver(environment.getProperty("org.apache.cayenne.datasource.jdbc.driver"))
>
> .userName(environment.getProperty("org.apache.cayenne.datasource.jdbc.username"))
>
> .password(environment.getProperty("org.apache.cayenne.datasource.jdbc.password"))
>
> .pool(Integer.parseInt(Objects.requireNonNull(environment.getProperty("org.apache.cayenne.datasource.jdbc.minConnections"))),
>
> Integer.parseInt(Objects.requireNonNull(environment.getProperty("org.apache.cayenne.datasource.jdbc.maxConnections"))))
> .build())
> .build();
>