Ballerina API Documentation

Connectors of ballerina.data.sql package

connector ClientConnector (map options)

Parameters:

Parameter NameData TypeDescription
optionsmap

Actions:

action batchUpdate()

The call action implementation for SQL connector.

Parameters:

Parameter NameData TypeDescription
cClientConnectorConnector
querystringString
parametersParameter[][]Parameter array

Return Parameters:

Return VariableData TypeDescription
int[]updatedCounts: Array of update counts

action call()

The call action implementation for SQL connector.

Parameters:

Parameter NameData TypeDescription
cClientConnectorConnector
querystringString
parametersParameter[]Parameter array

Return Parameters:

Return VariableData TypeDescription
datatableResult set for the query

action close()

The close action implementation for SQL connector.

Parameters:

Parameter NameData TypeDescription
cClientConnectorConnector

action select()

The select action implementation for SQL connector.

Parameters:

Parameter NameData TypeDescription
cClientConnectorConnector
querystringString
parametersParameter[]Parameter array

Return Parameters:

Return VariableData TypeDescription
datatableResult set for the query

action update()

The update action implementation for SQL connector.

Parameters:

Parameter NameData TypeDescription
cClientConnectorConnector
querystringString
parametersParameter[]Parameter array

Return Parameters:

Return VariableData TypeDescription
intinteger: Updated row count

action updateWithGeneratedKeys()

The update with generated keys given columns action implementation for SQL connector.

Parameters:

Parameter NameData TypeDescription
cClientConnectorConnector
querystringString
parametersParameter[]Parameter array
keyColumnsstring[]String array

Return Parameters:

Return VariableData TypeDescription
introwCount: Updated row count
string[]rowCount: Updated row count


Structs of ballerina.data.sql package

struct Parameter

Fields:

Field NameData TypeDescription
sqlTypestring
valueany
directionint
structuredTypestring


Menu

  • Connectors
    • ClientConnector (map options)
      • batchUpdate(ClientConnector c, string query, Parameter[][] parameters)
      • call(ClientConnector c, string query, Parameter[] parameters)
      • close(ClientConnector c)
      • select(ClientConnector c, string query, Parameter[] parameters)
      • update(ClientConnector c, string query, Parameter[] parameters)
      • updateWithGeneratedKeys(ClientConnector c, string query, Parameter[] parameters, string[] keyColumns)
  • Structs
    • Parameter

Copyright 2017 Ballerina API Documentation