连接Oracle数据库到Eclipse。

huangapple 未分类评论42阅读模式
英文:

Connect oracle database to eclipse

问题

我尝试使用以下代码在Eclipse中与Oracle数据库建立连接

```java
import java.sql.*;
public class Testsql {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("oracle.jdbc.driver.oracleDriver");
        DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","biline","bl");         
        System.out.println("连接成功");}
}

我下载了ojdbc6并将其作为外部jar添加到库中,但是我得到了以下消息:

Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.oracleDriver
    at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
    at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
    at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
    at java.base/java.lang.Class.forName0(Native Method)
    at java.base/java.lang.Class.forName(Class.java:315)
    at ProjetGL/ProjetGL.Testsql.main(Testsql.java:7)

当我同时添加ojdbc5和ojdbc6时,我得到了以下错误(只是为了尝试):

Error occurred during initialization of boot layer
java.lang.module.ResolutionException: Module ojdbc5 contains package oracle.core.lmx, module ojdbc6 exports package oracle.core.lmx to ojdbc5

我不太明白这个错误消息。请问是否有人对这个问题有任何想法?
我正在使用Ubuntu(使用Oracle DB的Express Edition)。


<details>
<summary>英文:</summary>

I tried to make a connection with oracle databse and eclipse by using this code:

import java.sql.*;
public class Testsql {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("oracle.jdbc.driver.oracleDriver");
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","biline","bl");
System.out.println("Connection Successful");}}

I download ojdbc6 and i add it as external jar in the libraries, but i got this message :

Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.oracleDriver
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
at java.base/java.lang.Class.forName0(Native Method)
at java.base/java.lang.Class.forName(Class.java:315)
at ProjetGL/ProjetGL.Testsql.main(Testsql.java:7)

And when i add ojdbc5 with ojdbc6 i got this(just to try):

Error occurred during initialization of boot layer
java.lang.module.ResolutionException: Module ojdbc5 contains package oracle.core.lmx, module ojdbc6 exports package oracle.core.lmx to ojdbc5


I didn&#39;t understand the error message. Please, is there someone here who has any idea about the problem?
I&#39;m working with ubuntu(using an express edition of oracle DB).


</details>


huangapple
  • 本文由 发表于 2020年4月4日 06:17:56
  • 转载请务必保留本文链接:https://java.coder-hub.com/61021251.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定