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×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
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 ......