Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » SQL Anywhere JDBC API » Using the jConnect JDBC driver » Supplying a URL to the driver

Specifying a database on a server Next Page

Database options set for jConnect connections


When an application connects to the database using the jConnect driver, two stored procedures are called:

  1. The sp_tsql_environment procedure sets some database options for compatibility with Adaptive Server Enterprise behavior.

  2. The sp_mda procedure is then called, and sets some other options. In particular, the sp_mda procedure determines the quoted_identifier setting. To change the default behavior, you should modify the insert dbo.spt_mda values ... statements in jcatalog.sql.

See also