Datasource for Oracle

Hi!

what jdbc driver are you using?

regards!

/Ole
eviware.com

I'm using oracle.jdbc.driver.OracleDriver.

ok.. the connection string should be in the line of

jdbc:oracle::@::

for example

jdbc:oracle:thin:@10.185.13.158:1521:ora9i

If this doesn't help, here are some more questions:
- have you put the oracle jdbc driver jar in the \bin\ext folder (and can you see in the soapui log that soapUI Pro is picking it up when starting)?
- when are you getting the error? when running the testcase? or testing the datasource in the editor?

regards!

/Ole
eviware.com

That's the same connection string that I'm using.
The ojdbc.jar is in the java.class.path (shown in the soapUI System Properties).

The error is reported when testing the step in the editor.

ok thanks..

- do you get this error when running the testcase?
- do you see any other errors in the console window or soapui log?
- are you using the latest snapshot or the 1.7.5 release?

regards!

/Ole
eviware.com

When running the testcase I get this exception:

java.sql.SQLException: invalid arguments in call
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:236)
        at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:439)
        at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.eviware.soapui.impl.wsdl.teststeps.datasource.JdbcDataSource.prepare(SourceFile:96)
        at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.prepare(SourceFile:215)
        at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.run(WsdlTestCaseRunner.java:135)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

No, I'm using a 1.7.1 trial license.

ok.. there seems to be some error with the connection string.. could you upgrade to the latest snapshot for testing? (your license will work with that version as well..).. also.. can you show your connections string? (mail it to me at ole@eviware.com if you want..)

regards!

/Ole
eviware.com

After updating to 1.7.5 I get this exception when running the testcase:

15:09:30,843 ERROR [WsdlTestCaseRunner] Exception during TestCase Execution
java.lang.Exception: Failed to prepare testStep [Check db]; java.lang.Exception: Failed to init connection for drvr [ora
cle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:@localhost:1521:XE]
        at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.run(WsdlTestCaseRunner.java:155)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

ok thanks.. could you please try using 127.0.0.1 instead of localhost? It may be that the oracle listener is not bound to that name.. you could also test with telnet from the commandline, just open a command prompt and type

telnet localhost 1521

to see if you are getting a connect from oracle..

regards!

/Ole
eviware.com

I get a telnet conection with localhost.
After installing 1.7.5 I forgot to put the ojdbc14.jar in the classpath!
But still I get an exception:
16:49:41,734 ERROR [WsdlTestCaseRunner] Exception during TestCase Execution
java.lang.Exception: Failed to prepare testStep [Check db]; java.sql.SQLException: invalid arguments in call
        at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.run(WsdlTestCaseRunner.java:155)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

I've also tried with 127.0.0.1 instead of localhost, but no success.

Any idea?