AW: [opencms-dev] max_allowed_packet

[Le Tuan]

max_allowed_packet is a parameter of mysql.

You can set this parameter to a more higher value.

examples:

Windows
=======
 <mysql-directory>\bin\mysqld-opt --set-variable max_allowed_packet=4194304

Linux
=====

In the etc/my.cnf file you can can the parameter max_allowed_packet=4194304


Mit freundlichen Gru?en

i.A. Tuan Le
IT-Consultant
____________________________________________


comundus Unternehmensberatung GmbH
Schuttelgrabenring 3, 71332 Waiblingen

Tel:    +49 (0) 71 51-5 00 28-0   Fax: -99

www.comundus.com <http://www.comundus.com>
www.comundus-e-quality.com <http://www.comundus-e-quality.com/>
____________________________________________


-----Ursprungliche Nachricht-----
Von: opencms-dev-admin at opencms.org [mailto:opencms-dev-admin at opencms.org]Im
Auftrag von Alex V Londkevich
Gesendet: Donnerstag, 24. April 2003 15:53
An: [opencms-dev]
Betreff: [opencms-dev] max_allowed_packet


I can not import a bigsize file.
I use Tomcat 4.0.6
I did not find parametr "max_allowed_packet" in tomcat settings
(server.xml);
What must I do?

i get  errors :


Importing /kupol/client/doc/kupol-price-vent.rtf Exception
java.lang.IllegalArgumentException: Packet is larger than
max_allowed_packetmax_allowed_packet from server configuration of 1047552
bytes
at com.mysql.jdbc.Buffer.ensureCapacity(Unknown Source)
at com.mysql.jdbc.Buffer.writeBytesNoNull(Unknown Source)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
at
com.opencms.dbpool.CmsPreparedStatement.executeUpdate(CmsPreparedStatement.j
ava:176)
at
com.opencms.file.genericSql.CmsDbAccess.createFileContent(CmsDbAccess.java:1
2640)
at
com.opencms.file.genericSql.CmsDbAccess.createResource(CmsDbAccess.java:1406
)
at
com.opencms.file.genericSql.CmsResourceBroker.createResource(CmsResourceBrok
er.java:1986)
at com.opencms.file.CmsObject.doCreateResource(CmsObject.java:1061)
at
com.opencms.file.CmsResourceTypePlain.importResource(CmsResourceTypePlain.ja
va:404)
at com.opencms.file.CmsObject.importResource(CmsObject.java:2171)
at com.opencms.file.CmsImport.importResource(CmsImport.java:487)
at com.opencms.file.CmsImport.importResources(CmsImport.java:609)
at com.opencms.file.CmsImport.importResources(CmsImport.java:526)
at
com.opencms.file.genericSql.CmsResourceBroker.importResources(CmsResourceBro
ker.java:4147)
at com.opencms.file.CmsObject.importResources(CmsObject.java:2197)
at
com.opencms.workplace.CmsAdminDatabaseImportThread.run(CmsAdminDatabaseImpor
tThread.java:79)
_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev