Questions tagged [sqljdbc]

Microsoft JDBC Driver for SQL Server

Microsoft JDBC Driver

Sql JDBC is the Microsoft JDBC Driver for SQL Server. It is a Java Database Connectivity (JDBC) driver for use with SQL Server, SQL Azure, and Parallel Data Warehouse (PDW). The Microsoft JDBC Driver for SQL Server provides Java Database Connectivity from any Java application, application server, or Java-enabled applet.

This driver is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs). It has been tested against major application servers such as IBM WebSphere, and SAP NetWeaver.

Related tags:

88 questions
0
votes
0 answers

Unload a dll loaded by a classloader in Java11

I had a scenario where I need to perform database connectivity using Java11 twice using Windows Authentication on SQL server. Initially, the sqljdbc_auth.dll is loaded for the first call and the connection was successful. But, in order to make the…
0
votes
1 answer

Intelij Java Connection to mysql not working

I want to create a test to retrieve/update database entries.I am pretty new in automation testing and never used a connection to DB. For that I have a local connection with user and password and Northwind database installed. Everything is working…
jmx123
  • 1
0
votes
0 answers

JAVA Runnable .JAR File incomplete execution. Eclipse IDE Runs to completion

Running into an issue with a JAVA application that I'm hoping someone can provide some clarity to. I have a simple Java Application which is being built in the Eclipse IDE. I have JRE 1.8.0_251 installed on PATH. My application at a basic level…
sallou
  • 99
  • 9
0
votes
1 answer

JMeter - SQL Server - Cannot create PoolableConnectionFactory

JMeter 5.3.0 Trying to use the JDBC Connection Configuration. Downloaded SQL Server JDBC libraries (sqljdbc8.2.2.0). put JAR files in {jmeter}\lib\ put sqljdbc_auth.dll in {jmeter}\lib\ also tried idea of using a library path in jmeter.bat as per…
Guy
  • 666
  • 1
  • 10
  • 34
0
votes
1 answer

Getting error on connecting to a local SQL Server database to databricks via JDBC connection

Basically I'm trying to connect to a SQL Server database on my local machine from databricks using a JDBC connection. I'm following the procedure mentioned in the documentation as shown here on the databricks website. I used the following code as…
astroluv
  • 798
  • 1
  • 8
  • 25
0
votes
0 answers

How to give path of sqljdbc_auth.dll in arguments while running a jar file from cmd?

Is there a way to give path of "sqljdbc_auth.dll" in command line arguments while running a jar?
0
votes
1 answer

Java + include sqljdbc4.jar for continuous integration server

does anyone know how I can use the sqljdbc4 jar file inside a project but without setting it in the build path of the project inside Eclpise? I store my project in a source control repository and have a Countinuous Integration Server (Jenkins) to…
user706058
  • 415
  • 3
  • 11
  • 23
0
votes
1 answer

What version of sqljdbc do I require?

I am running in to an issue with my application where I get the error. The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response." I have…
ThisIsLegend1016
  • 105
  • 1
  • 4
  • 13
0
votes
1 answer

java.sql.SQLException: Invalid object name 'tablename' in android studio

I'm trying to Make a connection android studio to the database in SQL server 2014 , But this error appears : java.sql.SQLException: Invalid object name 'tablename' I use the :jtds 1.3.1 and :sqljdbc4-2.0 I connect a local network .
0
votes
0 answers

DB2 SQLJ - Questions on scrollable cursor

We have CICS app talk to DB2 on z/os. We were asked to mimic queries call to DB2 from JDBC using SQLJ as CICS uses static sqls. We are able to successfully do selects and cursors with DB2. Question: 1. Select statements: CICS issue fetch message to…
0
votes
0 answers

Why am I suddenly able to connect to the SQL Server with Java?

As I mentioned in a previous question, I'm working on a program that will connect to SQL Server for a simple search, using Windows authentication. I was able to set up the program with dropwizard to make a simple select query. However, I continued…
SVill
  • 331
  • 5
  • 22
  • 55
0
votes
1 answer

Sql Server query from java/hibernate randomly times out when called within a loop

I encounter a weird problem while trying to perform a sql query from a java call to sqlserver. A single call to the java function goes well, but when I do the same within a loop (from 2 to 30 iterations), I sometimes (not always) got such an error…
Marvin
  • 1,650
  • 4
  • 19
  • 41
0
votes
2 answers

Failed to connect to host MyServerName

Hi guys I am trying to connect NetBeans IDE with SqlServer, everything I did is correct, setting ports to 1433 in SQL Server Configurtion Manager and here is my code: public Db(String login,String password, String dbname) throws SQLException{ …
MJRLGUE
  • 55
  • 9
0
votes
1 answer

Mulesoft sqljdbc project will not run if native library location is set

I just began learning Mulesoft and want to put together a simple demo that uses sqljdbc to hit a SQL Server database with windows authentication. Articles I referenced: Connecting to MS SQL Server with MuleSoft Using Database Connector with…
0
votes
1 answer

Maven Build - Couldn't resolve dependencies

OS: OSX Yosemite Eclipse: Kepler Problems: 1. [ from Eclipse Run ] : maven-compiler-plugin is missing 2. [ from Command Line ] : Failure to find com.microsoft.sqlserver:sqljdbc4:jar:2.0 I have a maven project which pom.xml ( partly ) defined as…
Mad-D
  • 4,479
  • 18
  • 52
  • 93