How to insert custom field data(in create issue screen) into a table in external database?

[Anuradha Gopalan]

I have a custome field called ' total no of leaves' in issue screen, need to insert this value into a table in external database. I used jira-database-values-plugin, it works perfectly for select queries but throwing '[jira.plugin.databasevalues.DatabaseRowCache] Can not issue data manipulation statements with executeQuery()' for insert query. Can any one please suggest me how to insert data?

[Nic Brough -Adaptavist-]

The database fields are for reading external databases into Jira fields. Not poking data into remote databases.

You'll need to code something to update external data.

[Anuradha Gopalan]

Thanks for the reply :-)