- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ConvertJSONToSQL - Ignores underscore in update keys
- Labels:
-
Apache NiFi
Created on
‎03-22-2020
09:08 PM
- last edited on
‎03-22-2020
09:53 PM
by
ask_bill_brooks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Eg: Update table table_name emp_name=? where empid=?
But My column name is emp_id
Created ‎04-05-2020 11:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Finally fixed the issue by myself. have changed all the columns to Uppercase and made the Translate Field Names to false.. That works for me.
Created ‎04-05-2020 10:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Anybody has answer for this- I get this issue on PutDatabaseRecord as well. When I check java code of PutDatabaseRecord. I could see below replace with - underscore.
Created ‎04-05-2020 11:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Finally fixed the issue by myself. have changed all the columns to Uppercase and made the Translate Field Names to false.. That works for me.
Created ‎10-10-2024 06:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I set the Translate Field Names to false, it started working, before this it was converting the primary key field to upper case, removing the underscore, so when I run the putSQL, it was throwing error, working fine now, thanks to your answer!
