When I scan my database, it shows one of the result like VA1143 'dbo' user should not be used for normal service operation in A Vulnerability Assessment scan They have suggested to "Create users ...

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 [email protected] gyp info using [email&#16...

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 cod...

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,'2...

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 [TL...

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 ...

I want to read filtered data from a Mysql instance using AWS glue job. Since a glue jdbc connection doesnt allow me to push down predicate, I am trying to explicitly create a jdbc connection in my ...

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've added Ubuntu 20.04 under AD Domain controller and have installed MsSQL Server on Ubuntu machine. My sqlcmd localhost works perfectly with windows authentication $ sqlcmd -S localhost 1> sel...

I am trying to use the SQL Server integratedSecurity (jdbc: sqlserver: //x.y.z.w; databaseName = TEST; integratedSecurity = true) with java 1.8 on Linux but I get the following error: no mssql-jdbc...

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 Bu...

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.

I have a SpringBoot app, where I use jdbcTemplate to insert a row to a mssql int numOfRowsAffected = remoteJdbcTemplate.update("insert into dbo.[ELCOR Resource Time Registr_] " + "( [Entry No_], ...

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 ...

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...

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 ...

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 <DIR> . 03/07/2014 09:38 AM &lt...

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<Student> stuList = new ...

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 | constrain...

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 recur...

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...