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
2 answers

SQL Server : Invalid length parameter passed to the LEFT or SUBSTRING function

I'm trying to execute a SQL Server SUBSTRING query but its throwing error. The query is: select substring(testcasename, 2, 5) val1, substring(testcasename, 2, CHARINDEX(',', testcasename, 2) - 2) val2 from tce_lineno where …
user3114967
  • 639
  • 5
  • 15
  • 38
0
votes
2 answers

MSSQL Query should return same as MYSQL

I've MYSQL Query and working fine The QUERY IS: select tst_type, count(tst_type) tot from tst_type where project='JupiQA'; The above Query returns single record If I'm adding GROUP BY tst_type in this query it returns multiple values. The Query I …
user3114967
  • 639
  • 5
  • 15
  • 38
0
votes
2 answers

MSSQL select query with IF () statement

I've MYSQL Query, its working fine The QUERY Is: SELECT * , IF(totexec >= totexecrun1, totexec-totexecrun1,0) AS rewrk, SUM(tcu) tcunit , IF(totexec=0, ((SUM(tcu)/totexec)*100),0) AS proflevel FROM mntest_schedule a LEFT JOIN…
user3114967
  • 639
  • 5
  • 15
  • 38
0
votes
2 answers

MSSQL CONCAT query throws Error

I'm tried to execute the below query in MSSQL 2008 R2,but its throwing error. THE QUERY IS: SELECT (n_artifactType+(' '+ n_actionPerformed)) AS actionperformed, COUNT(n_actionPerformed) total FROM notifications WHERE …
user3114967
  • 639
  • 5
  • 15
  • 38
0
votes
1 answer

How can I execute the MSSQL query without error?

I'm trying to execute mssql query but its showing error.The same query I executed in MySQL its working fine. The Query is: SELECT tst_flow_name, tst_flow_desc,COUNT(tst_flow) tot FROM test_flow_details LEFT OUTER JOIN tst_flow ON…
user3114967
  • 639
  • 5
  • 15
  • 38
0
votes
1 answer

Connecting to MS-SQL from ASP Classic

I followed these steps to create my connection string: 1) Right-click an empty spot on the desktop and choose NEW, TEXT DOCUMENT from the context menu 2) Save it with a .udl extension, and click yes when it asks are you sure. 3) Double-click the…
Yaco Zaragoza
  • 429
  • 1
  • 7
  • 18
0
votes
2 answers

Connection String of MS-SQL to put in JAVA

What should be the connection string for MSSQL Database in JAVA? Something like this. Like someother things I want to know that Is there any password in connection string like password of my computer? what should be the port number, url etc? If you…
Junaid
  • 2,572
  • 6
  • 41
  • 77
0
votes
1 answer

SQL Server queries to table which name matches the command name

SELECT role.name, role_privelege.privelege FROM role JOIN role ON role.id = role_privelege.id breaks with an error: [Error Code: 1013, SQL State: S0001] The objects "role" and "role" in the FROM clause have the same exposed names. Use…
Vladimir Kolenov
  • 438
  • 1
  • 4
  • 14
0
votes
0 answers

How to Call ResultSet in JDBC sql WHERE IN (?) condition

I have two Different Database (SqlServer,Oracle) SqlServer having CUSTOMER_ID information and Oracle has CUSTOMER_ID and other column information I want to achive below scenorio (Get record set from 1st method and apply that valus as condition in…
Elavarasan
  • 301
  • 1
  • 5
  • 14
0
votes
1 answer

BatchUpdateException is thrown when inserting null values for decimal fields into MS SQL Server

We are using the standard Spring Batch JdbcBatchItemWriter to insert data into MS SQL Server. The data to be inserted (the output from the item processor) is contained in a Map, which holds the column names and values. When the map…
user1052610
  • 4,440
  • 13
  • 50
  • 101
0
votes
1 answer

How to connect android application to MSSQL server and retrive data from it?

I am trying to connect my app to Microsoft SQL server 2008 R2 and retrieve data from it. I can connect my app to MySql through out php but can't complete the same task in terms of MSSQL server. I have googled this and this links. But these links…
user3673503
  • 385
  • 2
  • 6
  • 14
0
votes
1 answer

SQL Server Authentication using encrypted password

I am keeping the SQL Server password in clear text, which is a security threat now. I would like to replace this with encrypted password. But I don't know whether SQL Server accepts encrypted password or not. Or if there is some other solution for…
Lokesh Raj Urs
  • 351
  • 1
  • 6
  • 19
0
votes
1 answer

How to pass the values of user defined datatype variable to MS SQL from java using spring jdbc store procedure

I have the below MS SQL store procedure with the user defined variable (@Location CREATE PROCEDURE [Organization].[Organization_Insert] ( @OrganizationID NVARCHAR(256), @Location Locationtype ReadOnly ) @Location has following attributes:…
J.P
  • 495
  • 1
  • 6
  • 15
0
votes
1 answer

Android: Cant connect with database on Remote Server

Good day, I am creating an Android program that connects to MS SQL 2012 database on a remote server.. Im currently using Eclipse Juno.. my code works on Eclipse Helius but when I transfer my code to Juno, I encounter problems with connecting to…
Katsuhiro
  • 19
  • 2
0
votes
1 answer

org.hibernate.exception.SQLGrammarException: could not execute query : Incorrect syntax near the keyword 'user'

I have one more issues. and it giving only in MSSQL server: select theme0_.id as id12_, theme0_.user as user12_, theme0_.theme as theme12_ from theme theme0_ where theme0_.user=1 This query is giving error : Incorrect syntax near the keyword…
Shubhankar
  • 87
  • 3
  • 6
  • 16
1 2 3
…
40 41