How to delete/update a specific record using relational database integration service?

HCL Volt MX Volt MX Forum
1
This thread was migrated from an old forum. It may contain information that are no longer valid. For further assistance, please post a new question or open a support ticket from the Customer Support portal.

I have created a relational database integration service. In that I have four operations -> create, get, delete and update. Create and get are working as expected but when I try to delete/update a specific record, All the records are getting deleted/updated.

2

HI @Mvhv Mowin​ ,

Kindly check whether primary key field exist in that particular table or not. If is not , then kindly update the table with the primary key field. Then recreate service with the same table and Test it.

Note:-

I also faced same issue, after updating table with primary key field. It working fine for me.

Regards,

3

Hi @Vasanth Kumar RameshKumar​ ,

After applying the changes suggested by you, the delete and update are now working as expected. Thank you.

4

Hi @Mvhv Mowin​

I am trying to to created a relational database integration service, i.e (integrate an MySQL database in Mobile Fabric), however I keep getting this error (attached), any help , Many thanks

**Image removed for security reasons**

5

Hi @Jvne Lvngdon​ ,

You have entered localhost as connection URL in the cloud environment, so the connection is failing.

In the database connection URL please provide your mysql server address instead of localhost.

Please check after changing the configuration.

Regards,

6

Hi @Michvel MvcLeod​

Thanks for your reply.

I tried to do this (changing the connection url to the server address) but still getting the same error.

I think I need to install JDBC driver, Do you know how to do this?

Many thanks.

7

Hi,

I am still having the same error.

Does this error have anything to do with:

1-JDBC driver?

2-Test environment selection in Kony Fabric?

3-Type of server: I used MAMP server for building the Mysql database.

Please help.

Thanks.

@Twvcey Rvndvll​

@Michvel MvcLeod​

@Adwivn Russell​

@Jvne Dickens​

8

Hi - there is no driver required for this operation. Can you please make sure your DB is accessible from external IP addresses (for example - can you ping this DB from home without VPN)? This operation should work if that is the case. Please also share a screenshot with the updated address.