Stack Overflow
Stack Overflow

Questions tagged [mssql-jdbc]

For specific questions on Microsoft's JDBC driver for their SQL Server product.

For specific questions on Microsoft's JDBC driver for their SQL Server product.

Microsoft JDBC Driver for SQL Server

Related tags:

603 questions
63
votes
14 answers

JDBC SQLServerException: "This driver is not configured for integrated authentication."

I am writing a "server-side extension" for SmartFoxServer (SFS). In my login script, I need to make a connection to MS SQL Server, which I am attempting to do using JDBC. I have tested the JDBC code in my debug environment, and it works…
Shaul Behr
  • 36,951
  • 69
  • 249
  • 387
17
votes
7 answers

stack "Error: self signed certificate in certificate chain" when trying to build 'node-gyp configure'

I got below error when trying to build the microsoft driver for nodejs for sql server gyp info it worked if it ends with ok gyp info using node-gyp@3.2.1 gyp info using node@5.3.0 | win32 | x64 gyp http GET …
Dilip Reddy
  • 339
  • 2
  • 4
  • 17
14
votes
5 answers

Which jar to use for connecting to MS SQL server

Can some one please guide me to understand which jar file i need to include in my application to be able to set up a jdbc connection with ms sql server. thanks in advance.
Amit
  • 716
  • 3
  • 8
  • 16
11
votes
1 answer

How to pass Table-Valued parameters from java to sql server stored procedure?

I have a Student class with the following attributes: Name, Department, Address, Grade. Now I have an ArrayList that contains some Student objects like this, List stuList = new ArrayList(); stuList.add(new Student("Tom","Comp",…
Umakanth
  • 686
  • 1
  • 5
  • 17
11
votes
3 answers

Inserting datetime into a MS SQL table using pyodbc

I'm trying to insert a datetime value into a MS SQL Server table using pyodbc. If I do it manually, something like: cursor.execute("""insert into currentvalue(value1,currentdatetime) values(55,'2014-06-27…
user3784140
  • 111
  • 1
  • 1
  • 3
9
votes
2 answers

MSSQL INSERT OR UPDATE if EXISTS

Need to insert a row if its not exist and update if exists. I've found this solution for MySQL: INSERT INTO table (id, name, age) VALUES(1, "A", 19) ON DUPLICATE KEY UPDATE name="A", age=19 But I can't find similar for MSSQL..
Dmytro
  • 245
  • 1
  • 5
  • 13
9
votes
4 answers

LocalDateTime and SQL Server JDBC 4.2 driver

I'm trying to use new java.time classes with most recent version of Sql Server JDBC driver. As I read it should just work with methods: PreparedStatement.setObject() and ResultSet.getObject(). So I created sample code, and can't get it work with…
Krzysztof
  • 517
  • 1
  • 4
  • 11
8
votes
5 answers

What can cause the SQL Server JDBC error 'The value is not set for the parameter number 0' for an output parameter access?

I have some Java code that accesses SQL Server 2005 which looks something like this: CallableStatement cstmt = ...; ... // Set input parameters cstmt.registerOutParameter(11, Types.INTEGER); cstmt.execute(); int out = cstmt.getInt(11); And the…
Matthew Murdoch
  • 30,874
  • 30
  • 96
  • 127
8
votes
3 answers

Unable to install/run SQL Server driver in WildFly 10

I am running my application on a WildFly 10 server. I do not wish to place my connection details on my application src codes thus am trying to place it inside WildFly 10 server itself. However I am facing issues. Under…
shadow
  • 800
  • 2
  • 16
  • 33
7
votes
0 answers

I can't make the sqljdbc work with AD username/password

I need to connect to High Availability (HA) / Desaster Recovery (DR), also known as HADR, enabled SQL server 2012 using AD account from Java on Linux. integratedSecurity is not an option since it runs on Linux I can not use the jTDS JDBC driver…
Hurda
  • 4,647
  • 8
  • 35
  • 49
7
votes
2 answers

will trigger for UPDATE on the Table will be recursive

I have trigger UPDATETRIGGER on table TEST, It was written to get called when the TEST table is updated. Now in this UPDATETRIGGER is updating a column of the same TEST table. Will this be recursive? My trigger and table is in MS SQL database. From…
Sudhakar Kummarasetty
  • 486
  • 1
  • 7
  • 15
6
votes
2 answers

Call stored procedure specifying only parameters with a value

In an instance of SQL Server 2016 I have a stored procedure with dozens of parameters. For example: CREATE PROCEDURE spName ( @par1 INT = NULL, @par2 VARCHAR(10) = NULL, .... .... @par98 INT = NULL, @par99 INT =…
Armando Contestabile
  • 147
  • 1
  • 10
6
votes
2 answers

SQL Server : hex to base64

I have a SQL Server database with jpeg images stored as hex (0xFFD8...) Is there a way to do a query where result will be in base64 instead of hex? I tried to google but I can't find anything like it :/
Stweet
  • 683
  • 3
  • 11
  • 26
6
votes
1 answer

How to get all constraint on table?

I want to store tables metadata into other table.So how to get all constraint and its type like whether it primary , unique or foreign key in MS SQL server. table_name | constraint_name | …
Shankar Modi
  • 71
  • 1
  • 1
  • 4
6
votes
6 answers

Classpath set, but: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Okay, I'm confused. My SQL Server JAR is here: Volume in drive C has no label. Volume Serial Number is 8008-2D93 Directory of c:\temp 03/07/2014 09:38 AM . 03/07/2014 09:38 AM .. 03/05/2014 10:34 PM …
Doug
  • 6,446
  • 9
  • 74
  • 107
1
2 3
…
40 41