Query with character varying[]

[khanhpd2002]

Hi @kdhrubo,
I have an issue is when I store entity with type String[] and datatype in database is character varying[] and then query, it shows me error

WARN 1 --- [pg-ssl-extension] [omcat-handler-2] .m.m.a.ExceptionHandlerExceptionResolver : Failure in @ExceptionHandler com.homihq.db2rest.exception.GlobalExceptionHandler#handleGenericDataAccessException(GenericDataAccessException)
2024-05-13T04:32:44.007059160Z 
2024-05-13T04:32:44.007071715Z java.lang.IllegalStateException: Could not resolve parameter [0] in org.springframework.http.ProblemDetail

ERROR 1 --- [pg-ssl-extension] [omcat-handler-2] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.springframework.http.converter.HttpMessageConversionException: Type definition error: [simple type, class org.postgresql.core.v3.replication.V3ReplicationProtocol]] with root cause
2024-05-13T04:32:44.011013355Z 
2024-05-13T04:32:44.011024650Z com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class org.postgresql.core.v3.replication.V3ReplicationProtocol and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: java.util.ArrayList[0]->org.springframework.util.LinkedCaseInsensitiveMap["images"]->org.postgresql.jdbc.PgArray["resultSet"]->org.postgresql.jdbc.PgResultSet["statement"]->org.postgresql.jdbc.PgStatement["connection"]->org.postgresql.jdbc.PgConnection["queryExecutor"]->org.postgresql.core.v3.QueryExecutorImpl["replicationProtocol"])
2024-05-13T04:32:44.011031512Z 	at com.fasterxml.jackson.databind.exc.InvalidDefinitionException.from(InvalidDefinitionException.java:77) ~[jackson-databind-2.15.4.jar!/:2.15.4]

[kdhrubo]

@khanhpd2002 moving this as an issue

[grabdoc]

This problem has been resolved and will be available in release 1.0.0-GA soon.

Here is the PR - #572

[grabdoc]

Test table

`
CREATE TABLE player_colors (
id int8 PRIMARY KEY,
colors _varchar NULL
);

`

[grabdoc]

Insert Request

[grabdoc]

Select request

[grabdoc]

@khanhpd2002 - pls do share your feedback.

[kdhrubo]

@khanhpd2002 - closing this as the issue is now resolved.