The JDBC driver supports escaping these characters by enclosing them in braces. You might have to escape certain parts of the connection URL values if the values include special characters like spaces, semicolons, and quotation marks. Jdbc:sqlserver://localhost instanceName=instance1 integratedSecurity=true Escaping values in the connection URL To use a JDBC URL property, use the following format: Jdbc:sqlserver://localhost:1433 integratedSecurity=true To specify a port number, use the following format:

If no instance name or port number property is specified, a connection to the default instance is created. To connect to a named instance of SQL Server, you can either specify the port number of the named instance (preferred), or you can specify the instance name as a JDBC URL property or a datasource property. Each instance is identified by a specific name. SQL Server allows for the installation of multiple database instances per server. Jdbc:sqlserver://localhost databaseName=AdventureWorks integratedSecurity=true applicationName=MyApp Named and multiple SQL Server instances Jdbc:sqlserver://localhost:1433 databaseName=AdventureWorks integratedSecurity=true Ĭonnect by specifying a customized application name: Jdbc:sqlserver://localhost databaseName=AdventureWorks integratedSecurity=true Ĭonnect on the default port to the remote server: Jdbc:sqlserver://localhost integratedSecurity=true Ĭonnect to a named database on a remote server: The following connection string shows an example of how to connect to a SQL Server database using integrated authentication and Kerberos from an application running on any operating system supported by the Microsoft JDBC Driver for SQL Server: jdbc:sqlserver:// servername=server_name integratedSecurity=true authenticationScheme=JavaKerberosĬonnect to the default database on the local computer by using integrated authentication: For more information, see the Connecting with Integrated Authentication section later in this topic. Although the previous example uses a username and password in the connection string, you should use integrated security as it is more secure.

Mysql jdbc url