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
20
votes
3 answers

ClassNotFoundException upon running JAR, no errors while running in IntelliJ IDEA

I'm just starting to build Java apps (I do have .NET experience) and I was trying to build a small test app whose whole code is this : package com.company; import com.microsoft.sqlserver.jdbc.SQLServerDataSource; import java.sql.Connection; import…
Andrei Rînea
  • 20,288
  • 17
  • 117
  • 166
16
votes
6 answers

jboss 7 AS datasource for sqlserver

I run jboss in standalone mode and have set my datasource in the standalone.xml to the following:
Marthin
  • 6,413
  • 15
  • 58
  • 95
13
votes
2 answers

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

I used this code to create a connection to SQL Server. String connectionUrl = "jdbc:sqlserver://IP:1433;" + "databaseName=db;user=db;password=pwd"; Connection con = null; try { // Establish the connection. …
Mojtaba Mahamed
  • 495
  • 2
  • 4
  • 18
9
votes
2 answers

Java7 sqljdbc4 - SQL error 08S01 on getConnection()

I'm trying to write a really simple GUI app for inserting some records into a database, and reading back some records (nothing fancy, just 1 table with 3 rows, no relations). The source... package EntryProg; import java.sql.*; import…
Tyler W
  • 472
  • 1
  • 6
  • 21
9
votes
2 answers

sqljdbc : JDBC driver sqljdbc.jar Vs sqljdbc4.jar

I have a query regarding the jars sqljdbc.jar and sqljdbc4.jar which are used to connect to MS SQL Server 2005 for the systems where the JDK version 1.5 & 1.6 respectively. Now I would like to know, how these jars interpret the column whose datatype…
user968804
  • 91
  • 1
  • 1
  • 3
9
votes
1 answer

org.h2.jdbc.JdbcSQLException: Schema "DBO" not found

This is a follow up question of Hibernate version mismatch in WildFly 10.0. For completeness, restating the problem briefly. I have 2 projects, one is a normal java project (with maven): core, and the other is non-maven dynamic web project: webapi.…
Sayan Pal
  • 4,768
  • 5
  • 43
  • 82
6
votes
1 answer

Issues getting JTDS driver to accept sendStringParametersAsUnicode=false?

Been using net.sourceforge.jtds.jdbc.Driver as my driver from MSSQL for all my applications. I had trouble with performance in a prepared statement, and learned that sendStringParametersAsUnicode=false should fix the problem. Unfortunately, I can't…
javatestcase
  • 682
  • 1
  • 10
  • 25
5
votes
3 answers

This driver is not configured for integrated authentication

Trying to connect my java web application with MS-SQL server using sqljdbc41 for jdk 1.8. Here is the database connection code- Connection connection; String url =…
Khairul Islam
  • 1,207
  • 1
  • 9
  • 20
5
votes
3 answers

Getting ClassNotFoundException on code: "Class.forName("com.microsoft.sqlserver.jdbc.SqlServerDriver");"

This is my first Java application and I'm completely inexperienced with Java and NetBeans. I have been trying to connect to sql and get some records for 2 days. The problem is about jdbc driver, let me explain. I have downloaded sqljdbc driver and…
user2708377
  • 55
  • 1
  • 1
  • 4
4
votes
2 answers

mssql-jdbc MS SQL Server JDBC driver prepared statement cache performance issue with Hikari CP

We have been converting our server from using Hibernate 4.2 to Hibernate 5.2. Hibernate 5.2 requires JDBC 4.2 (Java 8), which requires us to switch to Hikari CP connection pool which is a branch from the (now deprecated) Bone CP we were previously…
Roger D
  • 41
  • 2
4
votes
1 answer

Adding .jar to Grails Dependencies of a Project

I have this project having MSSQL 2008 R2 as its database server. The connection between the Services view of IReport and the database is established and running. The problem here is that the project cannot connect to the database server when running…
David B
  • 3,269
  • 12
  • 48
  • 80
3
votes
1 answer

Can not connect to sqlserver with Bouncy Castle Fips Provider using to run the JSSE in FIPS mod

I am in Java 8 v102, using sqljdbc42.jar and jtds-1.3.1.jar to connect to SQL Server 2008 in FIPS mode. I configured my Java with https://www.bouncycastle.org/fips/BCUserGuide.pdf, but I am getting the below error. How can I resolve…
Saiket Tewary
  • 99
  • 1
  • 1
  • 3
2
votes
1 answer

Is Java 8 with Glassfish 2.1.1 possible?

As the title says, is it possible? Right now, we have Java 6 + sqljdbc4 + glassfish 2.1.1. We're planning on upgrading our Java 6 to Java 8 in order for Sqljdbc42.jar to work, because we are having JDBC Connectivity issue and the solution might be…
Cyberpau
  • 125
  • 9
2
votes
1 answer

Unable to instantiate driver class "com.microsoft.sqlserver.jdbc.SQLServerDataSource" - Failure deploying sqljdbc4.jar in Wildfly 10

I have big issues using sqljdbc4.jar in Wildfly 10. When I start the server I get the following issue: Unable to instantiate driver class "com.microsoft.sqlserver.jdbc.SQLServerDataSource" ... and several exceptions ... 08:32:12,570 ERROR…
Starburst
  • 33
  • 1
  • 6
2
votes
0 answers

setting socket-timeout not seems to be effective when making jdbc connection

I need to set the socketTimeout property when establishing the connection from database using jdbc. I am using sqljdbc4 to connect with SQL SERVER 2008 R2. Here is my code. java.util.Properties info = new…
Ashish Pancholi
  • 4,569
  • 13
  • 50
  • 88
1
2 3 4 5 6