Migrating from the WebSphere Connect JDBC driver

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.

Before you begin

Read Overview of migration, coexistence, and interoperability and Premigration considerations.

About this task

Syntax

[AIX] [HP-UX] [Linux] [Solaris]
./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]]
[Windows]
WebSphereConnectJDBCDriverConversion.bat
			[-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.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic    

Terms of Use | Feedback

Last updated: Oct 22, 2010 2:38:49 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-nd-dist&topic=tmig_jdbc
File name: tmig_jdbc.html