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 <[email protected]> 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 image
> > into the database using blob datatype but i cannot insert mp3 into
> blob
> > 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
>
--
राजकुमार
follow me
http://twitter.com/krisrajkumar
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
