BEA WebLogic Server 7 Manuel de service Page 455

  • Télécharger
  • Ajouter à mon manuel
  • Imprimer
  • Page
    / 545
  • Table des matières
  • MARQUE LIVRES
  • Noté. / 5. Basé sur avis des utilisateurs
Vue de la page 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.
Vue de la page 454
1 2 ... 450 451 452 453 454 455 456 457 458 459 460 ... 544 545

Commentaires sur ces manuels

Pas de commentaire