Technical data

Administration Guide A-19
Schema
The Schema utility lets you upload SQL statements to a database using the WebLogic
JDBC drivers. For additional information about database connections, see
Programming WebLogic JDBC.
Syntax
$ java utils.Schema driverURL driverClass [-u username]
[-p password] [-verbose SQLfile]
Example
The following code shows a sample Schema command line:
$ java utils.Schema "jdbc:cloudscape:demo;create=true"
COM.cloudscape.core.JDBCDriver
-verbose examples/utils/ddl/demo.ddl
The following code shows a sample .ddl file:
DROP TABLE ejbAccounts;
CREATE TABLE ejbAccounts
(id varchar(15),
bal float,
type varchar(15));
DROP TABLE idGenerator;
CREATE TABLE idGenerator
Argument Definition
driverURL
Required. URL for the JDBC driver.
driverClass
Required. Pathname of the JDBC driver class.
-u username
Optional. Valid username.
-p password
Optional. Valid password for the user.
-verbose
Optional. Prints SQL statements and database messages.
SQLfile
Required when the -verbose argument is used. Text file with SQL
statements.