Parsing issue while executing insert query in Mendix - External database connector - SQL

0
Hello,   I have tried to integrate the SQL using external database connector module in Mendix 10.11.0 studio pro. I am trying to insert the data in to the table in SQL database as per the process of using insert query but I couldn't able run the application and I could see the above error.   Reference:       Kindly check and give the proper solution. Thank You. 
asked
2 answers
0

Hi Prasad 

Can you share the external database table and its properties 

Also share the full insert query

answered
0

This is a known issue in the Mendix 10.11 version.

If you need to use the insert query in the same version then install Database Connector version 6.0.3 from Marketplace Module and use the Execute Statement java action in the microflow.

Create a string variable and update the query string inside the variable in below format 

'INSERT INTO SAMPLE_TABLE (    COL1,    COL2 ) VALUES (    ''' + $COL1 + ''',     ''' + $COL2 + '''              )'

Then execute this statement and this will work.

 

Hope this works 

answered