QueryImpl.getMetaData() not implemented

Description

When attempting to use a Java library com.opencsv.CSVWriter 3.7's writeAll(ResultSet rs, boolean includeColumnNames) method I get the error

The library attempts to use the getMetaData() method but it was never implemented. This seems to be a part of the java.sql.ResultSet interface.

My guess is in the fillResult() method the QueryResult has a ResultSetMetaData returned by result.getMetaData(). It might be as easy as storing that into a class variable and returning it from the getMetaData() method.

Activity

Pothys - MitrahSoft 
8 May 2023 at 06:37

I've checked this ticket and Now query.getMetaData() method is supported in lucee version 6.0.0.387-SNAPSHOT.

Michael Offner 
5 May 2023 at 08:07

please give this a try

Michael Offner 
5 May 2023 at 08:07

Travis Peters 
6 May 2021 at 16:20

We need this as well and rather urgently. Please merge this in.

Tyler Clendenin 
30 April 2021 at 13:53
(edited)

What is the feared performance impact? The RecordSetMetaData is already being used in the fillResult method, this does nothing more than persist it and it seems like only a slight amount of duplication of data. An alternative is to implement the RecordSetMetaData similar to ACF with QueryTableMetaData, where it seems to implement all the methods and more that it’s Query implementation requires, but that mostly seems like overkill to prevent needing to have the list of column names twice in memory.

Fixed

Details

Assignee

Reporter

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Sprint

Affects versions

Priority

Created 22 April 2020 at 05:55
Updated 8 May 2023 at 06:37
Resolved 8 May 2023 at 06:37