Database Toolbox

Performing Driver Functions

This part of the tutorial demonstrates how to create database driver and drivermanager objects so that you can get and set the object properties. You use these Database Toolbox functions:

• drivermanager
• driver
• get
• isdriver
• set

There is no equivalent M-file demo to run because the tutorial uses a PC and relies on a specific JDBC connection and database; your configuration will be different.

1. Use the driver function to construct a driver object for a specified database URL string of the form jdbc:<subprotocol>:<subname>. For example, type

d = driver('jdbc:oracle:thin:@144.212.33.228:1521:')

MATLAB returns the handle (identifier) for the driver object.

d =
    DriverHandle: [1x1 oracle.jdbc.driver.OracleDriver]

2. To get properties of the driver object, type

v = get(d)

MATLAB returns information about the driver's versions.

v = 
    MajorVersion: 1
    MinorVersion: 0

3. To determine if d is a valid JDBC driver object, type

isdriver(d)

MATLAB returns

ans =
    1

which means d is a valid JDBC driver object. Otherwise, MATLAB would have returned a 0.

4. To set and get properties for all drivers, first create a drivermanager object using the drivermanager function. Type

dm = drivermanager

dm is the drivermanager object.

5. Get properties of the drivermanager object. Type

v = get(dm)

MATLAB returns

v = 
         Drivers: {'sun.jdbc.odbc.JdbcOdbcDriver@76163'}
    LoginTimeout: 0
       LogStream: []

6. To set the LoginTimeout value to 10 for all drivers loaded during this session, type

set(dm,'LoginTimeout',10)

Verify the value by typing

v = get(dm)

MATLAB returns

v = 
         Drivers: {'sun.jdbc.odbc.JdbcOdbcDriver@761630'}
    LoginTimeout: 10
       LogStream: []

If you now connect to a database, the LoginTimeout value will be 10. For example, type

conn = database('SampleDB','','')

MATLAB returns

conn =
        Instance: 'SampleDB'
       UserName: ''
         Driver: []
            URL: []
    Constructor: [1x1
                  com.mathworks.toolbox.database.databaseConnect]
        Message: []
         Handle: [1x1 sun.jdbc.odbc.JdbcOdbcConnection]
        TimeOut: 10
     AutoCommit: 'on'
           Type: 'Database Object'

For a list of all the driver object functions you can perform, type

help driver/Contents

Accessing Metadata

Working with Cell Arrays in MATLAB