ALTER DATABASE statement
384
$ For information on adding Java support, see "Java-enabling a Version 7
database" on page 556 of the book ASA User’s Guide. For information on
adding jConnect support to a Version 6 database, see "Installing jConnect
system objects into a database" on page 613 of the book ASA User’s Guide.
JAVA clause The JAVA clause adds the entries for the Sybase runtime
Java classes to the system tables (JAVA ON) or does not (JAVA OFF). By
default, the classes are added during the upgrade. Setting JAVA OFF does
not remove Java support from a database.
JCONNECT clause If you wish to use the Sybase jConnect JDBC driver
to access system catalog information, you need to specify JCONNECT ON.
If you wish to exclude the jConnect system objects, specify JCONNECT
OFF. You can still use JDBC, as long as you do not access system catalog
information. The default is to include jConnect support (JCONNECT ON).
Setting JCONNECT OFF does not remove jConnect support from a
database.
♦
SQL/92 Vendor extension
♦
Sybase Not supported by Adaptive Server Enterprise.
♦ Upgrade a Version 5 database to enable Java operations:
ALTER DATABASE UPGRADE
JAVA ON
Parameters
Standards and
compatibility
Example