InfoCenter Home > 6.6.0.2.2.4.7: Creating and installing drivers and data sourcesThe following example wscp commands create and install a JDBC driver and data source. A JDBC driver and data source must be configured for each brand and version of database from which application servers or enterprise applications require connections. The script init.tcl must be loaded prior to using these commands (init.tcl initializes NODE, DB2_HOME, and other variables used here). As with the administrative console, in wscp you must install the JDBCDriver corresponding to a DataSource before creating the DataSource. This might break existing scripts that create DataSources on JDBCDrivers that have not been installed. Such scripts receive a message with a JDBCDriverNotInstalledException: /JDBCDriver:j2/DataSource:ds1/ cannot be used because /JDBCDriver:j2/ has not been installed on any node; exception information was com.ibm.ejs.sm.exception.JDBCDriverNotInstalledException wscp> JDBCDriver create /JDBCDriver:DB2Driver/ -attribute \ {{ImplClass com.ibm.db2.jdbc.app.DB2ConnectionPoolDataSource}} # Install the JDBCDriver object wscp> JDBCDriver install /JDBCDriver:DB2Driver/ -node $NODE \ -jarFile ${DB2_HOME}${FILE_SEPARATOR}java${FILE_SEPARATOR}db2java.zip # Create a DataSource object wscp> DataSource create /JDBCDriver:DB2Driver/DataSource:testDataSource/ -attribute {{ConfigProperties {{databaseName The following example commands remove the DataSource object and uninstall the JDBCDriver object. Note that you cannot uninstall JDBCDrivers that have existing DataSources. # Remove the DataSource object just created wscp> DataSource remove /JDBCDriver:DB2Driver/DataSource:testDataSource/ # Uninstall the JDBCDriver object wscp> JDBCDriver uninstall /JDBCDriver:DB2Driver/ -node $NODE # Remove the JDBCDriver object just created wscp> JDBCDriver remove /JDBCDriver:DB2Driver/
Adding the Merant ConnectJDBC driver |
| ||
|