R
ruuram
Guest
I'm trying to insert a string with 343 as length in to the database table. The field type is memo. As far as I know, it should be able to accomodate a long string. When I tried to enter it by typing the string directly into Access table, it did work. I don't what's wrong with it and has been struggling with it for 2 days. Any advice will be helpful! Thanks!
The query is:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
PreparedStatement insertgen = con.prepareStatement(
"insert into FormGeneral(formURL, method) values(?,?)");
insertgen.setString(1, url);
insertgen.setString(2, m);
insertgen.executeUpdate();
insertgen.close();
The run time error I got:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
in insert SQLException: [Microsoft][ODBC Microsoft Access Driver]String data, ri
ght truncated (null)
The query is:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
PreparedStatement insertgen = con.prepareStatement(
"insert into FormGeneral(formURL, method) values(?,?)");
insertgen.setString(1, url);
insertgen.setString(2, m);
insertgen.executeUpdate();
insertgen.close();
The run time error I got:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
in insert SQLException: [Microsoft][ODBC Microsoft Access Driver]String data, ri
ght truncated (null)
