I've used Import CSV to database smart services and configured the parameters. But when I debug, it throws "java.lang.ClassCastException: org.apache.naming.NamingContext cannot be cast to javax.sql.DataSource" error.
Can someone pls help me the step by step guide how to configure the below 2 smart services. I assume, I am missing some configs.
1. Import CSV to Database
2. Import Excel to Database
You have to use the "Data Source" name in your Datastore(this is the drop down that you select to define your Database - connection ).
See the attached image.
It means your file has fewer columns than mentioned in the smart service. Please check your file column count and what you have configured for "columns to read in a row" in the smart service. Sometimes if there is accidentally a space entered in the column adjacent, it will also causes this error.
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.