Using the WebLogic Server Java Utilities

WebLogic Server Command Reference

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

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. Text file with SQL statements.

Example

The following code shows a Schema command line for the examples.utils package:

$ java utils.Schema
"jdbc:pointbase:server://localhost/demo"
"com.pointbase.jdbc.jdbcUniversalDriver" -u "examples"
-p "examples" examples/utils/ddl/demo.ddl

utils.Schema will use these parameters:

url: jdbc:pointbase:server://localhost/demo
driver: com.pointbase.jdbc.jdbcUniversalDriver
dbserver: null
user: examples
password: examples
SQL file: examples/utils/ddl/demo.ddl