De-serialization issue while connecting to a database

[BibhuNayak]

Hi,

I have created a sample table in mysql and tried to create a form data model based on a schema-> table.

While trying to do testing for read and insert I get the following error.

While reading : Deserialization not allowed for class [Ljava.lang.String; (on Thu Jun 04 16:49:46 IST 2020)

While inserting :  {
"errorMessage": "java.lang.UnsupportedOperationException: Deserialization not allowed for class [Ljava.lang.String; (on Thu Jun 04 16:50:05 IST 2020)"
}

Please help.

Thanks,

Bibhu.

[Rakhi_Sukhadeve]

@BibhuNayak 

Please locate “DeserializationFirewallImpl” configuration under configMgr( http://<hostname>:<portno>/system/console/configMgr)  and add [ like below.

I hope this will help.

[BibhuNayak]

I have already added the below URLs. com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/mysql Can you please let me know what else need to be added?

[Rakhi_Sukhadeve]

@BibhuNayak I just want you to add "[" in the deserialization whitelist configuration(refer screenshot in previous comment) and save it.

[BibhuNayak]

@Rakhi_Sukhadeve I have already added. Still the same issue.

[Rakhi_Sukhadeve]

@BibhuNayak Please share the screenshot of “DeserializationFirewallImpl” configuration at your end.

[BibhuNayak]

I have already added the below URLs.

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/mysql

Can you please let me know what else need to be added?

[GirishBedekar]

• Whitelist sun.util.calendar package.
  • Open feilix web console in your browser window
  • Search and open Deserialization Firewall Configuration In the whitelist field add sun.util.calendar package and save

[BibhuNayak]

Hi Girish,

It's already there in whitelist.

[GirishBedekar]

Send the screen shot of your table and form data model

[BibhuNayak]

Please find the screenshots below.

[BibhuNayak]

@Rakhi_Sukhadeve PFB the screenshot.

[Rakhi_Sukhadeve]

@BibhuNayakPlease add the one highlighted in my screenshot.