Forum Discussion

Jon_Disen's avatar
Jon_Disen
Occasional Contributor
18 years ago

Datasource for Oracle

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!
  • omatzura's avatar
    omatzura
    Super Contributor
    18 years ago
    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
  • Jon_Disen's avatar
    Jon_Disen
    Occasional Contributor
    18 years ago
    Attached is the screenshot.

    And where shall I put the credentials? It should be in the connection string?
  • omatzura's avatar
    omatzura
    Super Contributor
    18 years ago
    Hi,

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

    jdbc:oracle::@::

    for example

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

    does that help?

    regards,

    /Ole
    eviware.com
  • Jon_Disen's avatar
    Jon_Disen
    Occasional Contributor
    18 years ago
    Great, that was the solution!!

    Thank you for enthusiastic and responsive support!

    Regards,
    Jon Disen
  • omatzura's avatar
    omatzura
    Super Contributor
    18 years ago
    Nice!

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

    regards!

    /Ole
    eviware.com
  • srkolluri's avatar
    srkolluri
    New Contributor
    15 years ago
    omatzura wrote:
    Hi,

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

    jdbc:oracle::@::

    for example

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

    does that help?

    regards,

    /Ole
    eviware.com


    hi,
    i am trying to do a POC for my client on oracle SOA using SOAP UI. It is throwing me an exception "Failed to init connection for drvr , connectionString"
  • srkolluri's avatar
    srkolluri
    New Contributor
    15 years ago
    srkolluri wrote:
    omatzura wrote:
    Hi,

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

    jdbc:oracle::@::

    for example

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

    does that help?

    regards,

    /Ole
    eviware.com


    hi,
    i am trying to do a POC for my client on oracle SOA using SOAP UI. It is throwing me an exception "Failed to init connection for drvr , connectionString"

    I used the jdbc connection as mentioned by you in the File-->preferences-->JDBC Driver Properties-->Connection String Template
    Ex:jdbc:oracle:thin:apps/apps@HOST:o2c.net:PORT:2223:o2c
  • srkolluri's avatar
    srkolluri
    New Contributor
    15 years ago
    srkolluri wrote:
    srkolluri wrote:
    omatzura wrote:
    Hi,

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

    jdbc:oracle::@::

    for example

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

    does that help?

    regards,

    /Ole
    eviware.com


    hi,
    i am trying to do a POC for my client on oracle SOA using SOAP UI. It is throwing me an exception "Failed to init connection for drvr , connectionString"

    I used the jdbc connection as mentioned by you in the File-->preferences-->JDBC Driver Properties-->Connection String Template
    Ex:jdbc:oracle:thin:apps/apps@HOST:o2c.net:PORT:2223:o2c


    Hi Ole

    It would be a great help if we get any help with the authentication issue.

    Rao