Example: Migrating - Installing a JDBC driver

You can install a Java Database Connector (JDBC) driver in WebSphere Application Server Network Deployment.

The following example demonstrates how to install a JDBC driver in WebSphere Application Server V5.x and V6.x using wsadmin V5.x and V6.x. Resources can exist at the server, node, or cell level of the configuration.

Using Jacl:[AIX HP-UX Linux Solaris Windows]
set node [$AdminConfig getid /Node:mynode/]
$AdminConfig create JDBCProvider $node {{classpath c:/SQLLIB/java/db2java.zip} {implementationClassName COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource} {name mydriver}}
$AdminConfig save
[z/OS]
set node [$AdminConfig getid /Node:mynode/]
$AdminConfig create JDBCProvider $node {{classpath /SQLLIB/java/db2java.zip} {implementationClassName COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource} {name mydriver}}
$AdminConfig save
Using Jython:[AIX HP-UX Linux Solaris Windows]
node = AdminConfig.getid('/Node:mynode/')
AdminConfig.create('JDBCProvider', node, [['classpath', 'c:/SQLLIB/java/db2java.zip'],  ['implementationClassName', 'COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource'], ['name', 'mydriver']])
AdminConfig.save()
[z/OS]
node = AdminConfig.getid('/Node:mynode/')
AdminConfig.create('JDBCProvider', node, [['classpath', '/SQLLIB/java/db2java.zip'],  ['implementationClassName', 'COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource'], ['name', 'mydriver']])
AdminConfig.save()



Related tasks
Migrating V4.0.x administrative scripts to V6 wsadmin
Related information
Using command line tools
Reference topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 9:31:45 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=vela&product=was-nd-mp&topic=rxml_mjdbc
File name: rxml_mjdbc.html