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
4
votes
1 answer

RequestError: Validation failed for parameter- Invalid buffer

Hi I have an error with mssql on node.js, I have to insert a string containing a file in base64 in a database sql server 2014, but when I insert the code below I have the following error:RequestError: Validation failed for parameter 'Immagine'.…
riki
  • 1,502
  • 5
  • 17
  • 45
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

Parameter @x was not defined for stored procedure... with MS_SQL JDBC

I am trying to execute a stored procedure using SQL Server JDBC in a method: //Connection connection, String sp_name, Mapparams input to the method DatabaseMetaData dbMetaData = connection.getMetaData(); HashMap…
HBK
  • 735
  • 1
  • 11
  • 29
4
votes
1 answer

Microsoft SQL JDBC driver v6.2 returning incorrect SQL type code for DATETIME fields

Normally, ResultSetMetaData#getColumnType() should return 93 for DATETIME fields (usually represented as java.sql.Timestamp). This was indeed true for driver versions 4.2.6420.100 and 4.0.4621.201 (as well as jTDS). When using newer Microsoft JDBC…
Bass
  • 4,977
  • 2
  • 36
  • 82
4
votes
3 answers

Migrating from jTDS JDBC driver to Microsoft JDBC

Microsoft has recently released a new JDBC driver (version 6.0.7507.100) with some very interesting features. I am mostly interested in the TVP feature. This is why I would like to replace the current jTDS driver with the Microsoft driver. The…
dilbert elbonia
  • 173
  • 1
  • 2
  • 9
4
votes
2 answers

how to get has_many through: across servers working

I have a JRuby application that I am trying to create has_many through: relationships for databases that live on two completely different servers. I understand that joins will not work across tables on different servers. What I would like is to…
Nate
  • 12,963
  • 4
  • 59
  • 80
4
votes
1 answer

How to connect multiple database with reusing cfg.xml and util class?

I want to connect multiple databases like SQL and Oracle with different databases.So i already had MSSQL hibernate.cfg.xml and Hibernateutil class for session factory.Now i'm trying to connect oracle with different table. Please advise can i use…
user2848031
  • 187
  • 12
  • 36
  • 69
4
votes
1 answer

How can I use MS SQL Server's Integrated Authentication in IntelliJ IDEA 12?

I have several database connections configured in IntelliJ IDEA. I'm connecting to MS SQL Server 2000/2005. The connections use Integrated Authentication, with the SQLJDBC4 driver. I have the sqljdbc_auth.dll file in the same directory as the…
Raystorm
  • 6,180
  • 4
  • 35
  • 62
3
votes
1 answer

After update to spring boot 2.6.3 from 2.5.X hibernate does not work in some query syntax

someone could help me to solve this bug? i have update spring boot from 2.5.x to 2.6.3 and now the query like: @Query("select count(s.subjectId) from PreCheckEnquiredSubjectEntity s where s.key.requestId = :requestId and s.errors is not empty") …
Davide Boldrin
  • 204
  • 3
  • 15
3
votes
2 answers

How do I allow Java client TLS10 connections?

While attempting to do a hello world MSSQL JDBC connection in Eclipse with Java 16, I'm getting this error: "...server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]..." Upon searching, it appears my Java client…
Kevin
  • 2,296
  • 21
  • 22
3
votes
2 answers

Pyspark: java.lang.ClassNotFoundException: Failed to find data source: com.microsoft.sqlserver.jdbc.spark (SQL Data Pool)

I'm trying to load streaming data from Kafka into SQL Server Big Data Clusters Data Pools. I'm using Spark 2.4.5 (Bitnami 2.4.5 spark image). If I want to load data into regular tables, I use this sentence and it goes…
Emanuel Castelli
  • 53
  • 1
  • 1
  • 6
3
votes
0 answers

Pyspark data frame write to sql server performance issue

I am trying to export hive table into sql server using pyspark. Please look on below code. from pyspark import SparkContext from pyspark import HiveContext SparkContext.setSystemProperty('spark.jars',…
Tharunkumar Reddy
  • 2,773
  • 18
  • 32
3
votes
2 answers

com.microsoft.sqlserver.jdbc.SQLServerException: MSI Token failure: Failed to acquire token from MSI Endpoint

I want to Access the Azure SQL Database using App service API(Java) with MSI (Managed Service Identity) authentication. I am trying to find out the how to connect Azure sql with MSI from Azure App service for Java. Here is the connection string I…
Ammanuel g
  • 151
  • 2
  • 4
3
votes
2 answers

Wildfly 14 Microsoft SQL Server Configuration

I want to use MS SQL Server as a datasource in Wildfly 14, but I always get following error in the console: ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41) WFLYCTL0013: Operation ("add") failed - address:…
surfspider
  • 727
  • 3
  • 11
  • 25
3
votes
1 answer

When making JDBC Authentication in Spring Boot, do I have to use the default 'users' table?

I am trying to use JDBC Authentication in Spring Boot. I am trying to use a different table than the default 'users'. But with this method @Override protected void configure(AuthenticationManagerBuilder auth) throws Exception { …
sadesoda
  • 75
  • 5
1 2
3
…
40 41