(logging-log4j2) branch main updated: Update eventDate column type from DATETIME to TIMESTAMP in database table definitions (#4307)

[ramanathan]

This is an automated email from the ASF dual-hosted git repository.

ramanathan1504 pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/logging-log4j2.git


The following commit(s) were added to refs/heads/main by this push:
     new d4a197182f Update eventDate column type from DATETIME to TIMESTAMP in 
database table definitions (#4307)
d4a197182f is described below

commit d4a197182fda4ad22860207fefef71d9843eafd3
Author: Ramanathan <ramanat...@apache.org>
AuthorDate: Mon Sep 7 10:23:00 2026 +0530

    Update eventDate column type from DATETIME to TIMESTAMP in database table 
definitions (#4307)
---
 .../apache/logging/log4j/jdbc/jndi/JdbcAppenderH2DataSourceTest.java    | 2 +-
 .../logging/log4j/jdbc/appender/JdbcAppenderH2FactoryMethodTest.java    | 2 +-
 .../java/org/apache/logging/log4j/perf/jmh/JdbcAppenderBenchmark.java   | 2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)

diff --git 
a/log4j-jdbc-jndi/src/test/java/org/apache/logging/log4j/jdbc/jndi/JdbcAppenderH2DataSourceTest.java
 
b/log4j-jdbc-jndi/src/test/java/org/apache/logging/log4j/jdbc/jndi/JdbcAppenderH2DataSourceTest.java
index 1a94e94910..02bfb64023 100644
--- 
a/log4j-jdbc-jndi/src/test/java/org/apache/logging/log4j/jdbc/jndi/JdbcAppenderH2DataSourceTest.java
+++ 
b/log4j-jdbc-jndi/src/test/java/org/apache/logging/log4j/jdbc/jndi/JdbcAppenderH2DataSourceTest.java
@@ -22,7 +22,7 @@ public class JdbcAppenderH2DataSourceTest extends 
AbstractJdbcAppenderDataSource
         super(new JdbcRule(
                 JdbcH2TestHelper.TEST_CONFIGURATION_SOURCE_MEM,
                 "CREATE TABLE dsLogEntry ("
-                        + "id INTEGER GENERATED BY DEFAULT AS IDENTITY, 
eventDate DATETIME, literalColumn VARCHAR(255), level NVARCHAR(10), "
+                        + "id INTEGER GENERATED BY DEFAULT AS IDENTITY, 
eventDate TIMESTAMP, literalColumn VARCHAR(255), level NVARCHAR(10), "
                         + "logger NVARCHAR(255), message VARCHAR(1024), 
exception NCLOB, anotherDate TIMESTAMP" + ")",
                 "DROP TABLE IF EXISTS dsLogEntry"));
     }
diff --git 
a/log4j-jdbc/src/test/java/org/apache/logging/log4j/jdbc/appender/JdbcAppenderH2FactoryMethodTest.java
 
b/log4j-jdbc/src/test/java/org/apache/logging/log4j/jdbc/appender/JdbcAppenderH2FactoryMethodTest.java
index 6782639c0a..f9e3e8807d 100644
--- 
a/log4j-jdbc/src/test/java/org/apache/logging/log4j/jdbc/appender/JdbcAppenderH2FactoryMethodTest.java
+++ 
b/log4j-jdbc/src/test/java/org/apache/logging/log4j/jdbc/appender/JdbcAppenderH2FactoryMethodTest.java
@@ -25,7 +25,7 @@ public class JdbcAppenderH2FactoryMethodTest extends 
AbstractJdbcAppenderFactory
                 new JdbcRule(
                         JdbcH2TestHelper.TEST_CONFIGURATION_SOURCE_MEM,
                         "CREATE TABLE fmLogEntry ("
-                                + "id INTEGER GENERATED BY DEFAULT AS 
IDENTITY, eventDate DATETIME, literalColumn VARCHAR(255), "
+                                + "id INTEGER GENERATED BY DEFAULT AS 
IDENTITY, eventDate TIMESTAMP, literalColumn VARCHAR(255), "
                                 + "level NVARCHAR(10), logger NVARCHAR(255), 
message VARCHAR(1024), exception NCLOB, "
                                 + "anotherDate TIMESTAMP)",
                         "DROP TABLE IF EXISTS fmLogEntry"),
diff --git 
a/log4j-perf-test/src/main/java/org/apache/logging/log4j/perf/jmh/JdbcAppenderBenchmark.java
 
b/log4j-perf-test/src/main/java/org/apache/logging/log4j/perf/jmh/JdbcAppenderBenchmark.java
index 1a94240ef9..4b2412b374 100644
--- 
a/log4j-perf-test/src/main/java/org/apache/logging/log4j/perf/jmh/JdbcAppenderBenchmark.java
+++ 
b/log4j-perf-test/src/main/java/org/apache/logging/log4j/perf/jmh/JdbcAppenderBenchmark.java
@@ -175,7 +175,7 @@ public class JdbcAppenderBenchmark {
 
     private String toCreateTableSqlStringH2(final String tableName) {
         return "CREATE TABLE " + tableName + " ( "
-                + "id INTEGER GENERATED ALWAYS AS IDENTITY, eventDate 
DATETIME, literalColumn VARCHAR(255), level NVARCHAR(10), "
+                + "id INTEGER GENERATED ALWAYS AS IDENTITY, eventDate 
TIMESTAMP, literalColumn VARCHAR(255), level NVARCHAR(10), "
                 + "logger NVARCHAR(255), message VARCHAR(1024), exception 
NCLOB" + " )";
     }