After having a quick overview in NoSQL DB, a natural thought was
How can
sql="insert into table(col1,col2,jsoncol) values(?,?,(?::JSON))";
pstmt = con.prepareStatement(sql);
pstmt.setString(1, '');
pstmt.setString(2, '');
pstmt.setString(3, jsondata.toJSONString().replaceAll("\\\\/","/"));
pstmt.executeUpdate();
pstmt = con.prepareStatement(sql);
pstmt.setString(1, '');
pstmt.setString(2, '');
pstmt.setString(3, jsondata.toJSONString().replaceAll("\\\\/","/"));
pstmt.executeUpdate();
?::JSON like this
select data::JSON from table_name
works for Informix DB alone.