Performing Driver Functions :: Using Functions in the Database Toolbox (Database Toolbox)

Database Toolbox

Performing Driver Functions

This example 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:

Note There is no equivalent M-file demo to run because the example relies on a specific PC to JDBC connection and database. Your configuration will be different from the one in this example, so you cannot run these examples exactly as written. Instead, use values for your own system. See your database administrator for address information.

Connect to the database.

c = database('orc1','scott','tiger',...
'oracle.jdbc.driver.OracleDriver',...
'jdbc:oracle:thin:@144.212.123.24:1822:');

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.123.24:1822:')

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

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

To get properties of the driver object, type

```
v = get(d)
```

MATLAB returns information about the driver's versions.

v = 
    MajorVersion: 1
    MinorVersion: 0

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.

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.

Get properties of the drivermanager object. Type

```
v = get(dm)
```

MATLAB returns

v = 
         Drivers: {'sun.jdbc.odbc.JdbcOdbcDriver@761630'...
                     [1x38 char]}
    LoginTimeout: 0
       LogStream: []

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: []

The next time you connect to a database, the LoginTimeout value will be 10. For example, type

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

MATLAB returns

```
ans =
    10
```

For a list of all the driver object functions, see Driver Object and Drivermanager Object.

Accessing Metadata About Objects and Methods for the Database Toolbox