Sun Microsystems Logo
Products and Services
Support and Training

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 Utilitycapture-schema(1m)


 capture-schema - stores the database metadata (schema) in a file for use in mapping and execution


 capture-schema-dburl url-username name- password password-driver a_jdbc_driver [-schemaname name] [-table tablename] * [-out filename]



Stores the database metadata (schema) in a file. You can also use the Sun Java System Studio IDE to capture the database schema. Run capture-schema as the same database user that owns the tables, so that the -username and -schemaname options are given the same username. Additionally, you can grant the database user running the capture-schema command the ANALYZE ANY TABLE privilege.



JDBC URL expected by the driver for accessing a database.
user name for authenticating access to a database.
password for accessing the selected database.
JDBC driver classname in your CLASSPATH.
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.
name of the table; multiple table names can be specified.
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_1.dtd file.


 Example 1. Using capture-schema
capture-schema -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817
-schemaname cantiflas -username CANTIFLAS -password enigma -driver




Sun Java System Application ServerGo To TopLast Changed March 2004