WebSphere® Application
Server Version 7.0 does not include the WebSphere Connect JDBC driver for
SQL Server. Use the WebSphereConnectJDBCDriverConversion command
to convert data sources from the WebSphere Connect JDBC driver to the
DataDirect Connect JDBC driver or the Microsoft® SQL Server 2005 JDBC driver.
The WebSphereConnectJDBCDriverConversion command processes resources.xml files,
and there are many options that can be specified to indicate which resources.xml files
to process.
About this task
Syntax
WebSphereConnectJDBCDriverConversion.sh
[-profileName profile_name]
[-driverType MS | DD]
[-classPath class_path]
[-nativePath native_path]
[-pathSeparator separator]
[[-cellName ALL | cell_name [-clusterName ALL | cluster_name] |
[-applicationName ALL | application_name] |
[-nodeName ALL | node_name] [-serverName ALL | server_name]]]
[-backupConfig true | false]
[-username userID]
[-password password]
[[-traceString trace_spec [-traceFile file_name]]
Parameters
- -profileName profile_name
- This optional parameter is used to specify a specific profile configuration
in the Version 7.0 environment.
If this parameter is not specified, the
default profile is used. If the default is not set or cannot be found, an
error is returned.
If the command is run from within the profile_name/bin directory,
it is implicit that the profile_name profile should be
migrated and this parameter is not needed.
- -driverType MS | DD
- This required parameter is used to indicate the type of conversion that
you want to perform.
Specifying MS converts to the Microsoft SQL
Server 2005 JDBC Driver, and specifying DD converts to the DataDirect Connect
JDBC driver.
- -classPath class_path
- This required parameter is used to specify the class path for the new
JDBC driver.
- -nativePath native_path
- This optional parameter is used to specify the native path for the new
JDBC driver.
- -pathSeparator separator
- This optional parameter is used to specify a path separator other than
the default.
The default is operating-system dependant and is listed in
the command-line help.
- -cellName ALL | cell_name
- This optional parameter is used to specify the specific name of the cell
to process or to specify all cells.
The default is ALL
- -clusterName ALL | cluster_name
- This optional parameter is used to specify the specific name of the cluster
to process or to specify all clusters.
The default is ALL
- -application nameName ALL | application_name
- This optional parameter is used to specify applications to process. (Some resource.xml files
might exist in applications if enhanced EAR file support is used.)
The default
is ALL
- -nodeName ALL | node_name
- This optional parameter is used to specify the specific name of the node
to process or to specify all node names in the configuration.
The default
is ALL.
- -serverName ALL | server_name
- This optional parameter is used to specify the specific name of a server
or to specify all server names in a node.
The default is ALL.
- -backupConfig true | false
- This parameter is used to specify whether (true) or not (false) to back
up the existing configuration before the command makes changes to the configuration.
The
default is true.
- -username userID
- This optional parameter is used to specify the user name to be used by
this command.
- -password password
- This optional parameter is used to specify the password to be used by
this command.
- -traceString trace_spec
- This optional parameter is used with -traceFile to gather trace information
for use by IBM® service
personnel.
The value of traceString is "*=all=enabled" and must be specified
with quotation marks to be processed correctly.
- -traceFile file_name
- This optional parameter is used with -traceString to gather trace information
for use by IBM service
personnel.