Ó¦Ó÷ÃÎÊMysqlÓöµ½µÄÁ¬½ÓÎÊÌâ
×î½üÔÚ×öÒ»¸öСÏîÄ¿£¬¿ª·¢»·¾³£ºÊý¾Ý¿âmysql5.0£¬·þÎñÆ÷Tomcat5.5¡£ÏîÄ¿´ò³Éwar²¿ÊðÔÚtomcatÉÏÖ®ºó£¬Í¨¹ýÓ¦ÓýøÐвéѯ²Ù×÷£¬Èç¹û²Ù×÷¹ýÓÚƵ·±£¬ºǫ́»áÅ×ÈçÏÂÒì³££º
javax.servlet.ServletException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [08S01]; error code [0]; Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.BindException: Address already in use: connect
STACKTRACE:
java.net.SocketException: java.net.BindException: Address already in use: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionfromDriverManager(DriverManagerDataSource.java:291)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionfromDriverManager(DriverManagerDataSource.java:277
¡£¡£¡£¡£¡£¡£
ÔÚÍøÉϲéÁ˺ܶà×ÊÁÏ£¬Ò²ÔÚÂÛ̳Àï·¢ÌûÌáÎÊ£¬·¢ÏÖÊÇÁ¬½ÓÊýÕ¼ÓõÄÎÊÌâ¡£Ó¦ÓÃÀïÁ¬½Ó²ÉÓõÄÊÇJDBCÖ±Á¬£¬ºóÀ´¸Ä³ÉÁËͨ¹ý»º³å³ØÁ¬½Ó¡£
»»³É»º³å³ØÁ¬½ÓµÄʱºò£¬³ÌÐò´ò°üҪעÒ⣬³ÌÐòlibϵÄnaming-factory.jar£¬naming-factory-dbcp.jar,naming-resources.jar¶¼ÒªÉ¾µô£¬mysqlµÄÁ¬½Ójar°üҲҪɾµô£¬Ö®ºóÔÙ´ò°ü¡£Í¬Ê±»¹
Ïà¹ØÎĵµ£º
[¾¹ý°²×°²âÊԳɹ¦µÄ·½·¨from CYBEND ]
µÚÒ»²½£ºÏµÍ³ÓëÈí¼þµÄ×¼±¸
ϵͳ°æ±¾ redhat enterprise linux 5 ,Äں˰汾 2.6.18
µÚ¶þ²½£ºÈí¼þ°üµÄ×¼±¸
httpdÈí¼þ°ü£ºhttpd-2.2.8.tar.bz2
mysqlÈí¼þ°ü´Ómysql¹Ù·½ÍøÕ¾ÏÂÔØ£¬ÎÒÑ¡ÓõÄÊÇehel5µÄrpm°ü
MySQL-server-community-5.0.51a-0.rhel5.i386.rpm
MySQL-client-community ......
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Li ......
ÄãʹÓùý±ðÈ˵ı¸·Ý·½°¸À´±¸·ÝÄãµÄMySQLÊý¾ÝÂð?ÄãÓжà¹ØÐÄÄãµÄÊý¾Ý?Äã¸ÒÈ·¶¨ÄãÏÖÔÚÕýÔÚÔËÐеĽű¾¾ÍÊÇ¿É¿¿µÄ£¬¿É»Ö¸´µÄ±¸·Ý£¬¶øÇÒÔÚÔËÐйý³ÌÖв»»áÓ°ÏìÄãµÄ¹Ø¼ü×÷ÒµÂð?ÔڻشðÕâ¸öÎÊÌâ֮ǰ£¬ÏȻشðÏÂÃæÊ®¸öÎÊÌâ°É£º
¡¡¡¡1. ±¸·ÝÒªÇóÍ£Ö¹Êý¾Ý¿âÂð?Èç¹û²»ÐèÒª£¬ÄÇô±¸·ÝµÄʱºò»áÓ°Ïìʲô?¿éÉ豸?I/O¸ºÔØ?»º³å?»òÕßÊÇÆäËû?
¡¡ ......
Win2003server ϼÜÉèPHPWind²úÆ·»·¾³
°²×°Ç°×¼±¸:1¡¢°²×°ºÃiis6
&nbs ......
ÆÕͨË÷Òý¡¢Î¨Ò»Ë÷ÒýºÍÖ÷Ë÷Òý
1. ÆÕͨË÷Òý
ÆÕͨË÷Òý(Óɹؼü×ÖKEY»òINDEX¶¨ÒåµÄË÷Òý)µÄΨһÈÎÎñÊǼӿì¶ÔÊý¾ÝµÄ·ÃÎÊËٶȡ£Òò´Ë£¬Ó¦¸ÃֻΪÄÇЩ×î¾³£³öÏÖÔÚ²éѯÌõ¼þ(WHERE column = …)»òÅÅÐòÌõ¼þ(ORDER BY column)ÖеÄÊý¾ÝÁд´½¨Ë÷Òý¡£Ö»ÒªÓпÉÄÜ£¬¾ÍÓ¦¸ÃÑ¡ÔñÒ»¸öÊý¾Ý×îÕûÆë¡¢×î½ô´ÕµÄÊý¾ÝÁÐ(ÈçÒ»¸öÕûÊýÀàÐ͵ÄÊý¾ÝÁÐ)À ......