Still i am getting the error :
Found some error : com.mysql.jdbc.PacketTooBigException: Packet for query is
too large (3859363 > 1048576). You can change this value on the server by
setting the max_allowed_packet' variable.
Exception in thread "main" com.mysql.jdbc.PacketTooBigException: Packet for
query is too large (3859368 > 1048576). You can change this value on the
server by setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2615)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2601)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1565)
at
com.mysql.jdbc.Connection.closeServerPreparedStatement(Connection.java:4613)
at
com.mysql.jdbc.ServerPreparedStatement.realClose(ServerPreparedStatement.java:1077)
at
com.mysql.jdbc.Connection.closeAllOpenStatements(Connection.java:2799)
at com.mysql.jdbc.Connection.realClose(Connection.java:2020)
at com.mysql.jdbc.Connection.close(Connection.java:1023)
at SaveImageToDatabase_final.main(SaveImageToDatabase_final.java:68)
And how to change the max_allowable_packet in mysql5.0 in windows or where
the configuration file is located
On Tue, Mar 9, 2010 at 10:18 AM, swamynathan <meswamy@xxxxxxxxx> wrote:
I am using mysql database for my ivrs project and i am using jsp
to insert data into mysql database
not a great idea actually, the file could be stored in a directory and the
location in database tus providing a similar operation
and now i can insert and retrive imageblob
into the database using blob datatype but i cannot insert mp3 into
datatype column its says error "Packet size exceeds".take a look at
http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html
--
with love from India,
swamy , wattabottles
http://meswamy.blogspot.com
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc