已解决No suitable driver found for jdbc:mysql://localhost:3306/ 问题

最新推荐文章于 2024-03-13 23:30:00 发布
最新推荐文章于 2024-03-13 23:30:00 发布
阅读量4.8w 收藏 17
点赞数 8
分类专栏： 项目踩坑 文章标签： mysql servlet java Jdbc
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_51484460/article/details/130452454
版权

已解决No suitable driver found for jdbc:mysql://localhost:3306/ 问题

在这里插入图片描述

本文目录

一、Bug描述

在学习java数据库连接池使用的时候遇到问题，无法连接到数据库，查看日志是"No Suitable Driver Found For Jdbc"，但查看数据库连接配置没问题。

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/db_mydb?characterEncoding=utf8&useSSL=false
 at java.sql.DriverManager.getConnection(Unknown Source)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at com.luojia.sims.utils.DBManager.getConn(DBManager.java:30)
 at com.luojia.sims.dao.UserDAO.addUser(UserDAO.java:22)
 at org.apache.jsp.user_005fsave_jsp._jspService(user_005fsave_jsp.java:135)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:500)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Unknown Source)
四月 08, 2018 8:07:34 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [jsp] in context with path [/sims] threw exception [An exception occurred processing [user_save.jsp] at line [23]
20:    
21:    //璋冪敤UserDAO涓殑addUser鏂规硶瀹屾垚淇濆瓨
22:    UserDTO u = new UserDTO(0,name,pwd,sex,age,remark);
23:    boolean b = new UserDAO().addUser(u);
24:    
25:    //鏍规嵁娉ㄥ唽鐘舵?佽繘琛岃烦杞?
26:    if(b){

Stacktrace:] with root cause
java.lang.NullPointerException
 at com.luojia.sims.dao.UserDAO.addUser(UserDAO.java:24)
 at org.apache.jsp.user_005fsave_jsp._jspService(user_005fsave_jsp.java:135)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:500)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Unknown Source)

这个问题可把我愁坏了，要不问一下GPT？上。

在这里插入图片描述

二、定位报错点及原因

问了一下GPT，得到的答案是这样的。 简单的来说，就是可能驱动程序有问题，或者是URL的问题。

.在这里插入图片描述

三、最终的解决方案

首先，下载数据库链接的jar包：https://dev.mysql.com/downloads/connector/

进去之后找到对应好的一个jar包下载。

下载好了之后，按照路径进去，可以看到用于 数据库链接的驱动 Driver.class

在这里插入图片描述

出现上述报错的原因通常有三种：

