Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-using-ssl.html
All Java keystore files are protected by the password supplied to the keytool when you created the files. You need the file names and the associated passwords to create an SSL connection. Connector/J can encrypt all data communicated between the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html
All load-balanced connections sharing the same loadBalanceConnectionGroup value, regardless of how the application creates them, will be managed together. Connector/J has long provided an effective means to distribute read/write load across ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config.html
For example, to configure a connection to a MySQL server supporting the world sample database, you might use: <util:map id="dbProps"> <entry key="db.driver" value="com.mysql.cj.jdbc.Driver"/> <entry key="db.jdbcurl" ... The Spring Framework is a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements-callable.html
For more information on MySQL stored procedures, please refer to Using Stored Routines. Notice that you have to use JDBC escape syntax, and that the parentheses surrounding the parameter placeholders are not optional: Example 7.4 Connector/J: Using ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements.html
To create a Statement instance, you call the createStatement() method on the Connection object you have retrieved using one of the DriverManager.getConnection() or DataSource.getConnection() methods described earlier. Statement objects allow you to ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to ...
https://dev.mysql.com/doc/refman/8.4/en/alter-function.html
However, you cannot change the parameters or body of a stored function using this statement; to make such changes, you must drop and re-create the function using DROP FUNCTION and CREATE FUNCTION. (That privilege is granted automatically to the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-procedure.html
However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE. By default, that privilege is granted ... ALTER ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing ...