writeAll(Rs,True) -- with Query having where condition and specific columns
Brought to you by:
aruckerjones,
sconway
hi Team,
I am using OpenCSV.writeAll(rs,boolean) value to generate the CSV file.
I am facing a strange issue, as below
able to write the resultSet into file when the resultSet was from Query (Select * from tablename), when the query is modified with where clause or specific columns, resultSet is getting written into csv file.
for eg: when the resultSet is based on the query like select * from table where col1="abc" or
select col1 from table or Select col1, col3 from table where col1="Asd"
Request you to kindly help me in resolving the same. as i have tight timelines.
Thanks in Advance,
Regards,
Vinay
please cancel the ticket, by additng writer.close() has resolved the issue.
Coolness! I am glad you were able to find the fix for the issue.
Regards
Scott Conway