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

pentaho local and remote connection to sql server

This is giving me headache. I just set up pentaho community edition on my laptop. I was able to connect to mysql server in xampp by following the instructions in the pdf documentation that comes with the enterprise edition…
flexxxit
  • 2,440
  • 5
  • 42
  • 69
0
votes
1 answer

Failed build in Jenkins: cannot resolve sqljdbc4 jar

I have started configuring Jenkins with my project. I made sure to install the sqljdbc driver in my local repository first: $>mvn install:install-file -Dfile=sqljdbc4-4.0.jar -DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=4.0…
DPM
  • 1,960
  • 3
  • 26
  • 49
0
votes
1 answer

SQL server 2012 jdbc driver for jdk 1.4

I need SQL server jdbc driver jar file which is compatible with jdk1.4 and sql server 2012. I am using sqljdbc3 which is not compatible with jdk1.4 and jboss 4. Any help will be appreciate.
Ruchi
  • 5,032
  • 13
  • 59
  • 84
0
votes
1 answer

java.lang.ClassNotFoundException on TCP Server

I'm writting a basic TCP Server in java with Eclipse, and I'm trying to execute a MSSQL Stored Procedure after receiving an specific packet from the client. I'm able to log everything, but when I try to insert the row, this error…
leandronn
  • 173
  • 1
  • 17
0
votes
1 answer

Cannot connect jdbc to sql server 2008 r2

I am using sql server 2008 r2 sql express. I usually connect to my sql like this: Now I want to connect to sql server 2008 r2 from my eclipse. I searched google and I found that I have to download a jar file and I did and I added it to my project…
0
votes
1 answer

Unable to run Stand alone Java Swing application in different machines

I have created a Java Swing application in eclipse. And I have packaged the application into Runnable JAR with the help of Eclipse Export functionality. But I am unable to run the JAR in other machines. In my system it is working fine. How to make…
JavaBits
  • 2,005
  • 11
  • 36
  • 40
0
votes
0 answers

Windows authentication with SQL Server using Java

Follow up to this question: https://stackoverflow.com/a/12304934/866785 I am also trying to connect to SQL Server 2008 R2 with Windows Authentication using Java. I have set the PATH variable to include C:\Program Files\Microsoft JDBC Driver 4.0 for…
0
votes
2 answers

SQL Server JDBC: unable to create new native thread

We are using Microsoft's sqljdbc driver 1.2 in combination with Hibernate under Windows. Occasionally we are getting an OutOfMemoryError from the JDBC driver although plenty of memory is still available in the JVM heap. Here's a stack trace of the…
sakra
  • 62,199
  • 16
  • 168
  • 151
0
votes
1 answer

Elastic Search unable to find SqlServer Jdbc driver

I have installed Elastic Search on an AMazon Ec2 Windows Instance (Windows Server 2008 x64) using the setup available here I was using this blog post as a reference. I was able to successfully install and communicate with elastic search. Now I am…
shashi
  • 4,616
  • 9
  • 50
  • 77
0
votes
1 answer

Manifest.MF issue with MSSQLSERVER 2008 and Groovy

I have created a simple Groovy project in GGTS IDE that connects to Oracle and SQLServer. The Program runs fine within the IDE but when I run the program through the command line I seem to get some sort of enconding error in MANIFEST.MF?. See the…
Viriato
  • 2,981
  • 7
  • 40
  • 54
-1
votes
1 answer

How to test SQL Server connection properties

I have a Java application that interacts with a SQL Server database. I want to write some unit tests to test the connection properties like lockTimeout, queryTimeout, loginTimeout and socketTimeout etc. What would be the best way to test the above…
Abdul Waheed
  • 383
  • 1
  • 4
  • 20
-1
votes
1 answer

JDBC jar added to Classpath still receiving error

I'm testing my connection to a database. I cannot get this to compile properly. I have added the sqljdbc4.jar to the classpath via the Intellij IDE (perhaps it was done incorrectly?) but it is showing up under Classpath from Open Modules under the…
lnjblue
  • 140
  • 1
  • 13
-2
votes
1 answer

ClassNotFoundException Class.forName() in android

try { String url = "jdbc:sqlserver://Aman\\SQL12;databaseName=P2C_Android"; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn = DriverManager.getConnection(url, "sa", "aman"); String sql = "select * from…
1 2 3 4 5
6