Forum Discussion

saurabhpb's avatar
saurabhpb
Occasional Contributor
11 years ago

Need help to run spatial queries on Spatialite db

Hello,

I need to validate a service response and the back end is spatialite db(.sl3) file.
I am using a JDBC type-2 driver for this and have been able to get it working successfully in eclipse through groovy code(Please find attached the same).
the driver comes packages as a JAR file and few .dll files.
the jar file has been places at C:\Program Files\SmartBear\SoapUI-Pro-5.1.1\bin\ext folder and is getting added to class path at soapui load.(referred soapui log)
the .dll files location have been added to Windows PATH system variable.
however Nothing happens when the same code which works in eclipse is run through Groovy Script step in soapui GUI.
no errors/warnings are captured in logs.
I have below queries regarding the same:-
1. Does soapui-pro support jdbc type-2 driver ?
2. If yes then where should i put the additional .dll files which comes packaged with the driver?
3. Do I need to specify the .dll files path somewhere in soapui-settings/vmoptions file so that soapui can pick it up.(I guess soapui doesn't refers to Windows PATH system variable)

any help in this regard is appreciated.

Thanks,
Saurabh

3 Replies

  • saurabhpb's avatar
    saurabhpb
    Occasional Contributor
    11 years ago
    Hello,

    It would be great if someone could reply to my questions.
    I am kind of stuck right now.

    Thanks,
    Saurabh
  • saurabhpb's avatar
    saurabhpb
    Occasional Contributor
    11 years ago
    Hello,

    I've been using soapui-pro since more than 1.5 yrs now and always been fan of soapui support as got response quicker than anticipated.
    Haven't faced such a lazy attitude till now and truly speaking am very disappointed
    I've posted few queries and need response for those doesn't matter whether it is a YES or NO with simple reason.
    This will help in to take my next course of action for my problem.

    Thanks,
    Saurabh
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    11 years ago
    Hi,

    Sincere apologies for the late response for this post. If you are not getting a response (such as days have gone by) then please open a support ticket as we may have overlooked this, http://www.soapui.org/Support/support-overview.html.

    The dll libraries have to be in a directory on the java.library.path property. Usually adding them to a directory on the system PATH variable will work, but you will need to double check that the directory is on the java.library.path in SoapUI Pro by going to Help -> System Properties and checking the java.library.path property.


    Regards,
    Marcus
    SmartBear Support