Stack Overflow
Stack Overflow

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

How to create an iterator for an aliased projection of select?

When you have a query like this: select A,B from MYTABLE where C='1' you just declare the following: #sql iterator Cursor(String A, String B); But what if you have a query like this one? select T1.A, T1.B from MYTABLE T1 where C='1'
Phate
  • 6,066
  • 15
  • 73
  • 138
0
votes
0 answers

Maven not building sqljdbc intelliJ

I am trying to build my maven project in IntelliJ. I added the dependency in the pom file as shown. com.microsoft.sqlserver sqljdbc4 4.0 …
Kabhi
  • 135
  • 1
  • 12
0
votes
2 answers

The Good way to create pentaho cde dashboard

Pentaho version : bi server CE 6.1 I'm new to pentaho universe and I found myself stuck in finding documentation to create a cde dashboard. Just to be clear, I have no idea of what is the good way to create cde dashboard, but i tried many things…
Harold TAMO
  • 9
  • 4
0
votes
1 answer

Azure VM Fails to Connect to Azure SQL Service

I am receiving the below SSL error from a SonarQube service I'm running on an Azure VM using an Azure SQL Server instance that is defined separately in the Azure Portal (and not within the VM). Is there some configuration I'm missing around the SSL…
Andrew Bernhagen
  • 325
  • 4
  • 16
0
votes
1 answer

WebLogic 12c classpath location + sqljdbc42 driver?

I am not able to find the WebLogic CLASSPATH variable in either of these two files - commEnv.sh and commEnv.cmd. I do not understand where to add sqljdbc42 nor how to connect to an Azure SQL Server Database (is that even possible)? I downloaded…
Boris
  • 566
  • 5
  • 21
0
votes
2 answers

"ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver" when running .class directly from command line

I know this has been asked a million times, I looked up 100's of links all point to what I am doing, but I am not able to get this working. Code: import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import…
blablabla
  • 225
  • 1
  • 3
  • 10
0
votes
0 answers

Using windows authentication in sqlserver with a different user than the logged in user

I have been so far using jtds driver for sqlserver using the following connection string. jdbc:jtds:sqlserver://hostname:15001;databaseName=MYDB1;useNTLMv2=true;domain=CORP; Note that database is using windows authentication. However the domain,…
gpothan
  • 151
  • 7
0
votes
1 answer

sqljdbc4 2 on Glassfish server4 1

I am running my java web application on glassfish server v4.1 in netbeans v8.0.2, using sqljdbc42 and this connection code- Connection connection; String url = "jdbc:sqlserver://localhost:1433;databaseName=Lista;integratedSecurity=true"; …
Khairul Islam
  • 1,207
  • 1
  • 9
  • 20
0
votes
1 answer

ClassNotFoundException while attempting to connect SQL Server through rest API?

I have a rest API service deployed which has a method where it attempts to connect to SQL Server. Locally before deployment, this all worked fine but now I get the error that the Sqljdbc file is missing. Below is the exception java web service…
vbNewbie
  • 3,291
  • 15
  • 71
  • 155
0
votes
1 answer

Tomcat: Error while hosting two webapps => Native Library sqljdbc_auth.dll already loaded in another classloader

I have read all the similar posts on SO but I still run into the same problem. I have two applications that run off of the same Tomcat instance. If I access either one on the browser it works fine, but as soon as I try to access the second one, I…
Luis Delgado
  • 103
  • 1
  • 6
0
votes
1 answer

SQLJDBC driver is not supported by JRE 1.7

I am trying to develop RESTful JAVA web service using Netbeans and MS SQL Server 2008 as DBMS. I am registering sqljdbc4.jar as a driver but still it is showing me this error while deploying the project. I tried all the options available online and…
joshiparas
  • 141
  • 1
  • 1
  • 8
0
votes
1 answer

Unable to connect to SQL server using Windows Authentication from Java application in Eclipse

I have 64 bit operating system. I am trying to connect to SQL server from a Java application using windows authentication. When i have used integrated Security=true, I have place the sqljdbc_auth.dll in windows/ System 32 folder. But still I am…
Shruthi Chandra
  • 1
  • 1
0
votes
1 answer

Unable to write write data to excel sheet with row no constant and increasing cell no

I have Written a Java Program to fetch data from SQL and write the same to Excel sheet, the following program works only if I uncomment the line i don know Why it is happening like that please help me to correct the Program. package…
GovindND
  • 3
  • 4
0
votes
1 answer

how to install jdbc driver for sql server

Hi I am new to eclipse ; I am trying to do example of nhibernate ; I downloaded sqljdbc4jar and uzipped it but when I double click to install it is not installing and no messages on windows 7 why it is not installing.however in windows 8 i am…
kobosh
  • 483
  • 2
  • 7
  • 23
0
votes
0 answers

Run a 32 bit dll on 64 bit system

I have a 32 bit .dll (sqljdbc_auth.dll) and develope on a 32 bit jdk. My System is 64 Bit. It works all the time, but now i create a runnable jar file, this file can be execute. But when i started it over a Batch File (-jar…
user3808286
  • 31
  • 8
1 2 3 4
5
6