FREE DOWNLOAD COMPONENTS/ THIRD PARTY TERMS AND CONDITIONS. Have licensed may contain open source and/or other types of free download components. Those components included in the Sybase Program/Software that require the pass-through of. 7.07 Licensor Component Bouncy Castle Bouncy Castle 1.4. To find out which version of jConnect you already have running, navigate to the directory where you installed the JDBC jconn4.jar driver.
Description
Upgrades a database created with a previous version of thesoftware or adds or removes Java or jConnect support. Run this statementwith Interactive SQL Java.
Syntax
Examples
Example 1
Upgrade a database created with the Java optionsoff:
Usage
The ALTER DATABASE statement upgrades databasescreated with earlier versions of the software. This applies to maintenancereleases as well as major releases. For example, you can upgradea database created with version 12.6 to 12.7.
See the Sybase IQ Installation and Configuration Guide for backup recommendations beforeyou upgrade.
When you upgrade a database, Sybase IQ makes the followingchanges:
- Upgrades the system tables to thecurrent version.
- Adds any new database options.
You can also use ALTER DATABASE UPGRADE simplyto add Java or jConnect features if the database was created withthe current version of the software.
WARNING! Be sure to start the server in a way that restrictsuser connections before you run ALTER DATABASE UPGRADE.For instructions and other upgrade caveats, see the chapter “MigratingData,” in the Sybase IQ Installation and Configuration Guide for your platform.
After using ALTER DATABASE UPGRADE, shutdown the database.
If upgrade of a Sybase IQ 12.6 database returnsa “Database upgrade not possible” error, see “Insufficientprocedure identifiers,” in Sybase IQ Troubleshooting and Recovery Guide.
JAVA clause Controls support for Java in the upgraded database.
JCONNECT clause To allow the Sybase jConnect JDBC driver to access systemcatalog information, you must specify JCONNECT ON.This installs jConnect system tables and procedures. To excludethe jConnect system objects, specify JCONNECT OFF.You can still use JDBC, as long as you do not access system cataloginformation. The default is to include jConnect support (JCONNECTON).
REMOVE JAVA clause Removes Java from a database. The operation leaves the databaseas if it were created with JAVA OFF. When thestatement is issued Java in the database must not be in use. Removeall Java classes from the database before executing this statement.The statement ignores stored procedures and triggers that referenceJava objects, and the presence of these objects does not triggeran error in the ALTER DATABASE statement.
Standards
- SQL92 Vendor extension.
- Sybase Not supported by Adaptive Server Enterprise.
Permissions
See also
“Migrating Data” in the Sybase IQ Installation and Configuration Guide
“Introduction to Java in the Database” inthe Adaptive Server Anywhere Programming Guide
Copyright © 2006. Sybase Inc. All rights reserved. |