 |
|
|
NAME
| | capture-schema - stores the database metadata (schema) in a file for use in mapping and execution |
SYNOPSIS
| | capture-schema -dburl url -username name -password password -driver a_jdbc_driver [-schemaname name] [-table tablename] * [-out filename] |
| |
Use the capture-schema command to store the database
metadata (schema) in a file. You can also use the Sun ONE Studio (formerly
Forte for Java) IDE to capture the database schema.
|
| |
- -dburl
- JDBC URL
expected by the driver for accessing a database.
- -username
- user name
for authenticating access to a database.
- -password
- password
for accessing the selected database.
- -driver
- JDBC driver
classname in your CLASSPATH.
- -schemaname
- name
of the user schema being captured. If not specified, the default will capture
metadata for all tables from all the schemas accessible to this user. Specifying
this parameter is highly recommended. If more than one schema is accessible
to this user, more than one table with the same name may be captured which
will cause problems.
- -table
- name of the
table; multiple table names can be specified.
- -out
- output target;
defaults to stdout. This parameter corresponds to the schema sub-element of the sun-cmp-mapping
element in the sun-cmp-mapping_1_0.dtd file.
|
| | Example 1. Using capture-schema
| |
| |
capture-schema -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817
-schemaname cantiflas -username cantiflas -password enigma -driver
oracle.jdbc.driver.OracleDriver
|
|
|
Company Info
|
Contact
|
Copyright 2003 Sun Microsystems, Inc. All rights reserved.
Use is subject to license terms.
|
