Hi all,
I'm new to this list, and would like to post a question.
I have a database with one table with a TEXT field where we save HTML files.
This table is Updated and Selected from a Servlet Applicacion, using JDBC.
Some TEXTs have a size of arround 60Kb. For records with this size (or
arround, I haven't guessed the limit yet) I have an error trying to Insert
or Update the record. With smaller sizes I have no problem, and even if I
load the TEXT directly from the server with the "mysql" command, I have no
problem at all, and I can do the Selects with no problem regardless the size
from the Servlet application too.
The error I get in the MYSQL Log for the hosts is :
Aborted connection 2 to db: 'dbname' user: 'xxx;password' host:
`hostname.domain.com' (Got an error reading communication packets)
I'm using MySQL 3.23.37, the JDBC Driver is MM version 2.0.4, and I'm
running under RedHat Linux 6.0. I've tried all kind of tests with the
configuration parameters for the MySQL server and the problem continues (I
have 64 MB RAM, but the database is rather small, few tables and records,
but with this TEXT field).
Basically I use a configuration file similar to the one that comes with the
documentation (for medium size servers "my-medium.cnf") but with these
parameters touched for testing (with no results) :
set-variable = max_allowed_packet=16M
set-variable = net_buffer_length=16K
set-variable = connect_timeout=15
Can anybody give me a clue, of what may be wrong ? Do I need to upgrade the
Linux kernell, or touch some more MySQL parameters ?
Thanks in advance,
Florencia Vitale
mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
