topic Re: Filling a STRUCT field with a PreparedStatement in JDBC in Data Engineering

Filling a STRUCT field with a PreparedStatement in JDBC

EricCournarie — Thu, 09 Oct 2025 14:44:02 GMT

Hello,

I'm trying to fill a STRUCT field with a PreparedStatement in Java by giving a JSON string in the PreparedStatement.

But it complains

it works with ARRAY, but not with STRUCT

Did I miss something, or should it be done in another way ?

Thanks in advance.

szymon_dybczak — Thu, 09 Oct 2025 15:03:42 GMT

Could you provide a sample of JSON string along with a code you're using? Otherwise it will be hard for us to help you.

EricCournarie — Thu, 09 Oct 2025 15:17:06 GMT

Of course . The JSON looks like

{
  "age" : 18,
  "name" : "Erquy"
}

and I'm using the setString method of a java.sql.PreparedStatement

( for a table defined with STRUCT<age: INT, name: STRING> )