Top "Mssql-jdbc" questions

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

Pentaho data integration: jdbc connection to MS SQL Server not working

With the community edition of Pentaho Data Integration - Kettle 5.0.1 (http://community.pentaho.com/projects/data-integration/) I could connect to …

jdbc pentaho kettle mssql-jdbc
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 …

java sql-server sql-server-2008 jdbc mssql-jdbc
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 …

sql-server server wildfly wildfly-10 mssql-jdbc
How to convert MYSQL query into MSSQL query

I've 700+ MySQL queries and now trying to create same set of queries in MSSQL. I want to generate MSSQL query …

mysql sql-server mysql-workbench mssql-jdbc
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'DTYPE'

I am trying to make Single Table Inheritance into the Hibernate, but I am getting an error and I'm not …

java hibernate jdbc single-table-inheritance mssql-jdbc
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 …

sql-server mssql-jdbc
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 …

sql-server mssql-jdbc
jdbc.SQLServerException: The "variant" data type is not supported

I use pyspark 2.4.4 when I am getting the data from SQL Server I get com.microsoft.sqlserver.jdbc.SQLServerException: The "…

python sql pyspark mssql-jdbc