Inserting data into JSONB and UUID data type in the Postgres Database

The JSONB data type stores JSON (JavaScript Object Notation) data as a binary representation of the JSON value. We have the attached plugin to handle JSONB and UUID data format in Postgres Database. The attached plugin is used after the mapping and it looks at the fields that require jsonb and UUID data and properly handles the insert.

1. Use the attached plugin and copy paste the code from the attached file in the custom plugin.
2. Change the database connection info name and tablename:
1. In line no. 45: String databaseInfoName = "MyPostgresDBInfo";
2. Change the databaseInfoName to the database Info name of the entity corresponding to the database in the environment.
3. Change the Postgres schema name in line 46: String schemaName = "myschemaName";
4. Change the tablename in line 47: String tablename = "myTableName";
3. Enter the JSONB and UUID column names:
1. In line no. 48, enter the JSONB column name: String[] jsonColumnName = {"myjsonbfieldname"};
2. In case you have more than one jsonb column, you can simply add the column name with comma separator. For ex: String[] jsonColumnName = {"member","anotherJsonbColumn"};
3. In line no. 49, enter the UUID column name: String[] uuidColumnName = {"myUUIDfielldname"};
4. In case you have more than one UUID columns, you can simply add the column name with comma separator. For ex: String[] uuidColumnName = {"id","parentid"};
5. In mapping, do not filter the UUID columns, just leave them unmapped and the plugin will automatically generate the UUID values.
4. Run this plugin after mapping activity, and the data should be inserted into the database.