How big is the text?
On May 18, 5:34 am, Berti wrote:
> I am trying to insert the body of an email message in a SQLite3
> databse.
>
> But I get the error message:
>
> DataError: String or BLOB exceeded size limit
>
> I have declared the database field as text. If i declare it as string,
> the bo
The text size that actually causes the error is 1078 characters. I am
running a loop and inserting the whole mailbox with about 400 messages
into a database. At a specific number, in this case it is 97, the loop
stops by producing the error. I can delete that message from the
mailbox but than it is
I think the problem may be with how much can be done in a single
transaction.
try db.commit() after each insert.
On May 18, 10:27 am, Berti wrote:
> The text size that actually causes the error is 1078 characters. I am
> running a loop and inserting the whole mailbox with about 400 messages
> int
oh really - I didn't realize that would ever be a problem. Is it
practical to have the DAL auto-commit before too much data is built
up?
On May 19, 1:49 am, mdipierro wrote:
> I think the problem may be with how much can be done in a single
> transaction.
> try db.commit() after each insert.
>
I do not know that is the problem. I am making a guess. Autocommit is
not a good idea. Programmers should control when to commit.
On May 18, 7:19 pm, Richard wrote:
> oh really - I didn't realize that would ever be a problem. Is it
> practical to have the DAL auto-commit before too much data is
Thanks, but db.commit() didnt help.
I think there is a limit to the whole database. Do you have
information about that?
I tried to cut the string to insert for 10 characters. Now it stops at
an other point, about 400 messages later and I get the following
error. I cannot sort that out.
Traceback (most recent call last):
File "/Applications/web2py/gluon/restricted.py", line 178, in
restricted
exec ccode in env
8 matches
Mail list logo