cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nikita Timofeev (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CAY-2360) MySQ: BLOB or CLOB more than 4Mb cause exception
Date Tue, 05 Sep 2017 13:44:00 GMT

    [ https://issues.apache.org/jira/browse/CAY-2360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16153655#comment-16153655
] 

Nikita Timofeev commented on CAY-2360:
--------------------------------------

Here is research result:
this is hard limit that we unable to overcome at Cayenne side, it should be managed exactly
as said in exception: by adjusting {{max_allowed_packet}} server variable.

And a side note, we can switch MySQL {{CharType}} and {{ByteArrayType}} to use clob and blob
respectively.

> MySQ: BLOB or CLOB more than 4Mb cause exception
> ------------------------------------------------
>
>                 Key: CAY-2360
>                 URL: https://issues.apache.org/jira/browse/CAY-2360
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Database integration
>         Environment: MySQL
>            Reporter: Nikita Timofeev
>            Assignee: Nikita Timofeev
>            Priority: Minor
>
> This one is from community.
> When trying to write large BLOB or CLOB into MySQL db following exception is thrown:
> {noformat}
> com.mysql.jdbc.PacketTooBigException: Packet for query is too large (5347806 > 4194304).

> You can change this value on the server by setting the max_allowed_packet' variable.
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message