No announcements
Found 263429 threads
-
0 VotesJDBC Driver, support Statement Caching?
"[prepared statement caching] is helpful to bring the execution plan closer to the app server code when highly executed so it doesn't have to make the trip to the server to be ...Answered | 3 Replies | 3142 Views | Created by rinceRepeat - Wednesday, May 13, 2015 5:56 PM | Last reply by davidbaxterbrowne - Friday, May 13, 2016 1:31 PM
-
2 Votes
JDBC Batching with prepared statement SQLServer 2019
SQLServerBulkCopy class directly instead of traditional prepared statements.Proposed | 12 Replies | 5891 Views | Created by Cibot - Tuesday, July 28, 2020 6:56 AM | Last reply by Cibot - Thursday, July 30, 2020 1:57 PM -
0 Votes
login problems to jdbc driver for sqlserver...
It appears to me that while using JDBC you are trying to use SQL Server authentication (and not Windows Authenticaton).Answered | 2 Replies | 8833 Views | Created by joanfiz - Friday, July 9, 2010 6:53 PM | Last reply by Ralias - Monday, July 12, 2010 7:20 PM -
0 Votes
Is JDBC-driver on GitHub also applicable for SQLSERVER 2014?
Hi all, Is the JDBC-driver described here https://www.microsoft.com/en-us/sql-server/developer-get-started/java-windows also applicable for SQLSERVER-2014?Answered | 1 Replies | 823 Views | Created by Bård Tørustad - Wednesday, December 28, 2016 10:17 AM | Last reply by Lin Leng - Thursday, December 29, 2016 3:21 AM -
0 Votes
JDBC Connection to SQLServer with windows Auth using user and password
For submitting a feedback to Microsoft such issues, I would recommend to submit it to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback.Answered | 4 Replies | 5524 Views | Created by C P Arora - Friday, August 9, 2013 5:08 PM | Last reply by Allen Li - MSFT - Sunday, August 18, 2013 2:28 PM -
3 Votes
Java JDBC driver
So you can not use it with JDBC Driver, you have to execeute the statements one by one.Answered | 2 Replies | 1170 Views | Created by MightyDash - Wednesday, October 11, 2017 1:24 PM | Last reply by Erland Sommarskog - Wednesday, October 11, 2017 9:24 PM -
0 Votes
The statement must be executed before any results can be obtained error with JDBC 2.0
As part of an exercise to port current application from SQLSERVER 2005 to SQLSERVER 2008 I was running some test and ran into an issue.Answered | 2 Replies | 24406 Views | Created by Suri Nagarajan - Thursday, August 6, 2009 4:36 PM | Last reply by plavin - Friday, June 10, 2011 9:08 AM -
3 Votes
Could not find prepared statement with handle %.
The statement shown in RPC staring is what you need to pick because as Erland explained, completed would show "funky" behavior.Answered | 2 Replies | 17700 Views | Created by ChrisRDBA - Friday, January 3, 2014 4:08 PM | Last reply by Balmukund - Saturday, January 4, 2014 7:20 AM -
2 Votes
Adhoc vs Prepared
The problem with this approach is that the jdbc driver sends the String parameters as NVarchar (as Unicode).Answered | 5 Replies | 6195 Views | Created by siva.k - Wednesday, June 15, 2011 5:31 AM | Last reply by Erland Sommarskog - Thursday, June 16, 2011 9:05 AM -
2 Votes
Netezza JDBC
Hi Johnny, According to your description, you need to connect to Netezza by using JDBC in a PowerPivot Workbook, right?Answered | 2 Replies | 1306 Views | Created by Johnny_yang - Wednesday, June 3, 2015 11:36 PM | Last reply by Visakh16 - Thursday, June 4, 2015 7:22 AM -
0 Votes
JDBC 2.0 LockTimeout vs.
When two or more batches are deadlocked, SQL Server automatically terminates one of the batches.Answered | 1 Replies | 11497 Views | Created by Niels van Klaveren - Thursday, February 4, 2010 2:37 PM | Last reply by David Olix - MSFT - Tuesday, March 9, 2010 10:18 PM -
0 Votes
Window Authentication Using JDBC
Hi Mamidi, According to my knowledge, it is not possible to bypass your local windows credentials to access SQL Server 2008 and use windows authentication in ...Answered | 3 Replies | 4294 Views | Created by Venkat Mamidi - Wednesday, April 27, 2016 7:41 PM | Last reply by Lydia Zhang - Friday, April 29, 2016 7:30 AM -
0 Votes
Batch statements and local variable scope
SQL Server parses the whole batch, and at that time, the new column doesn't exist, so you get that error from the final UPDATE (error produced at parse time).Answered | 3 Replies | 5205 Views | Created by Calle Mellergardh - Wednesday, December 29, 2010 3:38 PM | Last reply by Calle Mellergardh - Wednesday, December 29, 2010 4:57 PM -
0 Votes
How to define stored procedure with supports some collection like INPUT parameter - callable from JDBC?
So you can process all rows in a set in the INSERT...SELECT statement.Answered | 3 Replies | 1039 Views | Created by Horyna_ph - Thursday, July 17, 2014 12:18 PM | Last reply by Dan Guzman - Thursday, July 17, 2014 1:16 PM -
0 Votes
JDBC Driver 4.2 for Java 1.7
Hi Markus, Microsoft JDBC Driver 4.2 for SQL Server does not work with JRE 1.7,please use Microsoft JDBC Driver 4.1 for SQL Server instead.Answered | 1 Replies | 2329 Views | Created by markus.le - Monday, November 30, 2015 10:54 AM | Last reply by Lydia Zhang - Tuesday, December 1, 2015 3:27 AM -
0 Votes
Error creating a int(10,0) column [CA Clarity] with [SQLServer JDBC Driver]
MICROSOFT SQL SERVER 2008 R2 (SP2) - 10.50.4266.0 (X64) SEP 26 2012 17:08:07 COPYRIGHT (C) MICROSOFT CORPORATION DEVELOPER EDITION (64-BIT) ON WINDOWS NT 6.1 <X64> (BUILD ...Answered | 3 Replies | 2811 Views | Created by Ram Iyer - Monday, June 23, 2014 1:10 PM | Last reply by Tom Phillips - Monday, June 23, 2014 1:50 PM -
0 Votes
Problem connecting to SQLServer via JDBC
I am trying to connect the LifeRay portal to SQLServer.Answered | 2 Replies | 1283 Views | Created by LauriP - Thursday, October 1, 2015 8:52 AM | Last reply by cnk_gr - Thursday, October 1, 2015 9:05 AM -
0 Votes
The CREATE DATABASE statement must be the only statement in the batch.
It is caused if there is a space in your statement.Answered | 2 Replies | 12244 Views | Created by xbally - Thursday, December 2, 2010 2:41 PM | Last reply by ExtremeBidder - Thursday, September 8, 2011 1:04 AM -
1 Votes
Can't Prepare Schema Exchange Server 2019
Hi You cannot co=exist Ex2010 and Ex2019 Exchange ...Answered | 5 Replies | 1010 Views | Created by Thossaphon - Saturday, February 8, 2020 2:01 AM | Last reply by Eric_Yin - Thursday, February 13, 2020 10:26 AM -
0 Votes
Windows Server 2019 Domain Controller Migration Preparation
Q1: What should be the Forest and Domain Exchange Schema version to prepare for Windows Server 2019 Domain Controller migration?Answered | 6 Replies | 6610 Views | Created by da3rd - Friday, July 17, 2020 7:41 PM | Last reply by Daisy Zhou - Wednesday, July 22, 2020 1:17 AM - Items 1 to 20 of 263429 Next ›
No announcements
