Re: Incorrect string value: '\xAC\xED\x00\x05sr...' for column
Posted by: Filipe Silva
Date: December 29, 2018 04:43AM

Hi Karen,

I can't tell how your data looks like and what you want to do with it. But, if your data structure is something like:

<Person> ::= {
"name": "John Doe",
"subject": [
"subj_1",
"subj_2",
"subj_3"
]
}

and you want to store it in a MySQL table as:

---------------------------------------
Name | Subject
---------------------------------------
John Doe | subj_1
John Doe | subj_2
John Doe | subj_3


Your code could be something like:

Person m = new Person()
for (String s : m.getSubjects()) {
ps.setString(1, m.getName());
ps.setString(2, s);
ps.addBatch();
}
ps.executeBatch();


IHTH

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.