Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-examples.html
Examples of using Connector/J are located throughout this document. This section provides a summary and links to these examples. Example 7.1, “Connector/J: Obtaining a connection from the DriverManager” Example 7.2, “Connector/J: Using ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-dns-srv.html
In an X DevAPI connection pooling setup, Connector/J re-queries the DNS SRV records regularly and phases out gracefully any connections whose hosts no longer appear in the records, and readmits the connections into the pool when their hosts reappear ... Connector/J supports the use of DNS SRV records for ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-using-ssl.html
Connector/J can encrypt all data communicated between the JDBC driver and the server (except for the initial handshake) using SSL. There is a performance penalty for enabling connection encryption, the severity of which depends on multiple factors ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
Spring allows us to add transactions into our code without having to deal directly with the JDBC classes. For that purpose, Spring provides a transaction management package that not only replaces JDBC transaction management, but also enables ...
https://dev.mysql.com/doc/connector-j/en/connector-j-WebAuthn-authentication.html
Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric readers. WebAuthn enables passwordless authentication, and can be used for MySQL accounts that use ...
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
Accounts with the SYSTEM_USER privilege are automatically assigned the AUDIT_ABORT_EXEMPT privilege, so that queries from the account are always executed even if an “abort” item in the audit log filter would block them. MySQL incorporates the ...
https://dev.mysql.com/doc/refman/8.4/en/adding-character-set.html
This section discusses the procedure for adding a character set to MySQL. The proper procedure depends on whether the character set is simple or complex: If the character set does not need special string collating routines for sorting and does not ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The MySQL 8.4 server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is ...
https://dev.mysql.com/doc/refman/8.4/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/8.4/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...