User`s guide

7 Functions — Alphabetical List

7-54

Database JDBC Driver Name and Database URL Example Syntax

PostgreSQL with

SSL Connection

JDBC driver: org.postgresql.Driver

Database URL: jdbc:postgresql:servername:dbname:ssl=

true&sslfactory=org.postgresql.ssl.NonValidatingFactory&

The trailing & is required.

Sybase SQL

Server and Sybase

SQL Anywhere

JDBC driver: com.sybase.jdbc4.jdbc.SybDriver

Database URL: jdbc:sybase:Tds:yourhostname:yourportnumber/

Tips

• Use logintimeout before database to set the maximum time for a connection

attempt.

• Alternatively use Database Explorer to connect to databases.

• When making a JDBC connection using name-value connection properties:

• You can skip the Server parameter when connecting to a database locally.

• You can skip the PortNumber parameter when connecting to a database server

listening on the default port (except for Oracle connections).

• “Database Connection Error Messages”

• “Bringing Java Classes into MATLAB Workspace”

• “Connecting to a Database Using the Native ODBC Interface”