In this section: |
iWay Service Manager and Servlet iBSP require repositories to store information about adapter targets, metadata, transactions, Web services, and other data.
Scripts to create repository tables is installed with iWay in the ibspsql.zip file, for example:
C:\Program Files\iWay60\etc\setup\ibspsql.zip
You should extract the contents of this file to a temporary directory on the machine with your database server. To extract, you can use Winzip or the jar command (jar xvf ibspsql.zip).
Then follow the steps for your type of repository:
To configure a Microsoft SQL Server repository:
For SQL Server 2000, you can do this in the SQL Server Enterprise Manager by right-clicking your SQL Server, choosing Properties, and clicking the Security tab. If Authentication is set to Windows only, change it to SQL Server and Windows, and then restart SQL Server.
To do this, you can use the Enterprise Manager to expand the servers and folders on the left, right-click the Databases folder, and choosing New Database. You can name the database anything you wish and can keep default settings.
C:\Program Files\iWay60\etc\setup\ibspsql.zip
Extract the files to a directory on the machine running SQL Server. After extracting files, the SQL Server files are located in an mss directory.
iwse.sql
For Japanese users, the script is named Iwse-unicode.sql.
osql -S hostname -d databasename -U loginID -P password -i iwse.sql
where:
Is the name of the machine where SQL Server is running.
Is the database you created.
Is the SQL Server ID with db_owner rights.
Is the password for the SQL Server ID.
The tables should be created in your database.
To configure an Oracle repository:
This user ID should have rights to create and modify tables as well as the ability to create and execute stored procedures.
C:\Program Files\iWay60\etc\setup\ibspsql.zip
Extract the files to a directory on the machine running Oracle. After extracting files, the Oracle files are in an oracle directory. This directory contains SQL to create the repository tables.
For Oracle 8i | iwse.ora |
For Oracle 9i and higher | iwse.ora9 |
Note: For Oracle version 9i and higher, only the ojdbc14.jar driver is supported. In addition, you must use the iwse.ora9 script file when configuring repositories for Oracle version 9i and higher.
sqlplus userid/password @ iwse.ora
or
sqlplus userid/password @ iwse.ora9
To configure a Sybase repository:
C:\Program Files\iWay60\etc\setup\ibspsql.zip
The ibspsql.zip file contains the SQL that is required to create the repository. The sybase directory you extract contains the following file to create the repository tables:
sybase-iwse.sql
Note: This step should be performed by a Sybase DBA.
To configure a DB2 repository:
C:\Program Files\iWay60\etc\setup\ibspsql.zip
The DB2 directory you extract contains the following file to create the repository tables:
db2-iwse.sql
Note: For z/OS systems, contact iWay Software to obtain the correct scripts.
Note: This step should be performed by a DB2 DBA.
dbmcli db_create iwseusername,password dbmcli -d iwse -u username,password -i install-maxdb-instance.txt
The database should be created.
loadercli -d iwse -u dba_username,dba_password -b maxdb-iwse3.sql
The tables should be loaded.
Note: If you need to drop the tables and start over, edit and submit maxdb-iwse-droptables.bat (or maxdb-iwse-droptables.sh).
iWay components communicate with the repository using JDBC. Therefore, a JDBC driver must be available.
The required driver files depend on your database and driver type, for example:
Database Driver |
Required Driver Files |
SQL Server 2000 |
msbase.jar mssqlserver.jar msutil.jar |
SQL Server 2005 |
sqljdbc.jar |
SQL Server 2008 |
sqljdbc4.jar |
Oracle 8i |
classes12.jar |
Oracle 9i and higher |
ojdbc14.jar |
MaxDB |
sapdbc-7_5_0_5.jar |
Sybase |
jconn2.jar |
DB2 Type 4 Universal JDBC |
db2jcc.jar db2jcc_license_cisuz.jar |
DB2 Type 2 Legacy App |
db2java.zip See your driver documentation for more information. If both iBSP and DB2 are on z/OS or OS/400, refer to the IBM driver documentation. |
C:\Program Files\iWay60\lib
For information about third party driver files, see Preparing Adapters.
Tip: Depending on your application server, you may find it easier to add the driver into the ibse\WEB-INF\lib directory of the iBSP Web application (ibse.war or ibse.ear).
After you create the repository tables and install the JDBC driver, restart iWay Service Manager and/or your application server. Then, configure iWay components to access the new repository.
http://hostname:9999
where:
Is the hostname where you installed iWay.
A form appears for defining the database.
Name |
Enter a name that you will use to refer to the connection. |
Driver Class |
Use the drop down menu or manually enter the JDBC Class. |
Connection URL |
Use the drop down menu and edit the default URL. You can also manually enter the URL. Examples are shown after this table. For SQL Server 2000, ensure the URL ends with the following: ;SelectMethod=cursor |
User |
Provide the user ID to access the repository database. |
Password |
Provide the password to access the repository database. |
The repository URLs have the forms listed in the following table.
Database |
JDBC URL |
---|---|
SQL Server 2000 |
jdbc:microsoft:sqlserver://hostname:port;DatabaseName=db name;SelectMethod=cursor |
SQL Server 2005 |
jdbc:sqlserver://hostname:port;databaseName=dbname |
SQL Server 2008 |
jdbc:sqlserver://hostname:port;databaseName=dbname |
Oracle |
jdbc:oracle:thin:@hostname:port:SID |
MaxDB |
jdbc:sapdb://hostname[:port]/DatabaseName[options] |
Sybase |
jdbc:sybase:Tds:hostname:port |
DB2 |
For DB2 Type 4 Universal JDBC driver: jdbc:db2://hostname:port/dbname For DB2 Type2 App driver: jdbc:db2:dbname See your driver documentation for more information. If both iBSP and DB2 are on z/OS or OS/400, refer to IBM driver documentation. |
where:
Is the hostname of the database server machine.
Is the port number for the database server. The SQL Server default is 1433. The Oracle default is 1521.
Is the database name or DB2 database alias or location name.
Is the ORACLE SID.
You should receive a response that says:
The JDBC data provider test completed successfully.
If you receive an error, troubleshoot accordingly. Ensure the driver is in the iWay60\lib directory as explained in How to Install the JDBC Driver.
Your connection appears on the Data Provider page. If you need to change its parameters, you can click its link.
Note: Connection Pooling is not supported for SQL Server 2005.
When Service Manager restarts, you should reverify iBSP using the sample Web service at:
http://hostname:9000
Note: Use iWay Service Monitor to monitor iWay Service Manager events. Monitoring is implemented using AmberPoint components and can be enabled through the Web Console. For details, see the iWay Service Manager User's Guide.
To migrate a repository, see Migrating Repositories.
To enter connection information for Servlet iBSP:
http://hostname:port/ibse
The following table lists and describes the fields.
Field |
Description |
---|---|
Repository Type |
Specify the type of repository you are using. Note: Data Source is not supported. |
Repository URL |
Edit the provide JDBC URL to connect to the database. Examples follow this table. |
Repository Driver |
Provide the JDBC Class to connect to the database. For SQL Server 2000: com.microsoft.jdbc.sqlserver.SQLServerDriver For SQL Server 2005: com.microsoft.sqlserver.jdbc.SQLServerDriver For SQL Server 2008: com.microsoft.sqlserver.jdbc.SQLServerDriver For MaxDB: com.sap.dbtech.jdbc.DriverSapDB For Oracle: oracle.jdbc.driver.OracleDriver For Sybase: com.sybase.jdbc2.jdbc.SybDriver For DB2 Type 4 Universal JDBC driver: com.ibm.db2.jcc.DB2Driver For DB2 Type2 App driver: COM.ibm.db2.app.DB2Driver See your driver documentation for more information. If both iBSP and DB2 are on z/OS or OS/400, refer to IBM driver documentation. |
Repository User |
Provide the user ID to access the repository database. |
Repository Password |
Provide the password to access the repository database. |
The repository URLs have the forms listed in the following table.
Database |
JDBC URL |
---|---|
SQL Server 2000 |
jdbc:microsoft:sqlserver://hostname:port;DatabaseName=db name;SelectMethod=cursor |
SQL Server 2005 |
jdbc:sqlserver://hostname:port;databaseName=dbname |
SQL Server 2008 |
jdbc:sqlserver://hostname:port;databaseName=dbname |
Oracle |
jdbc:oracle:thin:@hostname:port:SID |
MaxDB |
jdbc:sapdb://hostname[:port]/DatabaseName[options] |
Sybase |
jdbc:sybase:Tds:hostname:port |
DB2 |
For DB2 Type 4 Universal JDBC driver: jdbc:db2://hostname:port/dbname For DB2 Type2 App driver: jdbc:db2:dbname See your driver documentation for more information. If both iBSP and DB2 are on z/OS or OS/400, refer to IBM driver documentation. |
where:
Is the hostname of the database server machine.
Is the port number for the database server. The SQL Server default is 1433. The Oracle default is 1521.
Is the database name or DB2 database alias or location name.
Is the ORACLE SID.
Note: For SQL Server 2005, do not check Repository Pooling.
You should be redirected to the Servlet iBSP home page where you can test the sample Web service. However, until you redeploy or restart the server, the new repository is not actually used.
After the server restarts or the application is redeployed, test it by going to the Servlet iBSP home page at:
http://hostname:port/ibse/IBSEServlet
If you receive an error, confirm the settings at the configuration page:
http://hostname:port/ibse
If you receive an error, ensure CLASSPATH is properly set and redeploy the iBSP Web application.
When Servlet iBSP is installed, it is configured to use a file system repository, so no additional steps are required. If you do not have access to a database, you can continue to store the Servlet iBSP repository information in XML files on your local machine. However, file system repositories are less secure and less efficient than using a database. In addition, file system repositories for iBSP are not supported in production environments.
For Servlet iBSP, the default location is either the root directory of the iBSP Web application under the application server or a directory under iWay60, for example:
C:\Program Files\iWay60\config\base\ibserepo.xml
iWay Software |