I am trying to run copy command using mule db connector. I chose Bulk Execute Operation and mentioned the copy command to read the file and load to a table. I am facing the below exception.
Root Exception stack trace: java.sql.BatchUpdateException: Batch entry 0 COPY student (sname,uno ) FROM '/xx/xx/students.txt' DELIMITER ',' CSV was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2762)
Does mule support copy command?
Exception was because of read permissions issue on the file.