Hibernate + MYSQL½áºÏ´æ´¢ Blob ºÍ ClobÄÚÈÝ
½ñÌ죬ÕÛÌÚÁËÒ»¸öÏÂÎ磬ÖÕÓÚ½â¾öÁËHibernate ´æ´¢Blob×Ö¶Îʱ£¬Êý¾ÝÁ¿·Ç³£´óʱ×ÜÊDZ¨ can not update jdbc batchµÄ´íÎóÁË£¬ÔÀ´ÊÇMySQLÖÐûÓÐÉ趨×î´óÔÊÐíÖµËùÖ£¬ÎÒ»¹ÒÔΪÊÇHibernate²Ù×÷²»·ûºÏ±ê×¼²ÅÕâÑù¡£¡£¡£ºÇºÇ£¬ÔÚMysql 5.1ÖеÄmy.iniÅäÖÃÎļþÖмÓÈëÈçÏÂÉèÖãº
[MYSQL]
max_allowed_packet = XXXM (XXXΪ×î´óÖµ£¬MΪÕ×£¬Ò²¿ÉÒÔÓÃ1024*1024À´ÅäÖÃ)
ÕâÀï¼Ç¼ÏÂÀ´£¬ÒòΪÎÒÊDzËÄñ£¬ÎªÁ˱¸Íü°¡£¡£¡£¡£¡¹þ¹þ¹þ
Ïà¹ØÎĵµ£º
µÚÒ»ÖÖ·½·¨£º
rootÓû§µÇ¼ϵͳ
usr/local/mysql/bin/mysqladmin -u root -p password ÐÂÃÜÂë
enter password ¾ÉÃÜÂë
µÚ¶þÖÖ·½·¨£º
rootÓû§µÇ¼mysqlÊý¾Ý¿â
mysql> update mysql.user set password=password("ÐÂÃÜÂë")where User="root";
mysql> flush privileges;
mysql> quit ;
mysqlÍü¼ÇrootÃÜÂëÈçºÎ ......
µ±Ì¸µ½¿ªÔ´Êý¾Ý¿âʱ£¬MySQL»ñ
µÃÁËÒµ½ç´ó²¿·ÖµÄ×¢ÒâÁ¦£¬MySQLÊÇÒ»¸öÒ×ÓÚʹÓõÄÊý¾Ý¿â£¬Í¬Ê±ÓÐÐí¶à¿ªÔ´µÄWebÓ¦ÓóÌÐò¶¼ÊÇÖ±½ÓÔÚËüÉÏÃ濪·¢µÄ¡£
ÁíÍâÒ»ÖÖÖ÷ÒªµÄ¿ªÔ´Êý¾Ý¿âÊÇPostgreSQL£¬ËäÈ»ËüÒ²ÊÇÖÚËùÖÜÖªµÄ£¬µ«ÊÇȴûÓлñµÃÏñMySQLËùµÃµ½µÄÈÏ¿É¡£ÕâÊǺܲ»Ðҵģ¬ÒòΪÔÚÕâÁ½Õß
ÖУ¬Ïà±ÈMySQL£¬PostgreSQLÄÜÌṩ¸ü¼Ó°²È ......
ΪÁËÈÃÓû§²»ÐèÒª×Ô¼ºÔËÐÐmysql°²×°³ÌÐò°²×°mysqlÊý¾Ý¿â£¬Èí¼þ·¢²¼Ê±ÐèÒª´ò°üÃâ°²×°°æ±¾µÄmysql¡£´Ómysql¹ÙÍøÉÏÖ±½ÓÏÂÔصÄÃâ°²×°°æ±¾ÐèÒª¸÷ÖÖÅäÖã¬Èç¹ûÅäÖò»ºÃ£¬ºÜÈÝÒײúÉú¸÷ÖÖ¸÷ÑùµÄÎÊÌâ¡£ÓÈÆäÊÇ´íÎóÂëΪ1067µÄÎÊÌ⣬ÎÒÊÔÑéÁËÍøÉϵĺܶ෽·¨¶¼Ã»Æð×÷Óã¬×îºóÏëÁËÒ»¸ö×î¼òµ¥µÄ·½·¨£º
£¨1£©Ê×ÏÈʹÓð² ......
Èç¹ûÄãÊǸöÈü³µÊÖ£¬²¢ÇÒ°´Ò»Ï°´Å¥¾ÍÄܹ»Á¢¼´¸ü»»ÒýÇæ¶ø²»ÐèÒª°Ñ³µ¿ªµ½³µ¿âÀïÈ¥»»£¬ÄÇ»áÊÇʲô¸Ð¾õÄØ£¿MySQLÊý¾Ý¿âΪ¿ª·¢ÈËÔ±Ëù×öµÄ¾ÍºÃÏñÊÇ°´°´Å¥»»
ÒýÇ棻ËüÈÃÄãÑ¡ÔñÊý¾Ý¿âÒýÇ棬²¢¸øÄãÒ»Ìõ¼òµ¥µÄ;¾¶À´Çл»Ëü¡£
MySQLµÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸ÒâµÄ ......