- Summary:
Fix 110178: All report queries are being executed twice. (on behalf of Gary)
- Bugzilla Bug (s) Resolved:
110178: All report queries are being executed twice.
- Description:
For some database such as Oracle, its metadata can not be retrieved by
PreparedStatement#getMetaData. So ODA.JDBC driver has to get it by first
executing a query to get a ResultSet and then retrieve the metadata by
ResultSet#getMetaData. It will cause a query will be executed twice when
rending a report, the first time is to get the metadata and the second time it
to get the result set.
To avoid this problem, the ResultSet instance
generated in retrieving result metadata can be cached and reused for later
retrieving the result data. Another enhancement is that the metadata will be
also cached and reused when there is no any change for data source and data set
information.
- Tests Description:
Junit Test
- Files Edited:
/org.eclipse.birt.report.data.oda.jdbc/src/org/eclipse/birt/report/data/oda/jdbc/Statement.java
- Files Added:
N/A
- Notes to
Build Team:
N/A
- Notes to Developers:
N/A
- Notes to QA:
N/A
- Notes to
Documentation:
N/A