找不到Java SQL驱动程序 [英] Java SQL driver not found

问题描述

我有一个eclipse项目。

如果我尝试从eclipse启动它，它会失败returnong没有合适的驱动程序找到jdbc.db2。 dbname 。

如果我尝试从命令行启动它，它运行良好。



我试图通过verbose命令搜索卸载的类。

这是我从命令行开始的时候：

Hi,

I have an eclipse project.
If I try to start it from eclipse, it fails returnong No suitable driver found for jdbc.db2.dbname.
If I try to start it from command line, it runs well.

I tried to search for unloaded class by the verbose command.
This is when I start from command line:

JVM in esecuzione:

C:\jdk1.6.0\JAVA\bin\java
java version "1.6.0"
Java(TM) SE Runtime Environment (build pwi3260sr2-20080818_01(SR2))
IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 Windows Vista x86-32 jvmwi3260-20080816_22093 (JIT enabled, AOT enabled)

[...]
class load: ObRun.ObDatabase.ObDatabaseMgr from: file:/C:/finance/610/ObRun.jar
class load: java/sql/Wrapper
class load: java/sql/Statement
class load: java/sql/Driver
class load: COM.ibm.db2.jdbc.app.DB2Driver from: file:/C:/IBM/SQLLIB/java/db2java.zip
class load: java/lang/UnsatisfiedLinkError
class load: java/sql/Connection
class load: COM.ibm.db2.jdbc.app.DB2Driver$1 from: file:/C:/IBM/SQLLIB/java/db2java.zip
class load: java/net/URLDecoder
class load: java/net/URLEncoder
class load: COM.ibm.db2.jdbc.app.DB2Driver$3 from: file:/C:/IBM/SQLLIB/java/db2java.zip
class load: COM.ibm.db2.jdbc.app.DB2Statement from: file:/C:/IBM/SQLLIB/java/db2java.zip
class load: java/sql/PreparedStatement

这是我从Eclipse开始的时候：

This is when I start from Eclipse:

[...]
[Loaded ObRun.ObDatabase.ObDatabaseMgr from file:/C:/finance/610/ObRun.jar]
[Loaded java.sql.Wrapper from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded java.sql.DatabaseMetaData from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded java.sql.Statement from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded java.sql.Driver from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded COM.ibm.db2.jdbc.app.DB2Driver from file:/C:/IBM/SQLLIB/java/db2java.zip]
[Loaded java.sql.Connection from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded java.lang.UnsatisfiedLinkError from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded COM.ibm.db2.jdbc.app.DB2Driver$1 from file:/C:/IBM/SQLLIB/java/db2java.zip]
[Loaded java.net.URLDecoder from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded java.net.URLEncoder from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded COM.ibm.db2.jdbc.app.DB2Driver$3 from file:/C:/IBM/SQLLIB/java/db2java.zip]
[Loaded COM.ibm.db2.mri.DB2Messages from file:/C:/IBM/SQLLIB/java/db2java.zip]
[Loaded COM.ibm.db2.mri.DB2ErrorMessages from file:/C:/IBM/SQLLIB/java/db2java.zip]
[...]
java.sql.SQLException: No suitable driver found for jdbc:db2:MyDBName
	at java.sql.DriverManager.getConnection(DriverManager.java:602)

我尝试过：



我也试图在日食中设置一个更新的jre（1.8.0.65）。

我也尝试进入反编译类看看有什么东西。

似乎java.sql.DriverManager类无法搜索可用的驱动程序。

What I have tried:

I tried also to set a newer jre in eclipse (1.8.0.65).
I tried also to enter into decompiled class to see what's appening.
It seems that the java.sql.DriverManager class isn't able to search for the available drivers.

推荐答案

1 from：file：/ C：/IBM/SQLLIB/java/db2java.zip
class load：java / net / URLDecoder
class load：java / net / URLEncoder
class load：COM.ibm.db2.jdbc.app.DB2Driver

1 from: file:/C:/IBM/SQLLIB/java/db2java.zip class load: java/net/URLDecoder class load: java/net/URLEncoder class load: COM.ibm.db2.jdbc.app.DB2Driver

3 from：file：/ C：/IBM/SQLLIB/java/db2java.zip
class load：COM .ibm.db2.jdbc.app.DB2Statement from：file：/ C：/IBM/SQLLIB/java/db2java.zip
class load：java / sql / PreparedStatement

3 from: file:/C:/IBM/SQLLIB/java/db2java.zip class load: COM.ibm.db2.jdbc.app.DB2Statement from: file:/C:/IBM/SQLLIB/java/db2java.zip class load: java/sql/PreparedStatement

这是我从Eclipse开始的时候：

This is when I start from Eclipse:

[...]
[Loaded ObRun.ObDatabase.ObDatabaseMgr from file:/C:/finance/610/ObRun.jar]
[Loaded java.sql.Wrapper from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded java.sql.DatabaseMetaData from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded java.sql.Statement from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded java.sql.Driver from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded COM.ibm.db2.jdbc.app.DB2Driver from file:/C:/IBM/SQLLIB/java/db2java.zip]
[Loaded java.sql.Connection from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded java.lang.UnsatisfiedLinkError from K:\Programmi\jdk1.6.0\jre\lib\rt.jar]
[Loaded COM.ibm.db2.jdbc.app.DB2Driver

1 from file：/ C：/IBM/SQLLIB/java/db2java.zip]
[来自K的加载的java.net.URLDecoder： \ Programmi \ jdk1.6.0\jre\lib\rt.jar]
[来自K的加载java.net.URLEncoder：\ Programmi \ jdk1.6.0 \ jre\lib\rt.jar]
[已加载COM.ibm.db2.jdbc.app.DB2Driver

1 from file:/C:/IBM/SQLLIB/java/db2java.zip] [Loaded java.net.URLDecoder from K:\Programmi\jdk1.6.0\jre\lib\rt.jar] [Loaded java.net.URLEncoder from K:\Programmi\jdk1.6.0\jre\lib\rt.jar] [Loaded COM.ibm.db2.jdbc.app.DB2Driver

这篇关于找不到Java SQL驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！