Highlighted

De-serialization issue while connecting to a database

Avatar

Avatar

BibhuNayak

Avatar

BibhuNayak

BibhuNayak

04-06-2020

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.

Replies

Highlighted

Avatar

Avatar

Rakhi_Sukhadeve

Avatar

Rakhi_Sukhadeve

Rakhi_Sukhadeve

05-06-2020

@BibhuNayak 

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

Deserialization.PNG

I hope this will help.

Highlighted

Avatar

Avatar

BibhuNayak

Avatar

BibhuNayak

BibhuNayak

05-06-2020

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?

Highlighted

Avatar

Avatar

BibhuNayak

Avatar

BibhuNayak

BibhuNayak

05-06-2020

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?
Highlighted

Avatar

Avatar

GirishBedekar

Avatar

GirishBedekar

GirishBedekar

07-06-2020

  • 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
Highlighted

Avatar

Avatar

BibhuNayak

Avatar

BibhuNayak

BibhuNayak

07-06-2020

Hi Girish,

 

It's already there in whitelist.

 

BibhuNayak_0-1591595481953.png

 

Highlighted

Avatar

Avatar

GirishBedekar

Avatar

GirishBedekar

GirishBedekar

07-06-2020

Send the screen shot of your table and form data model

Highlighted

Avatar

Avatar

BibhuNayak

Avatar

BibhuNayak

BibhuNayak

07-06-2020

Please find the screenshots below.

 

error_2.jpgError_1.jpgFDM_2.jpgFDM_1.jpgTable.jpg

Highlighted

Avatar

Avatar

Rakhi_Sukhadeve

Avatar

Rakhi_Sukhadeve

Rakhi_Sukhadeve

08-06-2020

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

Avatar

Avatar

BibhuNayak

Avatar

BibhuNayak

BibhuNayak

18-06-2020

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