Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-datetime-types-processing.html
Default Value false Since Version 3.1.7 preserveInstants If enabled, Connector/J does its best to preserve the instant point on the time-line for Java instant-based objects such as 'java.sql.Timestamp' or 'java.time.OffsetDateTime' instead of their ... connectionTimeZone Configures the connection time zone which is used by Connector/J if conversion between the JVM default and a target time zone is needed when preserving instant temporal ...
https://dev.mysql.com/doc/connectors/en/connector-j-time-instants.html
A time instant is said to be preserved when it always refers to the same point in time when its value is being stored to or retrieved from a database, no matter what time zones the database server and the clients are operating in. Background A time ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-load-balancing-failover.html
When a SQLException matches conditions defined by user, using the extension points defined by the loadBalanceSQLStateFailover, loadBalanceSQLExceptionSubclassFailover or loadBalanceExceptionChecker properties. Connector/J provides a useful ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html
At this point, you can click on various operations and examine the returned result. Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or source-source replication ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-jdbctemplate.html
<bean id="dao" class="code.Ex2JdbcDao"> <property name="dataSource" ref="dataSource"/> </bean> At this point, we can just grab a reference to the DAO from Spring and call getRandomCityByCountryCode(). Spring makes extensive use of the Template ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-authentication-user-plugin.html
How the Custom Authentication Plugin Works At some point during handshake, the internal method void Authenticate(bool reset) of MySqlAuthenticationPlugin is called. Debug.WriteLine("Calling MySqlNativePasswordPlugin2.GetPassword"); Tip You could ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-datetime-fractional.html
To use the more precise date and time types, specify a value from 1 to 6 when creating the table column, for example TIME(3) or DATETIME(6), representing the number of digits of precision after the decimal point. MySQL Connector/NET supports the ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-asp-provider-profile.html
At this point you are now ready to start using the MySQL Profile Provider. This tutorial shows you how to use the MySQL Profile Provider to store user profile information in a MySQL database. The tutorial uses MySQL Connector/NET 6.9.9, MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-asp-roles.html
At this point build the solution to ensure no errors are present. Many websites feature the facility for the user to create a user account. They can then log into the website and enjoy a personalized experience. This requires that the developer ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
This tutorial teaches you how to use the MySqlScript class. Depending on the circumstances, this can be more convenient than using the MySqlCommand approach. Further details of the MySqlScript class can be found in the reference documentation ...