苦苦挣扎 - 未找到类异常:JAVA 中的 com.mysql.jdbc.Driver

发布于 2024-11-20 00:36:43 字数 810 浏览 8 评论 0原文

在 Netbeans ide 7.0 中,我面临这个特殊问题。我在程序中编写了以下代码行

Class.forName("com.mysql.jdbc.Driver").newInstance();

该特定行引发异常。当我从 netbeans 7.0 中的“服务 -> 数据库 -> 驱动程序 -> MySQL(Connector/Jdriver)”连接相同的 mysql 数据库服务器时,它已连接。当我进入该连接的属性时,我发现它正在使用与我在代码行中使用的相同的类来连接 mysql 服务器。

我还阅读了一些论坛,例如

http://www.javakb.com/Uwe/Forum.aspx/java-setup/11895/ClassNotFoundException-com-mysql-jdbc-Driver-from-netbeans

但这 1 用于Ubuntu 上的 netbeans。那么 Windows 呢?

另外,浏览了这里的所有回复

http://forums .mysql.com/read.php?60,42473,42473#msg-42473

不知道出了什么问题?请帮忙。

In Netbeans ide 7.0, I am facing this particular problem. I wrote the following line of code in my program

Class.forName("com.mysql.jdbc.Driver").newInstance();

This particular line is throwing an exception. And when I connected the same mysql db server from the "Services -> Databases -> Drivers -> MySQL(Connector/Jdriver)" in the netbeans 7.0, it got connected. When I went into the properties of that connection I found that it is connecting the mysql server using the same class which I used in the line of code.

I also read some of the forums such as

http://www.javakb.com/Uwe/Forum.aspx/java-setup/11895/ClassNotFoundException-com-mysql-jdbc-Driver-from-netbeans

but this 1 is for netbeans on Ubuntu. What about Windows?

also, went through all of the responses in here

http://forums.mysql.com/read.php?60,42473,42473#msg-42473

I don't know what is wrong? Please help.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

浅唱々樱花落 2024-11-27 00:36:43

解决方案:这里的问题是不同的。我的 netbeans 能够通过它自己的预定义服务连接 MySQL 服务器。这是因为该类的路径是在它使用的驱动程序中定义的。但在我正在构建的项目中,未设置 MySQL 驱动程序的类路径。所以我只是将相同的驱动程序“MySQL JDBC Driver”添加到我的项目中。

可以完成,只需转到左侧的项目导航器即可。您将在项目导航器的底部找到附加到您的项目的库。然后右键单击该库,选择“添加库...”,然后从当前的全局库中选择特定的库。就我而言,连接器类存在于 netbeans 中,但该库未添加到我的项目中。

顺便说一句,谢谢您宝贵的时间。

Solution : Well the problem here was different. My netbeans was able to connect MySQL server through its own predefined services. That was because the path of that class was defined in the driver it was using. But in the project I was building, the class-path for MySQL driver was not set. So I just added the same driver "MySQL JDBC Driver" to my Project.

It can be done, just go to the Project navigator which is on the left side. There you'll find the Libraries attached to your Project at the bottom of Project navigator. Then right click on the library, select "Add Library..." and then select the particular library from the Global Libraries present. In my case the connector class was present in the netbeans but the library was not added to my project.

Thank you btw for your precious time.

这个俗人 2024-11-27 00:36:43

You need to download the connector from here: http://www.mysql.com/products/connector/ and include it in your classpath

谈场末日恋爱 2024-11-27 00:36:43

是的,

  1. 您的类路径中没有 mysql-connector.jar。如前所述,此 jar 文件包含“com.mysql.jdbc.Driver”类,它必须存在于类路径中才能成功连接到 mysql 数据库。您可以从 mysql.com 下载 mysql-connector.jar。
  2. mysql-connector.jar 在您的类路径中,但不知何故您的类路径被覆盖。
    Java 中的类路径很棘手,jar 中指定的类路径可能会覆盖 CLASSPATH 路径变量。请参阅 Java 中的类路径如何工作以详细了解此问题。
  3. mysql-connector.jar 位于类路径中,但当前用户没有读取权限。
    这个问题经常发生在 Unix 或 Linux 操作系统中,这些操作系统具有基于用户、组和所有者级别的复杂文件和目录权限。只需获得正确的权限并再次运行您的程序即可。

了解更多: http://javarevisited.blogspot.com/2012/03/ jdbc-javalangclassnotfoundexception.html#ixzz2Ply4zLFF

yes

  1. You don't have mysql-connector.jar in your Classpath. as stated earlier this jar file contains "com.mysql.jdbc.Driver" class it must be present in classpath in order to successful connection to mysql database. you can downlad mysql-connector.jar from mysql.com.
  2. mysql-connector.jar is in your classpath but somehow your classpath is getting overridden.
    Classpath is tricky in Java and classpath specified in jar may override CLASSPATH path variable. See how classpath works in Java to understand this issue in detail.
  3. mysql-connector.jar is in classpath but current user doesn't have read permission.
    This problem often happens in Unix or Linux operating system which has sophisticated file and directory permission based on user, group and owner level. just get the right permission and run your program again.

Read more: http://javarevisited.blogspot.com/2012/03/jdbc-javalangclassnotfoundexception.html#ixzz2Ply4zLFF

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文