LocalDate, LocalDateTime are not DATE, not TIMESTAMP

[KirillKurdyukov]

Based on the motives: spring-projects/spring-framework#28778

I conclude that LocalDate is a DATE sqlCode and LocalDateTime is a TIMESTAMP.
but in JdbcUtil:
https://github.com/spring-projects/spring-data-relational/blob/main/spring-data-jdbc/src/main/java/org/springframework/data/jdbc/support/JdbcUtil.java

I didn't quite understand what happened to these types?
I using 3.3.3 version, and have UNKNOWN type for LocalDateTime, Timestamp for LocalDate

PROPERTY TYPE: class java.time.LocalDate -> class java.sql.Timestamp -> TIMESTAMP
PROPERTY TYPE: class java.time.LocalDateTime -> class java.time.LocalDateTime -> UNKNOWN

[schauder]

Sorry, I have a hard time understanding what your question is.

This part:

And how to pass custom SQL code? Example Json
import java.sql.SQLType; - custom implementation type

doesn't seem to be related to the rest of the question at all, correct?
Please limit yourself to a single question per posting. Feel free to create multiple issues if there are problems.

Please provide a Minimimal Reproducable Example, preferable as a Github repository. Make sure to include the database, either as an in memory database or if that is not possible using Testcontainers.

[KirillKurdyukov]

Spring Data JDBC for LocalDate, LocalDateTime data types used SqlType TIMESTAMP и UNKNOW, I expect DATE and TIMESTAMP

JdbcUtil.java convertation:
PROPERTY TYPE: class java.time.LocalDate -> class java.sql.Timestamp -> TIMESTAMP
PROPERTY TYPE: class java.time.LocalDateTime -> class java.time.LocalDateTime -> UNKNOWN

https://github.com/spring-projects/spring-data-relational/blob/main/spring-data-jdbc/src/main/java/org/springframework/data/jdbc/support/JdbcUtil.java

Based on the motives: spring-projects/spring-framework#28778

[schauder]

Still, what is the actual problem? Does data get stored wrongly? Please provide a sample.

[spring-projects-issues]

If you would like us to look at this issue, please provide the requested information. If the information is not provided within the next 7 days this issue will be closed.

[KirillKurdyukov]

Hello!
I think this for classic set of databases, there is no problem. LocalDate or LocalDateTime was prepared JDBC drivers of vendors. I implemented org.springframework.data.relational.core.dialect.AbstractDialect for YDB.
I found that since java.time.LocalDate with JDBCType.TIMESTAMP in JDBC PreparedStatement.
The client expected a Date type in the table for LocalDate.
it's not critical, I've implemented

public record YQLType(PrimitiveType type) implements SQLType 

public @interface YdbType {
    String value();
}

public class YdbMappingJdbcConverter extends MappingJdbcConverter {
    public YdbMappingJdbcConverter(RelationalMappingContext context, RelationResolver relationResolver,
                                   CustomConversions conversions, JdbcTypeFactory typeFactory) {
        super(context, relationResolver, conversions, typeFactory);
    }

    @Override
    public SQLType getTargetSqlType(RelationalPersistentProperty property) {
        return property.isAnnotationPresent(YdbType.class) ?
                new YQLType(PrimitiveType.valueOf(property.getRequiredAnnotation(YdbType.class).value())) :
                super.getTargetSqlType(property);
    }
}

Problem is resolved

[schauder]

I don't think there is anything here to do for us.