JDBC
It stands for Java Database Connectivity.
Connection
It is similar to the notion of session in RDBMS.
It has an transaction isolation property.
Auto commit
Auto commit can be enabled or disabled. If enabled, it means that a commit is send after each statement execution. It disables the usage of transactions and cursor.
Statement
It represents the notion of query. It can be executed to obtained a result set.
Fetch size
This number set the maximum number of tuples to load at once in memory from the answers of a query. Notice that it is based on cursors, so that it can not be used when auto commit is enabled. Also, committing during the usage of a result set causes an exception saying that the "portal" or the "cursor" does not exist.
