Solved

How can I insert this "ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE" in PREPAREDSTATEMENT?

Posted on 2008-10-21
2
763 Views
Last Modified: 2010-05-18
How can I insert this "ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE" in PREPAREDSTATEMENT?
PreparedStatement stmt = conn.prepareStatement("SELECT * FROM inventorytable");

            ResultSet uprs; 

            uprs=stmt.executeQuery();

Open in new window

0
Comment
Question by:glynco
  • 2
2 Comments
 
LVL 20

Expert Comment

by:chaitu chaitu
ID: 22773555
PreparedStatement stmt = connection.prepareStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
                uprs= stmt.executeQuery("SELECT * FROM inventorytable");
0
 
LVL 20

Accepted Solution

by:
chaitu chaitu earned 500 total points
ID: 22773601
sorry above post was wrong
PreparedStatement stmt = connection.prepareStatement("SELECT * FROM inventorytable", java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);

Open in new window

0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

For customizing the look of your lightweight component and making it look opaque like it was made of plastic.  This tip assumes your component to be of rectangular shape and completely opaque.   (CODE)
For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now