473,811 Members | 3,299 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 "selectMeth od" 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 1198

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

Similar topics

1
2360
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 enough for that to matter. Statement stmt = PoolDB.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet Picks = stmt.executeQuery("SELECT * FROM picks where week="+week); // get all the cloums and...
0
2486
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 FOR SELECT name,id FROM name_tbl"; statement.execute(sql); (executeQuery? executeUpdate?) .... while(...)
1
2030
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 brief as possible - the reason I didn't post this to a newsgroup is that I don't want to hear any more hype or links to benchmarks (since the vast majority of the benchmarks don't test concurent/mixed-transaction environments). (I am also posting a...
4
6352
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 found that it was shifted three Bytes to the left, i.e. 4 becomes hex 4000000 which is 67108864 in decimal base. This means that the value written and the value read sometimes do not match, which is of course inacceptable for all real world...
1
4680
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 recommend this book): Invoking the following jsp-file in the browser I get an ClassNotFoundException for the COM.ibm.db2.jdbc.app.DB2Driver. JSP-File
1
4119
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 and theIndex is the column index in the resultset.) is the way specified in the Java API. The (very non-specific) error reported
1
1179
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 is still active... How can I trap that particular exception.. I have also a conception that when a satatement is created then a cursor is opened. Is it true. On closing the resultset is the corresponding cursor is closed or not. Plz help me...
5
2046
oll3i
by: oll3i | last post by:
my librarybean package library.ejb; import java.sql.*; import javax.ejb.*; import library.common.*; @Stateless @Remote
2
1512
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 and get a string from a selection of a jcombobox (search keyword from column) and create a results table (via a new class) after querying the database. I'm not getting any errors and i know (via a if statment that resultSet != null but my print...
0
9734
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10652
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10408
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10137
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9211
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7673
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6895
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5561
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4346
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.