JDBC

3 Topics

[Solved] [JDBC] Cannot connect to a MS SQL database
Hello. I'm having issues connecting to a MS SQL database with JDBC. I went to the JDBC drivers page and saw that there isn't a download link for MS SQL driver. So I went to the Microsoft website and downloaded the Microsoft JDBC Drivers 6.0, 4.2, 4.1, and 4.0 for SQL Server. I extracted the file and added both sqljdbc.jar and sqljdbc4.jar (individually) but whenever I try to test the connection I get the following error message: com.eviware.soapui.support.SoapUIException: Failed to init connection for driver [com.microsoft.sqlserver.jdbc.SQLServerDriver], connectionString [jdbc:microsoft:sqlserver://HOSTNAME\SQLExpress:3306;databaseName=MYDB;user=USER&password=PASS] I checked the SoapUI log and the drivers are being loaded. For example: Mon Dec 05 08:08:21 PST 2016:INFO:Adding [C:\Program Files\SoapUI-5.2.1\bin\ext\sqljdbc.jar] to extensions classpath According to the error log, it seems that the driver loaded isn't the correct one: Mon Dec 05 08:35:48 PST 2016:ERROR:java.sql.SQLException: No suitable driver Obviously I'm doing something wrong here. Can someone help to me to understand where I'm making the mistake? If it helps, the db connection works (checked with MS SQL Server Manager) and I was able to connect to a MySQL db using SoapUI (different db though). Thanks for reading and I appreciate any advice you may have!
Solved
Xour
8 years ago Place SoapUI Open Source Questions
24KViews
0likes
20Comments
can we use regex function in JDBC test step
Hi, I am using open source SoapUI tool . trying to retrieve DB result using JDBC step. Below is the query, I used -SELECTregexp_replace(current_bill_cycle_amount::text,'^(-??\\d*?\\.\\d*?)0*\$','\1')current_bill_cycle_amountfrom liability.creditcardstatement ; getting error message as -Tue Sep 13 14:32:07 IST 2016:ERROR:org.postgresql.util.PSQLException: No value specified for parameter 1. DBName - PostgreSQL When I tried wothout regex function, i am getting response from DB. Any one please suggest, whether I can use regex function in JDBC step or not. Same query is working in postgresql and getting expected response.
vinay86nagariya
9 years ago Place SoapUI Open Source Questions
673Views
0likes
0Comments
JDBC connectivity to SQL Azure using SoapUI Basic.
Hi , This is regarding JDBC connectivity to SQL Azure using SoapUI Basic. I was referring to Azure site to get the relevant driver and connection string. (https://azure.microsoft.com/en-us/documentation/articles/sql-database-develop-java-simple-windows/) . I downloaded SQLJDBC driver (version4.2) and added its jar to ext folder of SoapUI . For my SoapUI project i added a JDBC step with driver (com.microsoft.sqlserver.jdbc.SQLServerDriver) and connection string (jdbc:sqlserver://<myServer>.database.windows.net:1433;database=<mydatabase>;user=<myusername>;password=<mypassword>;encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30; ). My machine's port 1433 is open to make such communication. I am able to make connection through my eclipse editor using same string but this is not working through my SoapUI JDBC step or script step . I am neither able to see any error or logs for this , neither able to track any such TCP message sent through my machine. Can you please suggest if I am missing out anything here. Thanks, Arun
Solved
Arun05
10 years ago Place SoapUI Open Source Questions
2.6KViews
0likes
1Comment