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

MSSQL 2008: JDBC URL database selection

Microsoft SQL Server 2008 R2. Created login user. Default database is set to 'master'. Created a database named 'slave'. Use JDBC URL jdbc:sqlserver://localhost:1433;databaseName=slave All operations performed with this URL are going to the…
user3379996
  • 1
  • 1
0
votes
1 answer

Microsoft SQL Server 2005 - DVWA - SQL Injection

I am back again with another question regarding dvwa, I've upgraded to MsSQL 2005 this time, and I have another set of questions. I don't understand a couple of things. I would like for some kind individual to make it clear to me. So basically, as…
user3267146
  • 317
  • 2
  • 10
0
votes
1 answer

MS SQL JDBC: set connection URL parameter to disable foreign-key checks

Exactly like here I want to disable the foreign key check when modifying the database. However I can't get it to work. If I try this: jdbc:sqlserver://myserver:1433?sessionVariables=FOREIGN_KEY_CHECKS=0 It will try to take the whole…
bobbel
  • 461
  • 6
  • 18
0
votes
5 answers

Could not find the main class.How can I fix this?

I am writing java code.When I click myapp.jar I got this error: Could not find the main class. In my code there is a public static void main(String[] args) and in netbeans when right click on the project and run options I set main class. This error…
CompEng
  • 7,161
  • 16
  • 68
  • 122
0
votes
1 answer

java.lang.ClassNotFoundException on TCP Server

I'm writting a basic TCP Server in java with Eclipse, and I'm trying to execute a MSSQL Stored Procedure after receiving an specific packet from the client. I'm able to log everything, but when I try to insert the row, this error…
leandronn
  • 173
  • 1
  • 17
0
votes
1 answer

Unable to connect to MS SQL Server 2008 using a JAR from command prompt but runs successfully in Eclipse

I am trying to connect to SQL Server 2008 using sqljdbc4.jar and could successfully connect using Eclipse. But when i export my code as a JAR and try to run it using command prompt, i get error : D:\Eclipse\TestDBJar>java -Djava.ext.dirs=lib -jar …
Divya Motiwala
  • 1,659
  • 1
  • 16
  • 24
0
votes
1 answer

Manifest.MF issue with MSSQLSERVER 2008 and Groovy

I have created a simple Groovy project in GGTS IDE that connects to Oracle and SQLServer. The Program runs fine within the IDE but when I run the program through the command line I seem to get some sort of enconding error in MANIFEST.MF?. See the…
Viriato
  • 2,981
  • 7
  • 40
  • 54
-1
votes
2 answers

Java code not inserting data into MySQL database despite no errors

I am facing a java.lang.ClassNotFoundException error with the message com.mysql.cj.jdbc.Driver when attempting to run my Java code for data insertion into a MySQL database. Surprisingly, the code compiles and runs without any errors, but the data is…
Nil65
  • 1
  • 1
-1
votes
2 answers

Delete tables using SQL query based on table name

I have 1000 tables in my SQL Server database. Table names like CIP_01_12_2022_10_15_20 that I have 1000 table. Table name saved as data time(CIP_DD_MM_YYYY_HH_MM_SS). So I need to delete like between particular dates. Tables named like…
Cric News For Fans
  • 19
  • 5
-1
votes
1 answer

Is there any way to load analytics-dashboard wso2 with mssql DB?

I am using the MSSQL database for WSO2 API manager 3.2.0 and want to use analytics. When I changed the database to MSSQL, this error appeared. How can I solve this problem?
nahid afzali
  • 73
  • 1
  • 8
-1
votes
1 answer

AWS RDS Instance is not connecting to Jmeter

I am trying to connect my RDS instance to a Jmeter load test however no matter what I try, I keep getting this error message in the Results Tree: Cannot create PoolableConnectionFactory (The connection to the host…
Prassana K
  • 41
  • 1
  • 3
-1
votes
2 answers

Error converting varchar to number 123,456

I am trying to do a bulk insert from csv into a SQL Server database. Here is a snippet of a part of the query. The data for this column in the CSV is in the format 123,345 with commas (it could also be null, or without any digit separator), I…
Lovely Sakariah
  • 1
  • 2
-1
votes
1 answer

System.ArgumentException: 'No mapping exists from object type System.Web.UI.WebControls.TextBox to a known managed provider native type.'

protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-0ADOEDB\SQLDEV2019;Initial Catalog=WebApplication;Integrated Security=True"); SqlCommand com = new SqlCommand("Insert into…
Dee
  • 11
  • 1
-1
votes
1 answer

Which datatype can be used to insert this record in MS SQL Server?

I am trying to insert a row: INSERT INTO [dbo].[Worker] ([Worker_id], [FIRST_NAME], [LAST_NAME],[SALARY], [JOINING_DATE], [DEPARTMENT]) VALUES (001, 'Monika', 'Arora', 100000, 2014-02-20 09:00:00, 'HR') I used DateTime / SmallDateTime / Date…
Shripad Kumar
  • 47
  • 6
-1
votes
1 answer

Android : SQL Server Checking login details programmatically

I have a price checker app that the user want to insert it's server details from a setting page (ip, user and pass). They asked to have the app notify them if the connection was successful or was the details incorrect once they input the data into…
Saher Al-Sous
  • 517
  • 4
  • 15
1 2 3
…
40 41