asked on November 16, 2018
I have a simple program that connects a flexmonster pivot table to an Oracle database. In the table, the data for the given column is wrong. I debugged the response from the compressor and saw that there is an extra field in the header of the oscv stream. The field is the first field whose value is "+,". This is the root of my problem. Is this a known issue or is there some config I missed.I attached a portion of the oscv stream to illustrate the issu
⋅ November 19, 2018
Hello Paul,
Thank you for writing. The described issue is not a known one.
Could you please specify what server-side technology you are using for connecting to the Oracle database?
Also, it would be nice to have a sample of Oracle table with the sample data for reproducing the issue.
Waiting to hear from you.
Regards,
Dmytro
⋅ November 19, 2018
Server side web application : Ubuntu, Apache, PHP
Database : Oracle12 , hosted by our IT department. I have no idea what the hosting env is.
The csv file I uploaded is a sample of the Oracle table data. The data is correct, the header produced by compressor isn't.
I was able to reproduce this with a trival table
ID NAME
1 foo
2 bar
and got back this result...as you can see, the +, is superfluous and the header is missing the second column.
___ocsv2___2.6.6/2.213
+,+ID
1,foo
2,bar
⋅ November 20, 2018
Hello Paul,
Thank you for your prompt response.
We are going to investigate the issue and fix it, ETA Dec 17.
Could you please also specify which one of PHP compressor methods you were using for compression?
That will be very helpful in our further investigation.
Waiting for your feedback.
Regards,
Dmytro
⋅ December 19, 2018
Hello, Paul,
We are glad to inform you that the new version of the component is already available on our website.
The issue with PHP Data Compressor when connecting to Oracle databases was fixed.
You are welcome to update the component and PHP Data Compressor.
Regards,
Tanya
