|
| Problem | Create WebSphere DataSource Using MERANT SequeLink Java Client 5.1 | | | | Solution | From WebSphere Administrative Console:1. Create JDBC DriverSwich to "Type View", right click on "JDBC Drivers" and select "Create...". In the "Create a JDBC Driver" window, enter the following information"Name: <JDBC Driver Name>Class Name: com.merant.sequelink.jdbc.SequeLinkDriver URL prefix: jdbc:sequelink://hostname:19996("hostname" is the HostName or IP address of the server where you installed the MERANT SequeLink Server 5.1. If you changed the default port number for SequeLink Service during the installation, you need to change the port 19996 to that port number).For example: Switch to "Topology View", right click on the JDBC Driver that you created (from the above step) and select "Install..." In the "Install Driver" windows, select the node and click on the "Browse" button: Navigate to the directory <WAS_HOME>\lib (where <WAS_HOME> is the installed directory of WebSphere Application Server 3.5.3, e.g. D:\WebSphere\AppServer): Select the jar file "sljc.jar" and click the "Open" button. On the "Install Driver" windows, click the "Install" button. SequeLink Java Client 5.1 comes with two jar files: sljc.jar and sljcx.jar. When installing the driver, only sljc.jar is specified, therefore the sljcx.jar file needs to be specified at the Application Server's Command line arguments "-classpath". To do this, select your application server, e.g. "Default Server", on the right pane, in the "Command line arguments" field of the "General" tab, specify the string "-classpath <WAS_HOME>\lib\sljcx.jar" (where <WAS_HOME> is the installed directory of your WebSphere Application Server 3.5.3).For example: You must click on the "Apply" button to after specifying the Command line arguments for your application server.2. Create DataSourceFrom "Type View", right click on "DataSource" and provide all the required information in the "Create a DataSource" windows:Data Source Name: <Name of the DataSource>Database name: <Name of the Database>Driver:<Name of the JDBC Driver Created from Step 1>For example: Note:When configuring a DataSource for MS SQLServer, the "Database name" should be the name of SQLServer's Database NOT the SQL Server Group. For example, the Database name can be master, pubs, Northwind, etc.When configuring a DataSource for Oracle, the "Database name" can be anything. SequeLink Server doesn' t require the database name but WebSphere requires the field to be non-blank, so you must specify something in this field. In this case, you can enter the name of your ORACLE_SID. | |
| |
| |
|
Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, Administrative Console (all non-scripting) Operating system(s): Multi-Platform Software version: 3.5.3, 3.5.4, 3.5.5, 3.5.6 Software edition: Advanced Reference #: 1008413 IBM Group: Software Group Modified date: 2002-06-09
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|