BEA WebLogic Server 7 Instrukcja Obsługi Strona 455

  • Pobierz
  • Dodaj do moich podręczników
  • Drukuj
  • Strona
    / 545
  • Spis treści
  • BOOKMARKI
  • Oceniono. / 5. Na podstawie oceny klientów
Przeglądanie stron 454
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.
Przeglądanie stron 454
1 2 ... 450 451 452 453 454 455 456 457 458 459 460 ... 544 545

Komentarze do niniejszej Instrukcji

Brak uwag