MySQLProtocol is a protocol to communicate with MySQL server. It provides a way to authenticate, reset sequence id, and close the connection.
Type parameters
- F
-
the effect type
Attributes
- Companion
- object
- Source
- MySQLProtocol.scala
- Graph
-
- Supertypes
-
class Objecttrait Matchableclass Any
- Known subtypes
-
class MySQLProtocolImpl[F]
Members list
Value members
Abstract methods
Authenticates the user with the given password.
Authenticates the user with the given password.
Value parameters
- password
-
the password
- user
-
the user name
Attributes
- Source
- MySQLProtocol.scala
Changes the user of the connection.
Changes the user of the connection.
Value parameters
- password
-
the password
- user
-
the user name
Attributes
- Source
- MySQLProtocol.scala
Creates a client prepared statement with the given SQL.
Creates a client prepared statement with the given SQL.
Value parameters
- sql
-
SQL queries based on text protocols
Attributes
- Source
- MySQLProtocol.scala
Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
Value parameters
- resultSetConcurrency
-
resultSetConcurrency
- resultSetType
-
resultSetType
- sql
-
statement
Attributes
- Returns
-
prepared statement
- Source
- MySQLProtocol.scala
Closes the connection.
Returns the statistics of the connection.
Returns the initial packet.
Returns true if the connection has not been closed and is still valid.
Returns true if the connection has not been closed and is still valid.
Attributes
- Source
- MySQLProtocol.scala
Resets the connection.
Resets the sequence id.
Creates a server prepared statement with the given SQL.
Creates a server prepared statement with the given SQL.
Value parameters
- sql
-
SQL queries based on text protocols
Attributes
- Source
- MySQLProtocol.scala
Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
Value parameters
- resultSetConcurrency
-
resultSetConcurrency
- resultSetType
-
resultSetType
- sql
-
statement
Attributes
- Returns
-
prepared statement
- Source
- MySQLProtocol.scala
Controls whether or not multiple SQL statements are allowed to be executed at once.
Controls whether or not multiple SQL statements are allowed to be executed at once.
Value parameters
- optionOperation
-
EnumMySQLSetOption.MYSQL_OPTION_MULTI_STATEMENTS_ON or EnumMySQLSetOption.MYSQL_OPTION_MULTI_STATEMENTS_OFF
Attributes
- Source
- MySQLProtocol.scala
Sets the schema name that will be used for subsequent queries.
Sets the schema name that will be used for subsequent queries.
Value parameters
- schema
-
the name of a schema in which to work
Attributes
- Source
- MySQLProtocol.scala
Creates a Statement object for sending SQL statements to the database. SQL statements without parameters are normally executed using Statement objects. If the same SQL statement is executed many times, it may be more efficient to use a PreparedStatement object.
Creates a Statement object for sending SQL statements to the database. SQL statements without parameters are normally executed using Statement objects. If the same SQL statement is executed many times, it may be more efficient to use a PreparedStatement object.
Attributes
- Source
- MySQLProtocol.scala
Creates a Statement object that will generate ResultSet objects with the given type and concurrency. This method is the same as the createStatement method above, but it allows the default result set type and concurrency to be overridden. The holdability of the created result sets can be determined by calling [[# getHoldability]].
Creates a Statement object that will generate ResultSet objects with the given type and concurrency. This method is the same as the createStatement method above, but it allows the default result set type and concurrency to be overridden. The holdability of the created result sets can be determined by calling [[# getHoldability]].
Value parameters
- resultSetConcurrency
-
a concurrency type; one of
ResultSet.CONCUR_READ_ONLYorResultSet.CONCUR_UPDATABLE - resultSetType
-
a result set type; one of
ResultSet.TYPE_FORWARD_ONLY,ResultSet.TYPE_SCROLL_INSENSITIVE, orResultSet.TYPE_SCROLL_SENSITIVE
Attributes
- Returns
-
a new
Statementobject that will generateResultSetobjects with the given type and concurrency - Source
- MySQLProtocol.scala