Databricks Community

EricCournarie

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 Cannot resolve "infos" due to data type mismatch: cannot cast "STRING" to "STRUCT<AGE: BIGINT, NAME: STRING>"....

EricCournarie

Hello, using the JDBC driver, when I retrieve the metadata of a ResultSet, the type for a TIMESTAMP_NTZ is not correct (it's a TIMESTAMP one).My SQL is a simple SELECT * on a table where you have a TIMESTAMP_NTZ columnThis works when retrieving metad...

EricCournarie · 10-16-2024

Hello,Using the JDBC Driver , when I check the metadata of a result set, when retrieving the column name, it's the column type that is given . Here what it looks like in the meta data . Using version 2.6.40, with the query SELECT "id" string, "year" ...

EricCournarie · 09-24-2024

Hello,Using the JDBC Driver , when I check the metadata of a prepared statement, the column names names are all uppercase . This does not happen when running a DESCRIBE on the same select. Any properties to set , or it is a known issue ? or a workaro...

EricCournarie

Yes, I was using the latest driver version

EricCournarie

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> )

EricCournarie

Hello, I did try switching to the OSS version , but it does not fix my problemThanks for your help anyway

EricCournarie

Hi, thanks for the response !ok,as it was working on table metadata, I thought the doc was not up to date.. so it's partially supported. do you know if there is any chance it will be fully supported in some 'near' future ?Thanks

EricCournarie · 10-16-2024

forget about it, the select clause is wrong of course .. too tired I guess sorry

Databricks Community

User Stats

User Activity

Filling a STRUCT field with a PreparedStatement in JDBC

ResultSet metadata does not return correct type for TIMESTAMP_NTZ

With the JDBC Driver, ResultSet metadata gives the column type as column name

Metadata on a prepared statement return upper case column names

Re: ResultSet metadata does not return correct type for TIMESTAMP_NTZ

Re: Filling a STRUCT field with a PreparedStatement in JDBC

Re: ResultSet metadata does not return correct type for TIMESTAMP_NTZ

Re: ResultSet metadata does not return correct type for TIMESTAMP_NTZ

Re: With the JDBC Driver, ResultSet metadata gives the column type as column name