Eviware Forum

I get the exception:
java.lang.NullPointerException
        at com.eviware.soapui.impl.wsdl.teststeps.datasource.JdbcDataSource.load(SourceFile:64)
        at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.next(SourceFile:253)

when connecting to an oracle XE instance. What is the syntax for the connection string in the JDBC Datasource step?

Thanks in advance and for a great product!

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:<drivertype>:@<hostname>:<port>:<database_sid>

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 <soapui>\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.<init>(PhysicalConnection.java:439)
        at oracle.jdbc.driver.T4CConnection.<init>(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?

ok.. hmm.. the error actually suggests there is some problem with the sql query.. can you validate it in some other tool? is it parameterized in any way? Can you attach a screenshot of the datasource editor which shows all values, etc?

sorry for the inconvenience..

regards!

/Ole
eviware.com

Attached is the screenshot.

And where shall I put the credentials? It should be in the connection string?

Hi,

yes, put the credentials in the connection string as follows:

jdbc:oracle:<drivertype>:<username/password>@<hostname>:<port>:<database_sid>

for example

jdbc:oracle:thin:scott/tiger@10.185.13.158:1521:ora9i

does that help?

regards,

/Ole
eviware.com

Great, that was the solution!! :D

Thank you for enthusiastic and responsive support!

Regards,
Jon Disen

Nice!

don't forget to Go Pro for continued enthusiasm :-)

regards!

/Ole
eviware.com