TIMESTAMP data type(oracle.sql) not support in Helidon SE 4.0.2

[MohanramGovindarasu]

TIMESTAMP data type mapper suport missing in Helidon SE 4.0.2

Environment Details

• Helidon Version: 4.0.2
• Helidon SE or Helidon MP: Helidon SE
• JDK version: JAVA 21
• OS: Windows/Linux
• Docker version (if applicable): N/A

---

Problem Description

I have created a DB column as Timestamp. I am making the API call to write the record in the DB, write call goes through fine. When i read the Timestamp value from the helidon application code, am i seeing mapper exception. If the DB column is created with DATE data type it works fine.

Steps to reproduce

Code Snippet:

import java.sql.Timestamp;

DbColumn dbColumn = dbrow.column(key.trim()); Timestamp value = dbColumn.get(Timestamp.class);

Issue is only observed when we read the value from dbcolumn for timestamp data type.(oracle.sql package)

Error message:

"io.helidon.common.mapper.MapperException: Failed to map class oracle.sql.TIMESTAMP to class java.sql.Timestamp: Failed to find mapper. Qualifiers: dbclient, source of class 'oracle.sql.TIMESTAMP'"