Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!

De-serialization issue while connecting to a database

Avatar

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.

12 Replies

Avatar

Employee

@BibhuNayak 

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

Deserialization.PNG

I hope this will help.

Avatar

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?

Avatar

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

Avatar

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

Avatar

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?

Avatar

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

Avatar

Level 2

Hi Girish,

 

It's already there in whitelist.

 

BibhuNayak_0-1591595481953.png

 

Avatar

Level 9

Send the screen shot of your table and form data model