Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Communication Sequences


Contents

"Communication sequences" are chains of communication packages, which constitute a full "unit of work", i.e. a complete CUBRID operation, containing both data request(s)and data response(s).

Examples of such communication sequences are:

  • Connect to the CUBRID database
  • Execute some batch command(s)
  • Execute a SQL query, receive and interpret the results

 

CONNECT TO CUBRID BROKER

 

Prerequisites:

  • None

Sequence:

 

OPEN DATABASE CONNECTION

 

Prerequisites:

  • Connected to the broker

Sequence:

 

CLOSE DATABASE CONNECTION

 

Prerequisites:

  • Connected to the database

Sequence:

 

GET DATABASE VERSION

 

Prerequisites:

  • Connected to the database

Sequence:

 

GET DATABASE PARAMETER

 

Prerequisites:

  • Connected to the database

Sequence:

 

SET DATABASE PARAMETER

 

Prerequisites:

  • Connected to the database

Sequence:

 

SET AUTO-COMMIT MODE

 

Prerequisites:

  • Connected to the database

Sequence:

 

COMMIT TRANSACTION

 

Prerequisites:

  • Connected to the database

Sequence:

 

ROLLBACK TRANSACTION

 

Prerequisites:

  • Connected to the database

Sequence:

 

EXECUTE BATCH STATEMENTS

 

Prerequisites:

  • Connected to the database

Sequence:

 

PREPARE AND EXECUTE QUERY

 

Prerequisites:

  • Connected to the database

Sequence:

 

FETCH QUERY DATA

 

Prerequisites:

  • Connected to the database
  • Open query successful

Sequence:

 

CLOSE QUERY

 

Prerequisites:

  • Connected to the database

 

Sequence:

 

GET SCHEMA INFORMATION

 

Prerequisites:

  • Connected to the database

 

Sequence:

 

CREATE LOB

 

Prerequisites:

  • Connected to the database

Sequence:

 

READ LOB

 

Prerequisites:

  • Connected to the database
  • LOB new request successful

Sequence:

 

WRITE LOB

 

Prerequisites:

  • Connected to the database
  • LOB NEW request successful

Sequence:

comments powered by Disqus
Page info
viewed 621 times
translations en
Author
posted last year by
CUBRID
Contributors
updated last year by
View revisions
tagged
Share this article