Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

De-serialization issue while connecting to a database

BibhuNayak
Level 2
Level 2

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.

0 Replies
Rakhi_Sukhadeve
Level 2
Level 2

@BibhuNayak 

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

Deserialization.PNG

I hope this will help.

BibhuNayak
Level 2
Level 2
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
Level 2
Level 2
@BibhuNayak I just want you to add "[" in the deserialization whitelist configuration(refer screenshot in previous comment) and save it.
Rakhi_Sukhadeve
Level 2
Level 2
@BibhuNayak Please share the screenshot of “DeserializationFirewallImpl” configuration at your end.
BibhuNayak
Level 2
Level 2

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
Level 9
Level 9
  • 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
Level 2
Level 2

Hi Girish,

 

It's already there in whitelist.

 

BibhuNayak_0-1591595481953.png

 

GirishBedekar
Level 9
Level 9

Send the screen shot of your table and form data model