JDBC: In windows export/import SQL query produces an Base64 error
Details
| Detail name | Value |
|---|---|
| Changelog Number | 13079 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.1 |
| Fix Versions | Exasol 7.1.2 |
| Resolution Date | 2021-10-20 |
Description
When the following conditions are met, an IMPORT or EXPORT statement using a LOCAL CSV FILE will fail with the below error:
- You are using a Windows machine
- You are connected to the database using the 7.1.1 JDBC driver
- You run an IMPORT or EXPORT with a LOCAL CSV FILE
Error Message
SQL Error [42636]: java.sql.SQLException: ETL-5106: Following error occured while writing data to external connection [https://27.1.0.10:38607/7329e1ca-e038-40e6-9cf6-b27bdea4700f.gz failed after 0 bytes. [OpenSSL SSL_connect: SSL_ERROR_SYSCALL in connection to 27.1.0.10:38607 ],[35],[SSL connect error]] (Session: 1711095039912378368) while executing 'export dual into CSV AT 'https://27.1.0.10:38607' FILE '7329e1ca-e038-40e6-9cf6-b27bdea4700f.gz' ;'; 04509 java.sql.SQLException: java.io.IOException: Exception in connect: java.lang.IllegalArgumentException: Illegal base64 character a
Example
EXPORT (SELECT 1 FROM DUAL) INTO LOCAL CSV FILE 'C://TEMP/TESTDATA.CSV';
Workaround
Connect to the database using a different JDBC driver and retry the statement.
Fix
IMPORT and EXPORT statement using LOCAL CSV FILE will work as expected.
