Hi,
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
Reg/Mp
Discussion posts and replies are publicly visible
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.
Hi Thoufiq,
I am getting ???Incorrect syntax near ','.??? error. There is no comma delimiter in my excel file. I have exact same column names defined in CDT and SQL table. Any idea?