{{theTime}}

Search This Blog

Total Pageviews

How to create Scrollable ResultSet?

How to create Scrollable ResultSet?

Use ResultSetType Constant in createStatement(), prepareStatement() or prepareCall()
TYPE_FORWARD_ONLY -- Forward only scrollable, update-insensitive
TYPE_SCROLL_INSENSITIVE -- Bi-directionally scrollable, update-insensitive
TYPE_SCROLL_SENSITIVE -- Bi-directionally scrollable, update-sensitive.

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...