Comments (3)
If you would like us to spend some time helping you to diagnose the problem, please spend some time describing it and, ideally, providing a minimal yet complete sample that reproduces the problem.
You can share it with us by pushing it to a separate repository on GitHub or by zipping it up and attaching it to this issue.
from spring-data-jpa.
Sure, I will provide more details:
in my PostgreSQL database I store posts. One of the columns is created_at
which is of type timestamptz
. For this in Spring Boot I have entity class with projection class:
interface PostProjection {
// Other functions
@JsonProperty("createdAt")
@JsonFormat(pattern = "yyyy-MM-dd'T'HH:mm:ss.SSSSSSX")
fun getCreated_at(): OffsetDateTime
}
@Entity
@Table(name = "posts")
data class Post(
// Other variables
@NotBlank
@JsonFormat(pattern = "yyyy-MM-dd'T'HH:mm:ss.SSSSSSX")
val createdAt: OffsetDateTime = OffsetDateTime.now()
)
To get the data from the database I use repository interface:
@Repository
interface PostRepository : JpaRepository<Post, Long> {
@Query(
value = "SELECT p.* " +
"FROM posts AS p " +
"LEFT JOIN users AS u ON p.user_id = u.id " +
"GROUP BY p.id ",
countQuery = "SELECT COUNT(*) " +
"FROM posts AS p " +
"LEFT JOIN users AS u ON p.user_id = u.id " +
"GROUP BY p.id ",
nativeQuery = true
)
fun <T> findPosts(
cursorBasedPageable: CursorBasedPageable<T>,
pageable: Pageable
): Page<Post>
@Query(
value = "SELECT p.*, SUM(u.reporting_score) " +
"FROM posts AS p " +
"LEFT JOIN users AS u ON p.user_id = u.id " +
"GROUP BY p.id ",
countQuery = "SELECT COUNT(*) " +
"FROM posts AS p " +
"LEFT JOIN users AS u ON p.user_id = u.id " +
"GROUP BY p.id ",
nativeQuery = true
)
fun <T> findPostsWithReportingScore(
cursorBasedPageable: CursorBasedPageable<T>,
pageable: Pageable
): Page<PostProjection>
}
When I call findPosts()
function I do receive all information, including created_at
field which in database is stored as shown below (one of the examples):
The Spring JPA generates the following JSON response (one of the examples):
"createdAt": "2024-03-26T16:10:07.688571Z",
, which is correct.
Now when I call findPostsWithReportingScore()
function I receive a warning: Resolved [org.springframework.http.converter.HttpMessageNotWritableException: Could not write JSON: Cannot project java.time.Instant to java.time.OffsetDateTime; Target type is not an interface and no matching Converter found]
.
from spring-data-jpa.
Returning Instant
is a consequence of Hibernate's TimestampUtcAsJdbcTimestampJdbcType
class that converts Timestamp
values into Instant
.
Spring Data uses tuple-queries to provide data for interface projections hence we have to rely on the types that Hibernate provides to us.
With the source value being Instant
we do not have sufficient information to convert the value into OffsetDateTime
.
from spring-data-jpa.
Related Issues (20)
- 3.2.x Auditing behavior fails with composite keys using @IdClass but succeeds with @Embeddable HOT 3
- Unexpected Quoting on Column Name after Spring Boot 3 Migration HOT 3
- findById ignores @SQLRestriction annotation when performed in the same transaction as the save HOT 8
- The getId method was not called HOT 2
- Upgrade to Hibernate 6.5.1 HOT 1
- Remove duplicate plugin setup from parent pom.
- Invalid value for NanoOfSecond between 12am and 1am HOT 2
- Sorting of Pageable.unpaged(sort) is ignored by JPA Repository HOT 2
- Different `property` is used in `Sort.Order` method HOT 2
- Upgrade to Hibernate 6.2.25.Final
- Upgrade to Hibernate 6.4.8.Final
- Release 3.2.7 (2023.1.7)
- Release 3.3.1 (2024.0.1)
- Release 3.4 M1 (2024.1.0)
- 3.2.5 - Issue with dropping unexisting tables with ddl-auto=create HOT 1
- Upgrade to Jakarta Persistence 3.2
- Can I use global query comment instead `@QueryHint` or `@Meta`? HOT 2
- Specification using enum values does not follow `@Enumerated(EnumType.STRING)` and tries to convert it to smallint HOT 2
- Performance is slow when the query is like below (have in condition) and access on last page with large data HOT 3
- @Version column seems to cause JPA to delete subsequent inserts HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from spring-data-jpa.