Mule DB connector copy command

117 views Asked by At

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?

1

There are 1 answers

0
user94538 On

Exception was because of read permissions issue on the file.