mysqlÁ¬½Ó³¬Ê±
¿ò¼ÜÓõÄÊÇssi
dataSourceÅäÖÃÎļþ
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver </value>
</property>
<property name="url">
<value>jdbc:mysql://192.168.0.108:3306/restaurant
</value>
</property>
<property name="username">
<value>root </value>
</property>
<property name="password">
<value>root </value>
</property>
<!-- Á¬½Ó³ØÆô¶¯Ê±µÄ³õʼֵ -->
<property name="initialSize" value="10" />
<!-- Á¬½Ó³ØµÄ×î´óÖµ -->
<property name="maxActive" value="1000" />
<!-- ×î´ó¿ÕÏÐÖµ£¬µ±¾¹ýÒ»¸ö¸ß·åÆÚºó£¬Á¬½Ó³Ø¿ÉÒÔÂýÂý½«ÒѾÓò»µ½µÄÁ¬½Ó½øÐÐÊÍ·Å£¬Ò»Ö±´ïµ½maxIdelΪֹ -->
<property name="maxIdle" value="100" />
<!-- ×îС¿ÕÏÐÖµ£¬µ±¿ÕÏеÄÁ¬½ÓСÓÚ·§ÖµÊ±£¬Á¬½Ó³Ø»áÈ¥Ô¤ÉóһЩÁ¬½Ó£¬ÒÔÃâºé·åÀ´Ê±À´²»¼°È¥ÉêÇë -->
<property name="minIdle" value="105" />
</bean>
×òÌ컹ºÃµÄ½ñÌìÁ¬½Ó¾Í³¬Ê±ÁË
±¨´í
org.apache.commons.dbcp.SQLNestedExc
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
100215 9:55:47 [Warning] Aborted connection 247 to db: 'gases' user: 'root' host: 'localhost' (Got an error reading communication packets)
100215 9:55:47 [Warning] Aborted connection 257 to db: 'ga ......