sun.com | docs.sun.com |  | How To Buy | My Sun | Worldwide Sites |

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Application Server Utility | capture-schema(1m)

- NAME
- SYNOPSIS
- DESCRIPTION
- OPTIONS
- EXAMPLES
- SEE ALSO

## 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]

## DESCRIPTION

> 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.

## OPTIONS

> -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.

## EXAMPLES

> 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

## SEE ALSO

> `asadmin`(1M)

Sun Java System Application Server | Go To Top | Last Changed 29 Dec 2003

Company Info | Contact | Copyright 2004 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms.