Oracle数据库连接问题

Question

我正在尝试开始使用DbFit 4.0.0，如《入门》指南中所述。

我有以下测试http://localhost:8085/HelloWorldTest

!path lib/*.jar
!|dbfit.OracleTest|
!|Connect|localhost:1521|integration|integration|XEPDB1|
!|Query| select 'test' as x from dual|
|x|
|test|

但当我运行测试时，我会遇到以下问题：

java.lang.Error: Cannot load Oracle database driver oracle.jdbc.OracleDriver. Is the JDBC driver on the classpath?
at dbfit.api.DbEnvironmentFactory$EnvironmentDescriptor.checkDriver(DbEnvironmentFactory.java:45)
at dbfit.api.DbEnvironmentFactory$EnvironmentDescriptor.createEnvironmentInstance(DbEnvironmentFactory.java:60)
at dbfit.api.DbEnvironmentFactory.createEnvironmentInstance(DbEnvironmentFactory.java:102)
at dbfit.api.DbEnvironmentFactory.newEnvironmentInstance(DbEnvironmentFactory.java:106)
at dbfit.OracleTest.(OracleTest.java:5)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at java.lang.Class.newInstance(Class.java:442)
at fit.FixtureClass.newInstance(FixtureClass.java:24)
at fit.FixtureLoader.instantiateFixture(FixtureLoader.java:61)
at fit.FixtureLoader.instantiateFirstValidFixtureClass(FixtureLoader.java:82)
at fit.FixtureLoader.disgraceThenLoad(FixtureLoader.java:43)
at fit.Fixture.loadFixture(Fixture.java:142)
at fit.Fixture.getLinkedFixtureWithArgs(Fixture.java:134)
at fit.Fixture.doTables(Fixture.java:79)
at fit.FitServer.process(FitServer.java:81)
at fit.FitServer.run(FitServer.java:56)
at fit.FitServer.main(FitServer.java:41)
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:387)
at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352)
at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at dbfit.api.DbEnvironmentFactory$EnvironmentDescriptor.checkDriver(DbEnvironmentFactory.java:43)
... 19 more

我没有发现任何相关的：

• https://dbfit.github.io/dbfit/docs/database-specific-information.html
• https://dbfit.github.io/dbfit/docs/reference.html#connect

我在Linux中运行DbFit(Lubuntu 22.04 LTS(。

Answer 1

在运行示例之前，我必须解决以下两个问题：

1. 缺少Oracle JDBC驱动程序
2. 连接字符串不正确

问题#1缺少Oracle JDBC驱动程序

我从Oracle下载页面下载了Oracle JDBC驱动程序(ojdbc8.jar(：

https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

并将其复制到CCD_ 2。

不幸的是，在那之后我遇到了第二个问题。

问题#2连接字符串不正确

现在我得到以下错误：

oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:294)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:347)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1688)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:626)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:813)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:80)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:816)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:620)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at dbfit.api.AbstractDbEnvironment.connect(AbstractDbEnvironment.java:54)
at dbfit.api.AbstractDbEnvironment.connect(AbstractDbEnvironment.java:81)
at dbfit.DatabaseTest.connect(DatabaseTest.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at fitlibrary.closure.MethodClosure.invoke(MethodClosure.java:35)
at fitlibrary.closure.MethodClosure.invokeTyped(MethodClosure.java:28)
at fitlibrary.closure.CalledMethodTarget.invokeTyped(CalledMethodTarget.java:77)
at fitlibrary.closure.CalledMethodTarget.invokeTyped(CalledMethodTarget.java:95)
at fitlibrary.closure.CalledMethodTarget.invokeAndWrap(CalledMethodTarget.java:358)
at fitlibrary.traverse.workflow.caller.ActionCaller.run(ActionCaller.java:37)
at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretRow(DoTraverseInterpreter.java:176)
at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretWholeTable(DoTraverseInterpreter.java:96)
at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretWholeTable(DoTraverseInterpreter.java:89)
at fitlibrary.DoFixture.interpretWholeTable(DoFixture.java:73)
at fitlibrary.suite.InFlowPageRunner.run(InFlowPageRunner.java:27)
at fitlibrary.DoFixture.interpretTables(DoFixture.java:42)
at dbfit.DatabaseTest.interpretTables(DatabaseTest.java:26)
at fit.Fixture.doTables(Fixture.java:81)
at fit.FitServer.process(FitServer.java:81)
at fit.FitServer.run(FitServer.java:56)
at fit.FitServer.main(FitServer.java:41)

我的连接字符串：

!|Connect|localhost:1521|integration|integration|XEPDB1|

应该是正确的，我可以用其他工具连接到数据库。

经过一点修补，我得到了以下连接字符串工作：

!|Connect|jdbc:oracle:thin:integration/integration@localhost:1521/XEPDB1|

通常，连接字符串格式为：

jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST>:<PORT>/<SERVICE_NAME>

例如，请参阅使用JDBC 连接到Oracle数据库的URL字符串格式

工作测试

完成工作启动测试：http://localhost:8085/HelloWorldTest

!path lib/*.jar
!|dbfit.OracleTest|
!|Connect|jdbc:oracle:thin:integration/integration@localhost:1521/XEPDB1|
!|Query| select 'test' as x from dual|
|x|
|test|