第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號安全,請及時綁定郵箱和手機立即綁定

老問題,數(shù)據(jù)庫連接不上,求解決!??!

嘗試了所有評論中的方法,依然連接不上?。?!

1.修改jdbc.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/seckill?useUnicode=true&characterEncoding=uft8&serverTimezone=UTC&useSSL=false
jdbc.user=root
jdbc.password=***

同時修改spring-dao.xml;另將超時時間改為0,無限等待

<bean?id="dataSource"?class="com.mchange.v2.c3p0.ComboPooledDataSource">
????<property?name="driverClass"?value="${jdbc.driver}"/>
????<property?name="jdbcUrl"?value="${jdbc.url}"/>
????<property?name="user"?value="${jdbc.user}"/>
????<property?name="password"?value="${jdbc.password}"/>

????<!--?c3p0連接池的私有屬性?-->
????<!--?數(shù)據(jù)庫最大連接對象?默認:15?-->
????<property?name="maxPoolSize"?value="30"/>
????<!--?數(shù)據(jù)庫最小連接對象?默認:3?-->
????<property?name="minPoolSize"?value="10"/>
????<!--?關(guān)閉連接后不自動commit?默認:false?-->
????<property?name="autoCommitOnClose"?value="false"/>
????<!--?獲取連接超時時間?默認:0,表示無限等待-->
????<property?name="checkoutTimeout"?value="0"/>
????<!--?當獲取連接失敗時重試次數(shù)?-->
????<property?name="acquireRetryAttempts"?value="2"/>
</bean>

3.修改pom.xml中各項配置版本

<dependency>
??<groupId>mysql</groupId>
??<artifactId>mysql-connector-java</artifactId>
??<version>8.0.11</version>
??<scope>runtime</scope>
</dependency>
<dependency>
??<groupId>com.mchange</groupId>
??<artifactId>c3p0</artifactId>
??<version>0.9.5.2</version>
</dependency>

依然報錯

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:?

### Error querying database.? Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

### The error may exist in file [F:\seckill\target\classes\mapper\SeckillDao.xml]

### The error may involve org.seckill.dao.SeckillDao.queryById

### The error occurred while executing a query

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

已經(jīng)無力了,求大神解決!?。?/p>


正在回答

1 回答

utf你打成了uft


1 回復 有任何疑惑可以回復我~

舉報

0/150
提交
取消

老問題,數(shù)據(jù)庫連接不上,求解決?。?!

我要回答 關(guān)注問題
微信客服

購課補貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動學習伙伴

公眾號

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號