640 questions
1
vote
1
answer
27
views
Looking for a correct way to validate mssql Query
public Mono<String> queryValidation(String connectionId, String query) {
return connectionConfigRepository.findByConnectionId(connectionId)
.switchIfEmpty(Mono.error(new ...
- 11
0
votes
0
answers
33
views
Databricks large table to SQL Server via jdbc fail
I am trying to migrate a 700 million rows table to SQL Server via jdbc. The cluster is 2 workers with 32 cores in total and a driver node with 8 cores.
df = spark.read.table("xxx.xx.xxx")
...
- 457
0
votes
1
answer
95
views
Pyspark SQL Server via Linux with IntegratedSecurity using JDBC
I am trying to connect to a SQL server database via a linux server. They are in the same domain and I am able to access it via ODBC driver.
When I try to connect using the Microsoft SQL Driver I am ...
1
vote
1
answer
83
views
Debezium JDBC sink Connector and MSSQL varbinary
I have Debezium 3.0.8. I setup source SQL connector, which produce data from CDC SQL Server (MSSQL). Trying to setup io.debezium.connector.jdbc.JdbcSinkConnector for a table with varbinary field
...
- 2,509
1
vote
0
answers
46
views
Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL despite adding the jdbc jar files in jmeter\lib
I've been trying to run some load testing scripts through JMeter, but I keep running into this error:
Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL ...
- 11
0
votes
0
answers
234
views
Version was not updated on mssql-jdbc_auth-12.8.1.x64.dll or mssql-jdbc_auth-12.8.0.x64.dll
I was trying to set the source for the AWS SCT tool and my source was SQL server with windows auth. It asked for the JDBC file and I provided it with the file I downloaded. When asked for windows ...
0
votes
0
answers
62
views
How can I use sql in a jenkins pipeline job?
In my jenkins pipeline job I need to connect to a ms sql db and fetch some data, something like the below:
pipeline {
stages {
stage('Fetch Data from Database') {
steps {
...
- 383
-1
votes
1
answer
64
views
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder" - JDBC Class Path [duplicate]
Not really familiar with Java, but the Interoperability Engine we use provides us with Adapters we can use to connect to Database using JDBC. In the past we just had to define the Class Path with the ...
- 21
0
votes
0
answers
107
views
New to Maven and MSAL4J - Installation issues
Currently I have a RedHat linux server, that uses JDBC to connect to MS SQL (on prem) using a Active Directory Account for Authentication.
Our company wants to move the MS SQL from on prem to Azure ...
- 21
-1
votes
1
answer
260
views
MSSQL jdbc - The driver could not establish a secure connection to SQL server using SSL encryption. Error: Unexpected rethrowing [duplicate]
I'm using springboot with Java 15. The version for the jdbc driver is not mentioned in the POM file.
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-...
- 361
1
vote
0
answers
89
views
Why Hibernate and mssql jdbc driver generating VARCHAR(8000) for a column annotated with @Column( length=4000, columnDefinition = "VARCHAR(4000)")?
I am using hibernate 5.6.15 Final, SQLSERVER2016DIALECT, and mssql-jdbc-9.4.0.jre8.
I have declared following field defintion in my entity class:
@Type(type = "org.hibernate.type.StringType")...
- 11
1
vote
1
answer
81
views
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver while running JAR on google Dataproc cluster
i have the driver dependency in the POM.xml and i am using maven shade plugin to create an Uber Jar. i do see the driver dependency correctly listed in the JAR file. Jar runs fine in intellij but on ...
- 81
-1
votes
1
answer
716
views
Connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource". Integrated authentication failed
I'm trying to connect from webmethodsV10.7 (runs in Linux) to a remote hosted SQL Server via Windows authentication (that is user setup is done in Windows authentication using Active Directory for the ...
- 9,732
2
votes
2
answers
69
views
What exception do we get from SQL Server and Sybase jdbc driver just like we get for Oracle JDBC driver-Numeric overflow exception from rs.getLong()
I have a Spring Boot application in which I am connecting to SQL Server, Sybase, Oracle and MySQL database to get metadata details. While collecting rows count of a tables with below code in Oracle
...
- 127
0
votes
1
answer
134
views
TypeError: Class com.microsoft.sqlserver.jdbc.SQLServerDriver is not found
I'm trying to connect to a MMSQL Database through python in a Jupyter environment with the addition of a JDBC Driver. Although everything should be set up in a correct manner the Error Message "...
- 1