We are doing a proof-of-concept of HXTT Excel (Trial Version) using Visual Composer and on SAP NetWeaver CE 7.11.
When we run a "select *" query against a sample Excel file, only data from the first column of the table is returned, even though there are multiple columns in the table.
We are aware that the trial version limits the result set to 100 lines. Does the trial version also have a limit regarding the number of columns that can be returned?
What would explain the problem we are having in not being able to read more than a single column in our Excel database table?
Thank you, in advance, for your help.
That issue should not happen. Please email firstname.lastname@example.org your Excel file sample.
No issue. So please check your jdbc setting.
select * from ZCALMONTH_PYG.ZCALMONTHPYG
CALMONTH INTEGER 11 10 0
NBJOUR BIGINT 20 0 0
The total row number of resultset: 2412
Hello HXTT Support,
The issue has been resolved. It would appear that our application is not able to process BIGINT columns. That is why the second column was not appearing in our result sets.
Thank you for your help!