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: 
sql-serversqljdbc
Questions tagged [mssql-jdbc]
603 questions
0
votes
3 answers
How do i test the table value function?
I just try to excute the below query .Its giving me
ERROR:
Msg 208, Level 16, State 3, Line 1
Invalid object name 'dbo.f_getPeopleTabRowCounts'.
SELECT *
FROM dbo.f_getPeopleTabRowCounts(7424,'YYYYYYYYYYYYY','abcd','Y');
Anyone can help…
Sitansu
- 3,225
- 8
- 34
- 61
0
votes
1 answer
Java - Setting jdbcType for parameters in mybatis 3
I am trying to work on setting jdbcType to the parameters i pass to my Ibatis queries. My backend tables have fields defined as varchar and mybatis framework seems to be converting String parameters that i'm passing
in my mapper.java to nvarchar.…
schinta2
- 23
- 5
0
votes
1 answer
How to check multiple Task completed or not in Sql query based on user input from webpage?
I have some list of Tasks in the table and each tasks has 'Completed' column some task may completed or may not completed. In webpage, I have textbox in that we can pass multiple Task names, I want to display messages to the user task is completed…
Tarun
- 25
- 1
- 6
0
votes
1 answer
SQL Server update column
I have a table A with columns of data type Varchar and columns name consists of:
MatricNo
Email
Name
Remarks
How can I update only one of the email if one MatricNo have more than one email?
If I am using below SQL statement I get a message 'No row…
Boom
- 19
- 1
- 6
0
votes
1 answer
SQLJDBC driver is not supported by JRE 1.7
I am trying to develop RESTful JAVA web service using Netbeans and MS SQL Server 2008 as DBMS.
I am registering sqljdbc4.jar as a driver but still it is showing me this error while deploying the project. I tried all the options available online and…
joshiparas
- 141
- 1
- 1
- 8
0
votes
1 answer
T-SQL Current and Previous Status
I have a Database where I am looking to get current room numbers and previous room numbers.
The data looks like this.
Table X
Name, room_number, Start_Date, End_Date, status
Bob, A1, 2015-04-03, null, transfer
Bob, B5, 2013-04-15, 2015-04-03,…
user1146822
0
votes
2 answers
I want update from one table to another table based on true or false condition
I have one table that contains several tasks which is belongs to some categories and one column called 'completed' which tells particular task is completed or not, based on this status I want to update as 'completed' for particular category in…
Tarun
- 25
- 1
- 6
0
votes
1 answer
Print to printer from a jsp page. Using a button to retrieve data from a database and printing
I'm creating this jsp page whereby I'm going to retrieve values from a database and send it to print on the printer. Like physical printers that print papers.
For example the table employee has name, id, age, position, etc. I'm going to retrieve the…
Sangkaran
- 38
- 1
- 7
0
votes
2 answers
class not found exception in java play framework
I am trying to create an app in play framework using ms sql server and java and i am getting [ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver] exception anyone please send me the link if u see a similar application .Just need to…
Sumeet Hiremath
- 67
- 9
0
votes
2 answers
Async Task giving error, for accessing web services?
***This is my main class***
This is my main activity code, it's not running and is giving errors!
I am trying to call a webserive that I made in Asp.net, But it is giving errors the webservice is working fine on website, should I first install a…
Syed Sharjeelullah
- 13
- 3
0
votes
2 answers
Ensuring no duplicate records being created in a table per particular column value
Consider the following scenario
Suppose there are three fields in a database table
------------------------------------------
PrmiaryKey | Column A | Column B
-----------------------------------------
I need to enforce that for values in Column B…
KPJ
- 79
- 5
0
votes
1 answer
MSSQL Query Executed But not updated in Table
I've both MYSQL and MSSQL and I tried in MYSQL its working but MSSQL query also executed but 0 rows are affected and checked in table not yet updated.
MYSQL QUERY:
UPDATE aqi_metrics
SET stability=:stability ,risk=:risk,days=DATE(NOW( ))
WHERE…
user3114967
- 639
- 5
- 15
- 38
0
votes
2 answers
SUM () ,CROSS JOIN Query
I've MYSQL Query with SUM & CROSS JOIN, its working fine.
MYSQL QUERY:
SELECT SUM(totexec/(pass_count+fail_count))/d.total COUNT FROM test_schedule CROSS JOIN ( SELECT COUNT(*) total FROM test_schedule WHERE project='JupiterQA' ) d WHERE…
user3114967
- 639
- 5
- 15
- 38
0
votes
0 answers
MYSQL Query have only upto LIMIT, How can I modify the query into MSSQL
I'm trying to convert the query FROM MYSQL TO MSSQL.
MYSQL QUERY:
SELECT DISTINCT a.tc_id
FROM mnrelease_details a,
tc_details b
WHERE a.tc_id=b.tc_name
AND tester IS NULL
AND release_name=?
AND tenv_id=?
…
user3114967
- 639
- 5
- 15
- 38
0
votes
0 answers
How to set parameters of Prepared Statement query that uses OPENQUERY to avoid SQL Injection
In my java application I am using OPENQUERY to execute an SQL query in remote linked MSSQL server and fetch result. Below is an example of OPENQUERY I am using:
SELECT 1 FROM OPENQUERY('LINK_SERVER1', 'SELECT 1 FROM TABLE_ABC');
In my Java class I…
NITIN SHUKLA
- 11
- 5