473,395 Members | 1,422 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

JDBC ResultSet and cursors

Hi everyone-
I'm using the Microsoft JDBC driver for SQL Server 2000 and I'm trying
to avoid using server cursors.

Is there a way to guarantee that every query will not create a
server-side ResultSet with a cursor? In other words, I want every
ResultSet to be loaded into the client's (the web server's) memory.

Does setting the "selectMethod" connection property guarantee this?

Does SQL Server automatically decide which method is best and if so,
what is the default choice?

I would appreciate any insight. Thanks in advance!

Jan 23 '07 #1
0 1174

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ron | last post by:
this code is giving me an excption and I cannot tell why could someone who is familiar with jdbc help me out, I am using mysql with jdbc, although the exception does not look like it is getting far...
0
by: David | last post by:
Does anybody have samples of how to use JDBC calls to work with a cursor on Oracle 8i? Can it even be done? I'd like to be able to do something like: String sql = "DECLARE CURSOR my_cursor...
1
by: bogachkov | last post by:
Hello Joe Over the past several years, I have found your responses to jdbc usage/driver related issues to be extremely helpful. I am sure that you're very busy so I will make my question as...
4
by: Dani | last post by:
Hi everyone Description of the problem: Using a PreparedStatement to write down an integer (int) plus a timestamp for testing purposes. When read out again the integer looks very different. We...
1
by: Andrea | last post by:
Hello, I spent now several hours searching the google groups without finding an solution. I am kind of Newbie to DB2 and JSP and therefore working with JSP4Dummies (not sure whether I should...
1
by: Dr X | last post by:
I have a problem updating date values using Java via JDBC-ODBC to Access. <snip rs.updateTimestamp(theIndex,theTimeStamp); rs.updateRow(); <snip> (where theTimeStamp is a valid Java Timestamp...
1
dmjpro
by: dmjpro | last post by:
I had a wrong conception in JDBC..that when maximum opened cursors exceed then the corresponding connection to the database is closed automatically. But I recently I came to know that the connection...
5
oll3i
by: oll3i | last post by:
my librarybean package library.ejb; import java.sql.*; import javax.ejb.*; import library.common.*; @Stateless @Remote
2
by: brendanmcdonagh | last post by:
Hi been working with connecting to access database for a few days now and thought i'd mastered it but judging by the following - obviously not! My code is supposed to get a string from text box...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.