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ËÄñ£¬ÎªÁ˱¸Íü°¡£¡£¡£¡£¡¹þ¹þ¹þ
Ïà¹ØÎĵµ£º
¼ÌTwitterÖ®ºó£¬Éç½»ÐÂÎÅÍøÕ¾Digg¾ö¶¨¸úMySQL˵ÔÙ¼û£¬²¢Ìæ»»µôËüµÄ´ó²¿·Ö»ù´¡ÉèÊ©×é³É£¬Digg½«´ÓLAMP£¨Linux¡¢ Apache¡¢MySQLºÍPerl/PHP/Python£©¼Ü¹¹Ç¨ÒƵ½»ùÓÚCassandraµÄNoSQL¼Ü¹¹¡£
¡¡¡¡Apache CassandraÊÇÒ»Ì׿ªÔ´·Ö²¼Ê½Êý¾Ý¿â¹ÜÀíϵͳ£¬×î³õÓÉFacebook¿ª·¢£¬ÓÃÓÚ´¢´æÌرð´óµÄÊý¾Ý¡£Cassa ......
·½·¨Ò»£º½¨Ò»¸öÆ´Òô±í 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& ......
ǰע£º¶ÔÓÚÕë¶Ô×Ö·û´®Î»ÖõIJÙ×÷£¬µÚÒ»¸öλÖñ»±ê¼ÇΪ1¡£
ASCII(str) ·µ»Ø×Ö·û´®strµÄ×î×óÃæ×Ö·ûµÄASCII´úÂëÖµ¡£Èç¹ûstrÊÇ¿Õ×Ö·û´®£¬·µ»Ø0¡£Èç¹ûstrÊÇNULL£¬·µ»ØNULL¡£
mysql> select ASCII('2');
-> 50
mysql> select ASCII(2);
-> 50
mysql> select ASCII('dx');
-> 1 ......
µ±Ì¸µ½¿ªÔ´Êý¾Ý¿âʱ£¬MySQL»ñ
µÃÁËÒµ½ç´ó²¿·ÖµÄ×¢ÒâÁ¦£¬MySQLÊÇÒ»¸öÒ×ÓÚʹÓõÄÊý¾Ý¿â£¬Í¬Ê±ÓÐÐí¶à¿ªÔ´µÄWebÓ¦ÓóÌÐò¶¼ÊÇÖ±½ÓÔÚËüÉÏÃæ¿ª·¢µÄ¡£
ÁíÍâÒ»ÖÖÖ÷ÒªµÄ¿ªÔ´Êý¾Ý¿âÊÇPostgreSQL£¬ËäÈ»ËüÒ²ÊÇÖÚËùÖÜÖªµÄ£¬µ«ÊÇȴûÓлñµÃÏñMySQLËùµÃµ½µÄÈϿɡ£ÕâÊǺܲ»Ðҵģ¬ÒòΪÔÚÕâÁ½Õß
ÖУ¬Ïà±ÈMySQL£¬PostgreSQLÄÜÌṩ¸ü¼Ó°²È ......