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ËÄñ£¬ÎªÁ˱¸Íü°¡£¡£¡£¡£¡¹þ¹þ¹þ
Ïà¹ØÎĵµ£º
·½·¨Ò»£º½¨Ò»¸öÆ´Òô±í t_cosler £¬´æ·Åÿ¸ö×Öĸ¿ªÍ·µÄµÚÒ»¸öºº×ֵıàºÅºÍ×îºóÒ»¸öºº×ֵıàºÅ¡£
BatchFile code+------+--------+-------+
| f_PY | cBegin | cEnd |
+------+--------+-------+
| A | 45217 | 45252 | & ......
²ÎÕÕ : http://ubuntuing.javaeye.com/blog/65547
µÚ
Ò»²½£º°²×°pure-ftpdºÍpure-ftpd-mysql.
apt-get install pure-ftpd
apt-get
install pure-ftpd-mysql
µÚ¶þ²½£ºÐÞ¸Äpure-ftpdÁ´½ÓmysqlµÄÃÜÂë
vim
/etc/pure-ftpd/db/mysql.conf
ĬÈÏÅäÖãº
#MYSQLServer
localhost
#MYSQLPort& ......
ÉèÖÃMySQLÊý¾Ýͬ²½£¨µ¥Ïò&Ë«Ïò£©
ÓÉÓÚ¹«Ë¾µÄÒµÎñÐèÇó£¬ÐèÒªÍøÍ¨ºÍµçÐŵÄÊý¾Ýͬ²½£¬¾Í×öÁ˸öMySQLµÄË«Ïòͬ²½£¬¼ÇϹý³Ì£¬ÒÔºóÓõõ½ÔÙ·³öÀ´£¬Ò²Ìù³öÀ´¹©´ó¼Ò²Î¿¼¡£
Ò»¡¢×¼±¸·þÎñÆ÷
ÓÉÓÚMySQL²»Í¬°æ±¾Ö®¼äµÄ(¶þ½øÖÆÈÕÖ¾)binlog¸ñʽ¿ÉÄܻ᲻һÑù£¬Òò´Ë×îºÃµÄ´îÅä×éºÏÊÇMasterµÄMySQL°æ±¾ºÍSlaveµÄ°æ±¾Ïàͬ»òÕ߸üµÍ£¬Ma ......
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......