mysql forward_only_TYPE_FORWARD_ONLY CONCUR_READ_ONLY

Parameters:

TYPE_FORWARD_ONLY: The constant indicating the ResultSet object

whose cursor may move only forward.it is insensitive to changes on

database side.

TYPE_SCROLL_SENSITIVE: The constant indicating the ResultSet object

that is scrollable.it is sensitive to changes on database side,but

only care of "Update",not "Insert" and "Delete" on database

side.

TYPE_SCROLL_INSENSITIVEe constant indicating the ResultSet object

that is scrollable.it is insensitive to changes on database

side

About the "scrollable", e.g,support "absolute(int

row)","previous()"."first()".

CONCUR_READ_ONLY:The constant indicating the concurrency mode for a

ResultSet object that may NOT be updated.

CONCUR_UPDATABLEL: The constant indicating the concurrency mode for

ResultSet object that may be updated.e.g, after modification

Resultset object,we can call "Insert" or "update" command to save

in database.

if using "connection.createStatement()", it will use default

parameters "TYPE_FORWARD_ONLY" and "CONCUR_READ_ONLY"

After this commit. unify to use "connection.createStatement()" in

DbmsLanguage.java:"TYPE_FORWARD_ONLY" and "CONCUR_READ_ONLY" as two

default parameters .

MysqlDbmsLanguage override this method:use stream result.

PostgresqlDbmsLanguage override this method:set auto commit to

false.

the Streaming result set for mysql has a limitation: it only allow

one open result set at a time on a given connection. means if there

is a result running on this connection, we can't open

another

result on this connection,must wait to the first result done and

closed.