程序员花花_ 2017-04-15 06:36 采纳率: 50%
浏览 2566
已采纳

关于数据库连接(c3p0连接mysql)出现的问题

本来是想通过jsp页面添加一个数据,跳转到访问serlvlet页面通过jbutils连接mqsql保存数据,但是我检查了c3p0的配置文件和datasource对象,queryrunner对象都可以正常新建,具体问题找不到,谢谢大家了这是访问页面的报错代码
HTTP Status 500 - java.lang.RuntimeException: java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection should be passed in

type Exception report

message java.lang.RuntimeException: java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection should be passed in

description The server encountered an internal error that prevented it from fulfilling this request.

exception

java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection should be passed in
serviceimp.FoodTypeService.save(FoodTypeService.java:62)
servlet.FoodTypeServlet.addFoodType(FoodTypeServlet.java:65)
servlet.FoodTypeServlet.doGet(FoodTypeServlet.java:44)
servlet.FoodTypeServlet.doPost(FoodTypeServlet.java:105)
javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
root cause

java.lang.RuntimeException: java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection should be passed in
daoimp.FoodTypeDao.save(FoodTypeDao.java:36)
serviceimp.FoodTypeService.save(FoodTypeService.java:59)
servlet.FoodTypeServlet.addFoodType(FoodTypeServlet.java:65)
servlet.FoodTypeServlet.doGet(FoodTypeServlet.java:44)
servlet.FoodTypeServlet.doPost(FoodTypeServlet.java:105)
javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
root cause

java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection should be passed in
org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:200)
org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:437)
daoimp.FoodTypeDao.save(FoodTypeDao.java:34)
serviceimp.FoodTypeService.save(FoodTypeService.java:59)
servlet.FoodTypeServlet.addFoodType(FoodTypeServlet.java:65)
servlet.FoodTypeServlet.doGet(FoodTypeServlet.java:44)
servlet.FoodTypeServlet.doPost(FoodTypeServlet.java:105)
javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.39 logs.

  • 写回答

1条回答

  • 编程爱好者熊浪 2017-04-15 06:35
    关注
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
  • ¥15 如何在scanpy上做差异基因和通路富集?
  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?