python - 通过python连接到Oracle数据库

Question

我正在使用 jaydebeapi 连接到 Oracle DB。代码如下:

host = [address]
port = "1521"
sid = "ctginst1"
database = "oracle"
drivertype = "thin"
uid = [user]
pwd = [pass]

driver_class = "oracle.jdbc.OracleDriver"

driver_file = "ojdbc10.jar"

connection_string="jdbc:{}:{}@{}:{}:{}".format(database, drivertype, host, port, sid)

conn=jaydebeapi.connect(driver_class, connection_string, [uid, pwd], driver_file, )

但是这会失败并给我一个错误:

java.lang.RuntimeException:未找到类 oracle.jdbc.OracleDriver

编辑:通过在启动 JVM 时传递 CLASSPATH 和 .jar 的位置，然后尝试连接，我成功地继续进行

import jpype
jpype.startJVM(jpype.getDefaultJVMPath(), '-Djava.class.path=%s' % driver_file)

现在我收到java.sql.SQLException:指定的 Oracle URL 无效错误

Answer 1

好吧，从那里开始，“@”之前显然缺少一个冒号。完整的成功连接代码如下所示:

import jaydebeapi
import jpype

host = host
port = "1521"
sid = "ctginst1"
database = "oracle"
drivertype = "thin"
uid = user
pwd = password

driver_class = "oracle.jdbc.OracleDriver"

driver_file = "C:\ojdbc8.jar"

connection_string="jdbc:{}:{}:@{}:{}:{}".format(database, drivertype, host, port, sid)

jpype.startJVM(jpype.getDefaultJVMPath(), '-Djava.class.path=%s' % driver_file)

conn=jaydebeapi.connect(driver_class, connection_string, [uid, pwd])