Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-interceptors.html
With Connector/J, the interceptors are enabled and disabled by updating the connection string to refer to different sets of interceptor classes that you instantiate. The connection properties that control the interceptors are explained in Section ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-jdbctemplate.html
The template classes handle obtaining and releasing a connection for data access when one is needed. Spring makes extensive use of the Template method design pattern (see Template Method Pattern). Our immediate focus will be on the JdbcTemplate and ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-tomcat.html
First, install the .jar file that comes with Connector/J in $CATALINA_HOME/common/lib so that it is available to all applications installed in the container. It also has the advantage that if using ReplicationConnection or LoadBalancedConnection ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-authentication-user-plugin.html
Advanced users with special security requirements can create their own authentication plugins for MySQL Connector/NET applications. /// </summary> /// <returns>An string with the user name</returns> /// <remarks>Default implementation returns the ...For background and usage information about MySQL authentication plugins, see Authentication Plugins and Writing Authentication ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-binary-issues.html
In these situations, it becomes practically impossible for the connector to be able to correctly identify the correct metadata. However, some existing applications may encounter issues with this change and can use a connection string option to ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-blob-writing.html
To write a file to a database, we need to convert the file to a byte array, then use the byte array as a parameter to an INSERT query. After assigning the byte array as a parameter of the MySqlCommand object, the ExecuteNonQuery method is called ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-crystal-source.html
The first option is to use Connector/ODBC as an ADO data source when designing your report. If you choose to design your reports using Connector/ODBC, it can be downloaded from dev.mysql.com. When creating a report in Crystal Reports there are two ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-tablecaching.html
Configuration To enable table caching, add 'table cache = true' to the connection string. Optionally, specify the 'Default Table Cache Age' connection string option, which represents the number of seconds a table is cached before the cached data is ... Table caching is a feature that can be used to cache slow-changing datasets on the client ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-efmodel-ddl.html
Minimally, you will need Microsoft Visual Studio 2017 and MySQL Connector/NET 6.10 to perform this tutorial. In the Generate Database Wizard dialog select an existing connection, or create a new connection to a server. This tutorial demonstrates ...