Implicitly casting bigint postgres datatytpe to Java Long

Question

I am using a native Query to obtain a list of bigint numbers which I then plan to iterate.

@Query(value="SELECT bigint_field FROM complex_innerquery", nativeQuery=true)
Collection<Long> getAllBigIntFieldValues();

If I use the Long datatype as shown above, it throws the following error

java.math.BigInteger cannot be cast to java.lang.Long

It seems like JPA converts bigint from database into BigInteger by default.

Clearly, BigInteger is a giant datatype compared to Long. Although, while storing, my field is of type Long in the entity defined and therefore, there is no chance of losing data while doing the conversion from BigInteger back to Long value, is there any other way by which I can get rid of BigInteger datatype? More specifically, I don't want the methods calling getAllBigIntFieldValues method to explicitly convert BigInteger to LongValue.

For rationale into why this happens, this question offers some insights. — Makoto
– Makoto, Commented Dec 11, 2017 at 18:29

Jens Schauder · Accepted Answer · 2017-12-12 10:56:13Z

3

You can't do this with Spring Data JPA mechanics.

The relevant part of the source code is JpaQueryExecution

It has a ConversionService and tries to use it to convert the query result to the required type:

if (void.class.equals(requiredType) || requiredType.isAssignableFrom(result.getClass())) {
    return result;
}

return CONVERSION_SERVICE.canConvert(result.getClass(), requiredType) //
        ? CONVERSION_SERVICE.convert(result, requiredType) //
        : result;

Unfortunately, there is no mechanism to add converters to this conversion service.

What you could do though is to use the power of SQL and convert the value in the select into something that will be offered as a Long by the underlying JDBC driver.

For example it should be possible in MySQL to convert the result to an UNSIGNED BIGINT and get a Long

Just noted you mentioned Postgres in the title. BIGSERIAL might be an option there.

edited Dec 12, 2017 at 10:56

answered Dec 12, 2017 at 10:26

Jens Schauder

82.6k35 gold badges199 silver badges379 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Implicitly casting bigint postgres datatytpe to Java Long

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related