Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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µÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

mysql Îļþ¶ÁÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ 
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......

mysqlÁ¬½Ó±»Æµ·±ÖжÏ

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