1、URL格式不对：正确为
Connectionconn=DriverManager.getConnection(“jdbc:mysql://localhost:3306/XX”,“root”,“XXXX”)

2、驱动字符串出错(com.mysql.jdbc.Driver)

3、Classpath中没有加入合适的mysql_jdbc驱动

那么对应的解决方案如下：

1、书写正确的URL格式

2、书写正确的驱动字符串

3、将驱动加入CLASSPATH

四、相关注意事项

总结来说解决方案如下：

1, 连接URL格式出现了问题(Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/XX","root","XXXX")
2, 驱动字符串出错(com.mysql.jdbc.Driver)
3, Classpath中没有加入合适的mysql_jdbc驱动
4, 尝试着将mysql-connector-java-5.1.34-bin.jar的jar包加入C:\Program Files\Java\jre1.6.0_02\lib\ext文件夹下(或者直接导入项目中),问题解决
5, 检查是不是jdbc:mysql://写成了jdbc:mysql// 连接写不对也会报这个找不到驱动的错

如果以上错误都不是，还有一种常见错误，就是jre1.8.0_162\lib\ext目录下没有加入jar包，解决办法很简单，将mysql-connector-java.jar包复制到 C:\Program Files\Java\jre1.8.0_162\lib\ext 目录下即可

在这里插入图片描述

总结

Hello，各位看官老爷们好，洲洲已经建立了技术交流群，如果你很感兴趣，可以私信我加入我的社群。

📝社群中不定时会有很多活动，例如每周都会包邮免费送一些技术书籍及精美礼品、学习资料分享、大厂面经分享、技术讨论、行业大佬创业杂谈等等。

📝社群方向很多，相关领域有Web全栈（前后端）、人工智能、机器学习、自媒体变现、前沿科技文章分享、论文精读等等。

📝不管你是多新手的小白，都欢迎你加入社群中讨论、聊天、分享，加速助力你成为下一个技术大佬！也随时欢迎您跟我沟通，一起交流，一起成长。变现、进步、技术、资料、项目、你想要的这里都会有

📝网络的风口只会越来越大，风浪越大，鱼越贵！欢迎您加入社群~一个人可以或许可以走的很快，但一群人将走的更远！

📝关注我的公众号（与CSDN同ID：程序员洲洲）可以获得一份Java 10万字面试宝典及相关资料！~

📝想都是问题，做都是答案！行动起来吧！欢迎评论区or后台与我沟通交流，也欢迎您点击下方的链接直接加入到我的交流社群！~ 跳转链接社区~

在这里插入图片描述

程序员洲洲
关注
  • 8
    点赞
  • 踩
  • 17
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 3
    评论
专栏目录
ImpalaJDBC连接所需Jar
11-09
包括 ImpalaJDBC3 ImpalaJDBC4 ImpalaJDBC41 三个版本的ImpalaJDBC连接所需Jar
Code of practice for information security management AS/NZS ISO/IEC 17799:2001
01-20
This Standard was prepared by the Joint Standards Australia/Standards New Zealand Committee IT-012, Information Systems, Security and Identification Technology and supersedes AS/NZS 4444.1:1999, Information security management, Part 1: Code of practice for information security management. It is identical with ISO/IEC 17799:2000, Information technology—Code of practice for information security management and differs in only very minor editorial details from AS/NZS 4444.1:1999. However the Standard number has been changed to that of the international Standard (ISO/IEC 17799) to minimize any confusion when it is used by organizations internationally. The objective of this Standard is to give recommendations for information security management for use by those who are responsible for initiating, implementing or maintaining security in their organization. It is intended to provide a common basis for developing organizational security standards and effective security management practice and to provide confidence in inter-organizational dealings. This Standard is complementary to AS/NZS 4444.2:2000, Information security management, Part 2: Specification for information security management systems (redesignated in Amendment 2 as AS/NZS 7799.2:2000) and HB 231:2000, Information security risk management guidelines. As this Standard is reproduced from an International Standard, the following applies: (a) In the source text ‘this International Standard’ should read ‘this Australian/New Zealand Standard’. (b) A full point should be substituted for a comma when referring to a decimal marker. Information is a vital asset in any organization. The protection and security of information is of prime importance to many aspects of an organization’s business. It is therefore important that an organization implements a suitable set of controls and procedures to achieve information security and manages them to retain that level of security once it is achieved. This Standard is intended for use by managers and employees who are responsible for initiating, implementing and maintaining information security within their organization and it may be considered as a basis for developing organizational security standards. A comprehensive set of controls comprising the best information security practices currently in use is provided in this Standard. This guidance is intended to be as comprehensive as possible. It is intended to serve as a single reference point for identifying the range of controls needed for most situations where information systems are used in industry and commerce and can therefore be applied by large, medium and small organizations. With increasing electronic networking between organizations there is a clear benefit in having a common reference document for information security management. It enables mutual trust to be established between networked information systems and trading partners and provides a basis for the management of these systems between users and service providers. Not all the controls described in this Standard will be relevant to every situation. It cannot take account of local environmental or technological constraints, or be present in a form that suits every potential user in an organization. Consequently this Standard might need to be supplemented by further guidance. It can be used as a basis from which, for example, a corporate policy or an inter-company trading agreement can be developed. The guidance and recommendations provided throughout this Standard should not be quoted as if they were specifications. In particular, care should be taken to ensure that claims of compliance are not misleading. It has been assumed in the drafting of this Standard that the execution of its recommendations is entrusted to suitably qualified and experienced people.
jdbc:mysql://localhost:3306/webshopping?useUnicode=truecharacterEncoding=UTF-8
01-20
连接数据库时，我们会用到这一句。 其作用是：指定字符的编码、解码格式 mysq数据库用到是gdk编码，而你项目的mysql数据库需要的是utf-8码，所以在url后面添加？useUnicode=true&characterEncoding=utf-8,表示 （1）数据库在存放项目数据的时候会先用UTF-8格式将数据解码成字节码，然后再将解码后的字节码重新使用GBK编码存放到数据库中； （2）从数据库中取数据的时候，数据库会先将数据库中的数据按GBK格式解码成字节码，然后再将解码后的字节码重新按UTF-8格式编码数据，最后再将数据返回给客户端 作者：fresh_uncle
connect fail
huaweitman的专栏
12-26 2882
出现这样的情况，一般有四种原因：  一：连接URL格式出现了问题(Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/XX","root","XXXX")  二：驱动字符串出错(com.mysql.jdbc.Driver)       三：Classpath中没有加入合适的mysql_jd
解决 Java 错误 Java.Sql.SQLException: No Suitable Driver
最新发布
迹忆客
03-13 1227
本篇文章介绍了 Java 中的错误。
java连接SQLSever或MySql时出现java.sql.SQLException: No suitable driver的几种解决办法
一名北漂Java程序员的学习记录！
10-23 2878
第一次连库要明白，不同数据库用到的jdbc驱动是不一样的，下面是两个数据库驱动的下载地址，供参考 MySQLJdbc Downloads:MySQLCommunityDownloadshttps://dev.mysql.com/downloads/connector/j/ SQLSeverJdbc Downloads:MicrosoftSQLServer https://www.mic...
总结解决 No suitable driver found for jdbc:mysql//localhost:3306/ 问题的解决方案,各种情况都已囊括,希望可以帮助到有需要的各位
qq_41413485的博客
07-26 1万+
No suitable driver解决方案
FTP-document.rar_fit//127.0.0.1:5050_ftb 127.0.0.1 2121_ftb:127.
09-14
IP地址127.0.0.1 端口21 用户名admin 密码12345
No Suitable Driver Found For Jdbc解决方法
热门推荐
一勺菠萝丶的博客
08-21 11万+
在学习java数据库连接池使用的时候遇到问题,无法连接到数据库,之前练习别的时候都没事,莫名的到这里有连接不上了,查看日志是”No Suitable Driver Found For Jdbc”,但查看数据库连接配置没问题啊,后来发现原来是少导入了一个包mysql-connector-java-3.1.14-bin.jar,导入该包,问题解决. 总结一下No Suitable Driver...
JDBC链接出现异常：No suitable driver found for
我不是学混子
09-10 1万+
java.sql.SQLException: java.sql.SQLException: No suitable driver found for这个异常的发生，原因有二： 一，在可寻的路径下没有合适的数据库驱动。 二，数据库连接时提供的url不正确。   通常，一的情况不常发生，因为我们连接数据库不会不安装驱动，而且驱动的路径也基本不是问题。 多数是数据库
JDBC操作MySQL数据库出现：No suitable driver found for...异常
weixin_45965432的博客
01-08 1万+
JDBC操作MySQL数据库出现：No suitable driver found for …异常，可能原因如下： 一、没有导入jdbc驱动jar包 导入方法如下： 点击 IDEA 左上角的 File -->
处理JDBC：java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/DB
鳄鱼杆的博客
04-30 1万+
文章目录前言一、JDBC简介二、JDBC使用以及处理异常的方法1.导入jar包2.JDBC基础操作3、处理异常：No suitable driver found for jdbc:mysql://localhost:3306/DB总结 前言 今天花费一个多小时的事件处理这个问题，最终的处理方法真的是太…棒了，我重开了个项目，建了下模块，结果问题解决了。 本着斩草要除根……咳咳，刨根问底的原则，我决定细查一下这个问题，下面是我得到的结果！ 一、JDBC简介 不说废话，简单来说：   官方定义了的一套操作关
No suitable driver found for jdbc:mysql://192.168.88.154:3306/yujinlong?characterEncoding=UTF-8
yujinlong2002的博客
03-29 1447
出现以上报错的原因：1、数据库IP的错误2、数据库端口出现错误3、数据库出现错误4、打包时数据库连接驱动版本不兼容5、服务器的驱动没有放置正确（或者没有放置）
完美解决ntp的错误问题no server suitable for synchronization fo
01-20
当用ntpdate -d 来查询时会发现导致 no server suitable for synchronization found 的错误的信息有以下2个：  错误1.Server dropped: Strata too high 在ntp客户端运行ntpdate serverIP，出现no server suitable for synchronization found的错误。 在ntp客户端用ntpdate –d serverIP查看，发现有“Server dropped: strata too high”的错误，并且显示“stratum 16”。而正常情况下stratum这个值得范
解决vue net :ERR_CONNECTION_REFUSED报错问题
10-14
主要介绍了解决vue net :ERR_CONNECTION_REFUSED报错问题，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧
java.sql.SQLException: 结果集已耗尽
08-02
NULL 博文链接：https://listen-raining.iteye.com/blog/1962065
服务器出现java.sql.SQLException No suitable driver found for 的.pdf
12-05
服务器出现java.sql.SQLException No suitable driver found for 的
mysql5.6连接驱动jaf，可处理报错java.sql.SQLException: No suitable driver
02-02
mysql5.6连接驱动jaf，可处理报错java.sql.SQLException: No suitable driver
No suitable java found.In order to properly use the android developer tools...-附件资源
03-05
No suitable java found.In order to properly use the android developer tools...-附件资源
No suitable driver found for jdbc:mysql://localhost:3306/stub
08-31
对于异常消息"No suitable driver found for jdbc:mysql://localhost:3306/stub"，这通常是由于没有正确加载数据库驱动程序引起的。引用中的异常信息提示了这个问题。在引用中的代码片段中，我们可以看到导入了java.sql包和java.sql.Connection、java.sql.DriverManager、java.sql.SQLException等类。这些类是用于数据库连接和操作的。 在引用的代码片段中，我们可以看到在main方法中，首先通过Class.forName()方法加载了一个名为"org.gjt.mm.mysql.Driver"的MySQL驱动程序。然后使用DriverManager.getConnection()方法来建立数据库连接，传入的参数是一个URL字符串，其中包含了数据库的连接信息。 根据引用中的代码，如果要连接到名为"stub"的数据库，URL字符串应该是"jdbc:mysql://localhost:3306/stub"。然而，如果出现了异常消息"No suitable driver found for jdbc:mysql://localhost:3306/stub"，则可能是因为没有正确加载MySQL驱动程序导致的。 解决这个问题的一种方法是确保正确加载了MySQL驱动程序。可以通过在代码中添加如下一行代码来加载驱动程序： Class.forName("com.mysql.jdbc.Driver"); 在加载驱动程序后，再次尝试建立数据库连接，应该就可以成功连接到指定的数据库了。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [mysql - 在Eclipse中将MySQL连接到Java时，找不到jdbc // mysql：// localhost：3306 / nishadagar的合适...](https://blog.csdn.net/weixin_29807507/article/details/114980366)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] - *2* *3* [Java连mysql数据库](https://blog.csdn.net/weixin_33725239/article/details/86379418)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

程序员洲洲

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值