Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-connect-drivermanager.html
With this method, you could use an external configuration file to supply the driver class name and driver parameters to use when connecting to a database. } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
In practice, when a thread needs to do work against a MySQL or other database with JDBC, it requests a connection from the pool. Although this is not usually an issue with the quick connection setup that MySQL offers compared to other databases, ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-connpooling.html
In many situations, such as web applications, there will be a large number of small database transactions. When this is the case, it usually makes sense to create a pool of database connections available for web requests as needed. The difference ...Although MySQL does not spawn an extra process when a connection is made, there is still a small amount of overhead to create and set up the ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
To use transactional database access, we will need to change the storage engine of the tables in the world database. First you create a simple interface: public interface Ex3Dao { Integer createCity(String name, String countryCode, String district, ... Spring allows us to add transactions into our code without having to deal directly with the JDBC ...
https://dev.mysql.com/doc/connectors/en/connector-net-asp-provider.html
There is no need to run any type of SQL script to set up the database schema, as the providers create and maintain the proper schema automatically. You do this by first removing the dummy connection string and then adding in the proper one, as shown ... MySQL Connector/NET includes a provider model for use with ASP.NET ...
https://dev.mysql.com/doc/connectors/en/connector-net-installation-binary-nuget.html
In addition, the packages provides access to multiple versions of MySQL server and encapsulates database-specific protocols. MySql.Data.EntityFramework This package provides object-relational mapper (ORM) capabilities, which enables you to work with ... MySQL Connector/NET functionality is available as packages from NuGet, an open-source package manager for the Microsoft development platform (including .NET ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-getschema.html
The GetSchema() method of the connection object can be used to retrieve schema information about the database currently connected to. The following are the collections currently provided by Connector/NET, in addition to the common collections shown ...The schema information is returned in the form of a ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
mysql Information: 1 : 1: Connection Opened: connection string = 'server=localhost;User Id=root;database=world;port=3306 ;password=******;logging=True' mysql Information: 3 : 1: Query Opened: SHOW VARIABLES mysql Information: 4 : 1: Resultset ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-ssl-pem.html
In your application, add a connection string using the test database and the sslclient user account (created previously). using (MySqlConnection connection = new MySqlConnection( "database=test;user=sslclient;" + "SslMode=VerifyFull" Add the ... The ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-pooling.html
Connection pooling enables the ODBC driver to re-use existing connections to a given database from a pool of connections, instead of opening a new connection each time the database is accessed. By enabling connection pooling you can improve the ...