SQLResultSetControl annotation and related types

SQLResultSetControl ...

EGL package name

eglx.persistence.sql

Example use

Annotation detail
Record SQLResultSetControl type Annotation {
   targets=[elementKind.fieldMbr],

   // the following setting is split to two lines for readability
   validationProxy = "org.eclipse.edt.compiler.binding.annotationType.
                      SQLResultSetControlAnnotationTypeBinding"
   }

   // see enumeration type, later.
   scrollablity SQLResultSetScrollablity? = 
                SQLResultSetScrollablity.TYPE_FORWARD_ONLY;

   // see enumeration type, later.
   concurrency SQLResultSetConcurrency? = 
               SQLResultSetConcurrency.CONCUR_READ_ONLY;

   // see enumeration type, later.
   holdability SQLResultSetHoldability?;
end

enumeration SQLResultSetScrollablity

   // The cursor can only go forward.
   // When the cursor has gone to a later row, 
   // the database management system can release resources.
   TYPE_FORWARD_ONLY = 1,

   // The result set is not sensitive to changes made by other users.
   TYPE_SCROLL_INSENSITIVE = 2,

   // The result is sensitive to changes made by other users.
   TYPE_SCROLL_SENSITIVE = 3
end

enumeration SQLResultSetConcurrency

   // The result set cannot be updated.
   CONCUR_READ_ONLY = 1,

   // The result set is updatable. 
   // Other users cannot change the retrieved rows until the cursor is closed.
   CONCUR_UPDATABLE = 2 
end

enumeration SQLResultSetHoldability
   
   // After a commit, cursors remain open with their positions retained.
   HOLD_CURSORS_OVER_COMMIT = 1,

   // After a commit, cursors are closed.
   CLOSE_CURSORS_AT_COMMIT = 2
end
Annotation fields
scrollability
concurrency
updateable
holdability
Comments
Compatibility

Table 1. Compatibility
Target Issue
Java No issues.
JavaScript Database access is not supported.