mysql执行报错10304_MySQL驱动时不时报错

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/huanwei?characterEncoding=UTF8

at java.sql.DriverManager.getConnection(DriverManager.java:596)

at java.sql.DriverManager.getConnection(DriverManager.java:215)

at com.galaxylab.huanwei.dao.GenericDAO.getConnection(GenericDAO.java:37)

at com.galaxylab.huanwei.dao.GenericDAO.executeQuery(GenericDAO.java:49)

at com.galaxylab.huanwei.dao.TokenDAO.getToken(TokenDAO.java:16)

at com.galaxylab.huanwei.service.TokenRefresher.run(AccessTokenGenerationService.java:50)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

2016-05-24 15:35:56,639 [ERROR] [pool-3-thread-1:4802146][com.galaxylab.huanwei.service.TokenRefresher] – Exception

java.lang.NullPointerException

at com.galaxylab.huanwei.dao.TokenDAO.getToken(TokenDAO.java:17)

at com.galaxylab.huanwei.service.TokenRefresher.run(AccessTokenGenerationService.java:50)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

这一段错误时不时的会报出来，但是又找不到原因，程序又能正常运行，请高手指点指点，怎么下手处理这个异常

这是本人的一个定时线程进入的DAO

package com.galaxylab.huanwei.service;

import java.util.concurrent.Executors;

import java.util.concurrent.ScheduledExecutorService;

import java.util.concurrent.TimeUnit;

import org.joda.time.DateTime;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import com.galaxylab.huanwei.dao.TokenDAO;

import com.galaxylab.huanwei.domain.Token;

import com.galaxylab.huanwei.dto.GetTokenResponse;

import com.galaxylab.huanwei.jdbc.CommonConfig;

import com.galaxylab.huanwei.util.HttpUtil;

import com.google.gson.Gson;

public class AccessTokenGenerationService {

private final ScheduledExecutorService scheduledExecutorService = Executors.newScheduledThreadPool(1);

private final Logger logger = LoggerFactory.getLogger(getClass());

public AccessTokenGenerationService() {}

public void start() {

Runnable task = new TokenRefresher();

logger.info("Start AccessTokenGenerationService()");

scheduledExecutorService.scheduleWithFixedDelay(task, 0, 600,TimeUnit.SECONDS);

}

}

class TokenRefresher implements Runnable{

private final TokenDAO tokenDAO = new TokenDAO();

private final long GRACE_PERIOD = 1800000;

private final Logger logger = LoggerFactory.getLogger(getClass());

public Gson gson = new Gson();

@SuppressWarnings("static-access")

@Override

public void run() {

try{

Token token = tokenDAO.getToken();

logger.info("latest token is {}",token);

if(token.getGoodUntil().getMillis() - DateTime.now().getMillis() 

logger.info("Start getting new token");

String url = CommonConfig.WECHAT_ACCESS_TOKEN_SERVICE_URL

.replace("APPID", CommonConfig.WECHAT_APP_ID)

.replace("APPSECRET", CommonConfig.WECHAT_SECURITY_KEY);

logger.info("URL is {}",url);

String response = HttpUtil.get(url);

GetTokenResponse getTokenResponse = gson.fromJson(response, GetTokenResponse.class);

Token new_token = new Token(getTokenResponse.getAccess_token(),

new DateTime().now().plusSeconds(Integer.valueOf(getTokenResponse.getExpires_in())));

tokenDAO.updataToken(new_token);

}

}catch(Exception e) {

logger.error("Exception",e);

}

}

}

解决方案

20

项目引用的mysql驱动可能比较旧

更新一下试试

10

TokenDAO 里面代码是不是有问题

10

java.lang.NullPointerException

at com.galaxylab.huanwei.dao.TokenDAO.getToken(TokenDAO.java:17)

看看这里是啥

CodeBye 版权所有丨如未注明 , 均为原创丨本网站采用BY-NC-SA协议进行授权 , 转载请注明MySQL驱动时不时报错！