英文:
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't understand the error message. Please, is there someone here who has any idea about the problem?
I'm working with ubuntu(using an express edition of oracle DB).
</details>
专注分享java语言的经验与见解,让所有开发者获益!
评论