Re: logging

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=3DWARN

This applies to other settings too. For example:
logging.level.org.apache.cayenne.util =3D DEBUG
logging.level.org.apache.cayenne =3D INFO

So, you change log4j.logger to logging.level


Rob
> On 1 Feb 2026, at 21:42, John Huss <[email protected]> wrote:
>=20
> The correct property name is this:
>=20
> log4j.logger.org.apache.cayenne.log.JdbcEventLogger=3DWARN
>=20
> Otherwise, you can do it programmatically for log4j too.
>=20
> Logger.getLogger(JdbcEventLogger.class).setLevel(Level.WARN);
>=20
>=20
> On Sun, Feb 1, 2026 at 9:34=E2=80=AFAM Robert A. Decker =
<[email protected]>
> wrote:
>=20
>> I'm on cayenne 4.2 running in spring.
>>=20
>> I'm building my server runtime in code so that I can have my own pk
>> generator (see below).
>>=20
>> I have the following application property which seems to be ignored:
>> log4j.logger.org.apache.cayenne.access.QueryLogger =3D WARN
>>=20
>> Since I'm building the runtime by hand do I also need to create my =
own
>> logger?
>>=20
>> 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   : =3D=3D=3D returned 0 rows. =
- took 18
>> ms.
>>=20
>> Rob
>>=20
>> cayenneRuntime =3D ServerRuntime.builder()
>>        .addConfig("cayenne-project.xml")
>>        .addModule(binder ->
>>                ServerModule.contributePkGenerators(binder)
>>                        .put(MySQLAdapter.class.getName(),
>> SmsPkGenerator.class))
>>        .dataSource(DataSourceBuilder
>>=20
>> =
.url(environment.getProperty("org.apache.cayenne.datasource.jdbc.url"))
>>=20
>> =
.driver(environment.getProperty("org.apache.cayenne.datasource.jdbc.driver=
"))
>>=20
>> =
.userName(environment.getProperty("org.apache.cayenne.datasource.jdbc.user=
name"))
>>=20
>> =
.password(environment.getProperty("org.apache.cayenne.datasource.jdbc.pass=
word"))
>>=20
>> =
.pool(Integer.parseInt(Objects.requireNonNull(environment.getProperty("org=
.apache.cayenne.datasource.jdbc.minConnections"))),
>>=20
>> =
Integer.parseInt(Objects.requireNonNull(environment.getProperty("org.apach=
e.cayenne.datasource.jdbc.maxConnections"))))
>>                .build())
>>        .build();
>>=20