reset - Reset JDBC or ODBC connection options to defaults - MATLAB (original) (raw)

Create, configure, and test a JDBC data source for a Microsoft® SQL Server® database. Reset the JDBC connection options to their default values. Then configure, test, and save the data source with different JDBC connection options.

Create an SQL Server data source for a JDBC database connection.

vendor = "Microsoft SQL Server"; opts = databaseConnectionOptions("jdbc",vendor)

opts = SQLConnectionOptions with properties:

          DataSourceName: ""
                  Vendor: "Microsoft SQL Server"

      JDBCDriverLocation: ""
            DatabaseName: ""
                  Server: "localhost"
              PortNumber: 1433
      AuthenticationType: "Server"

opts is an SQLConnectionOptions object with these properties:

• DataSourceName — Name of the data source
• Vendor — Database vendor name
• JDBCDriverLocation — Full path of the JDBC driver file
• DatabaseName — Name of the database
• Server — Name of the database server
• PortNumber — Port number
• AuthenticationType — Authentication type

Configure the data source by setting the JDBC connection options for the data source SQLServerDataSource, full path to the JDBC driver file, database name toystore_doc, database server dbtb04, port number 54317, and Windows® authentication.

opts = setoptions(opts, ... 'DataSourceName',"SQLServerDataSource", ... 'JDBCDriverLocation',"C:\Drivers\mssql-jdbc-7.0.0.jre8.jar", ... 'DatabaseName',"toystore_doc",'Server',"dbtb04", ... 'PortNumber',54317,'AuthenticationType',"Windows")

opts = SQLConnectionOptions with properties:

          DataSourceName: "SQLServerDataSource"
                  Vendor: "Microsoft SQL Server"

      JDBCDriverLocation: "C:\Drivers\mssql-jdbc-7.0.0.jre8.jar"
            DatabaseName: "toystore_doc"
                  Server: "dbtb04"
              PortNumber: 54317
      AuthenticationType: "Windows"

The setoptions function sets the DataSourceName, JDBCDriverLocation, DatabaseName, Server, PortNumber, and AuthenticationType properties in the SQLConnectionOptions object.

Test the database connection with a blank user name and password. The testConnection function returns the logical 1, which indicates the database connection is successful.

username = ""; password = ""; status = testConnection(opts,username,password)

Reset the JDBC connection options to their default values. The properties of the SQLConnectionOptions object contain the default values.

opts = SQLConnectionOptions with properties:

          DataSourceName: ""
                  Vendor: "Microsoft SQL Server"

      JDBCDriverLocation: ""
            DatabaseName: ""
                  Server: "localhost"
              PortNumber: 1433
      AuthenticationType: "Server"

Configure the data source by setting the JDBC connection options for the data source SQLServerDataSource, full path to the JDBC driver file, database name toystore_doc, database server dbtb04, port number 54317, and Windows® authentication. Also, set driver-specific connection options to specify a timeout value for establishing the database connection, and to disable SSL encryption.

opts = setoptions(opts, ... "DataSourceName","SQLServerDataSource", ... "JDBCDriverLocation", ... "C:\Drivers\mssql-jdbc-7.0.0.jre8.jar", ... "DatabaseName","toystore_doc", ... "Server","dbtb04","PortNumber",54317, ... "AuthenticationType","Windows","loginTimeout","20", ... "encrypt","false")

opts = SQLConnectionOptions with properties:

          DataSourceName: "SQLServerDataSource"
                  Vendor: "Microsoft SQL Server"

      JDBCDriverLocation: "C:\Drivers\mssql-jdbc-7.0.0.jre8.jar"
            DatabaseName: "toystore_doc"
                  Server: "dbtb04"
              PortNumber: 54317
      AuthenticationType: "Windows"

Additional Connection Options:

                 encrypt: "false"
            loginTimeout: "20"

The setoptions function sets the DataSourceName, JDBCDriverLocation, DatabaseName, Server, PortNumber, and AuthenticationType properties in the SQLConnectionOptions object. The driver-specific connection options appear below the other connection options.

Test the database connection again.

username = ""; password = ""; status = testConnection(opts,username,password)

Save the configured data source.