dominoÁ¬½Ómysql²åÈëÖÐÎÄÄÚÈݳöÏÖÂÒÂëµÄ½â¾ö·½°¸
½üÈÕ£¬ÓÐÒ»¸öÏîÄ¿ÐèҪͨ¹ýOAϵͳ£¨Dominoƽ̨£©ÏòÒ»¸öMySQLÓ¦ÓòåÈë¼Ç¼£¬ÒòΪƽ̨ÊÇwindowsƽ̨£¬ËùÒÔ²ÉÓÃÁËODBCÁ¬½Ó·½Ê½£¬ÔÚOA·þÎñÆ÷Éϰ²×°ÁËMyODBC-3.51.11-1Çý¶¯£¬ÅäÖÃÁËODBCÇý¶¯Êý¾ÝÔ´Ö®ºó£¬²åÈë¼Ç¼³É¹¦£¬µ«²»ÂÛÊDzåÈëÖÐÎÄÄÚÈÝ£¬»¹ÊÇ´ÓMySQLÖжÁÈ¡ÖÐÎÄÄÚÈÝ£¬¶¼ÊÇÂÒÂ룬ÔÚÍøÉϲéÔÄÁ˸÷ÖÖ×ÊÁÏ£¬³õ²½ÅжϿÉÄÜÊÇ×Ö·û¼¯µÄÔÒò£¬Domino²ÉÓõÄÊÇgb2312£¬MySQL²ÉÓõÄÊÇgbk£¬Á½ÖÖ²»Í¬×Ö·û¼¯µ¼ÖÂÖÐÎÄÂÒÂëÎÊÌ⣬ÏÖÔÚÀ´¸ü¸ÄÁ½ÖÖÊý¾Ý¿âµÄ×Ö·û¼¯ÊDz»ÏÖʵµÄ£¬Ö»ºÃÔÚÆäËû·½ÃæÕÒ½â¾ö°ì·¨¡£
DominoµÄODBCÁ¬½Ó·½Ê½ÔÚconnecttoµÄʱºòÊDz»ÄÜÖ¸¶¨×Ö·û¼¯µÄ¡£ÔÚÍøÉÏËÑË÷×ÊÁÏÖ®ºó£¬·¢ÏÖ¿ÉÒÔÔÚMYODBCÇý¶¯ÉÏÅäÖòÎÊý£¬´ïµ½¸øMySQLÊý¾Ý¿âÖ¸¶¨×Ö·û¼¯µÄ¹¦ÄÜ¡£ÅäÖÃÈçÏ£º
ÕâÀï×¢Ò⣬һ¶¨ÒªÔړϵͳDSN”ÖÐÅäÖ㬿ªÊ¼ÎÒÔÚ“Óû§DSN”ÖÐÅäÖÃÎÞЧ¡£
ÔÚ“Connect Options”Ñ¡ÏÖеēInitial Statement”ÖÐÊäÈëÈçÏÂÓï¾ä£ºset names gb2312
ÕâÌõÓï¾ä¾ÍÊÇÇ¿ÖÆ½«MySQLµÄ×Ö·û¼¯Éè³Égb2312¡£
ÖÁ´Ë£¬ÂÒÂëÎÊÌâ½â¾ö¡£OK£¡£¡£¡
Ïà¹ØÎĵµ£º
1.Ê×ÏÈ£¬ÉèÖÃÊý¾Ý¿âÖ§³ÖÖÐÎÄgb2312/gbk¡£
¾ßÌå·½·¨£º
´ò¿ªmySQLÎļþ¼Ð£¬ÐÞ¸Ämy.iniÅäÖÃÎļþ¡£
[client]
port=3306
default-character-set=gb2312
ÒÔ¼°
[mysqld]쵀
default-character-set=gb2312
Ð޸쬱£´æ£¬ÖØÆô¡£ÈôÉèΪSystem·þÎñ£¬¿ÉÒÔÔÚ¿ØÖÆÃæ°å-¹ÜÀí¹¤¾ß-·þÎñÖÐÕÒµ½mySQL·þÎñ£¬ÖØÆô¡£
2.±£Ö¤Web ......
Ò»¡¢×ܽáһϣº
1.LinuxϵͳÏÂÆô¶¯MySQLµÄÃüÁ
mysqladmin start
/etc/init.d/mysql start (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
2.linuxÏÂÖØÆômysqlµÄÃüÁ
mysqladmin restart
/etc/init.d/mysql restart (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
3.linuxϹرÕmysqlµÄÃüÁ
mysqladmin shutdown
/etc/init.d/mysql shutd ......
The MySQL 5.0 Archive Storage Engine
http://dev.mysql.com/tech-resources/articles/storage-engine.html
ÌØµã£º
1.²»Ö§³ÖÈκÎË÷Òý£¬µ«Ê¹Óòéѯ»º´æ
2.¸ù¾Ýmysql¹¤³ÌʦµÄ˵·¨£¬µ±±í´óС´ïµ½1.5Gʱ£¬±íɨÃèarchiveʱ¼äÉÙÓÚmyisam±í
3.Èç¹ûÄãÏë¸Ä±äÆäËû´æ´¢ÒýÇæµÄ±íµ½archiveÒýÇæ£¬ÇëÏÈdropÏÂÈκÎË÷Òý
4.myisam¿ÉÒÔÓ ......
×î³õµÄjbpm.hibernate.cfg.xmlÖУ¬¶ÔMySQLµÄ·½ÑÔÅäÖóÉÁËorg.hibernate.dialect.MySQLDialect£¬·¢²¼Á÷³ÌµÄʱºòÓöµ½ÏÂÊö´íÎó£º
Cannot delete or update a parent row: a foreign key constraint fails
Could not synchronize database state with session
½«MySQL·½ÑÔÐÞ¸ÄΪorg.hibernate.dialect.MySQLInnoDBDialectÎÊ ......
±¾ÊµÑéÍê³ÉÈçϽá¹û£º
0. testÊý¾Ý¿â,userinfo Óû§ÐÅÏ¢±í ºÍ userinfolog Óû§ÐÅÏ¢ÈÕÖ¾±í
1. ½¨Á¢Ò»¸öuserinfo±íÐÂÔö¼Ç¼ʱµÄ´¥·¢Æ÷,½«ÐÂÔöÈÕÖ¾¼ÓÈëµ½userinfolog
2. ½¨Á¢Ò»¸öÏòuserinfo±íÐÂÔö¼Ç¼µÄ´æ´¢¹ý³Ì
3. ¸ù¾ ......