To configure a Microsoft SQL Server 2005 and 2008 repository:

1. Create a SQL Server database to use as the iBSP repository.
2. Ensure that SQL Server authentication is supported.

   You can do this from 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, then restart SQL Server.

   Note: SQL Server has two authentication modes, Windows and SQL Server. Windows Authentication uses the same IDs as the Windows operating system. SQL Server Authentication uses IDs defined within SQL Server. iBSP uses the Microsoft SQL Server 2000 JDBC driver which requires SQL Server authentication.

3. Create a SQL Server ID and grant it db_owner rights to the iBSP repository database.
4. Open a command prompt and navigate to the iWay setup directory. The default location on Windows is:

   C:\Program Files\iWay60\etc\setup

   This directory contains SQL to create the repository tables in the following file:

   iwse.sql

   Once the database exists, you can use iwse.sql to create the database tables.

   Note: If SQL Server is not on the same machine as iBSP, copy the iwse.sql file to the SQL Server machine. From a command prompt on the SQL Server machine, navigate to the directory containing the iwse.sql file.

5. Issue the following command:

   osql -S hostname -d databasename -U loginID -P password -i iwse.sql

   where:

   hostname

   Is the name of the machine where SQL Server is running.

   databasename

   Is the database you created in Step 1.

   loginID

   Is the SQL Server ID with db_owner rights from Step 3.

   password

   Is the password for the SQL Server ID.

   The tables should be created in your database.

To configure an Oracle repository:

1. Contact your database administrator to obtain an Oracle user ID and password to create the iBSP repository.

   This user ID should have rights to create and modify tables as well as, the ability to create and execute stored procedures.

2. Open a command prompt and navigate to the iWay setup directory. The default location on Windows is:

   C:\Program Files\iWay60\etc\setup

   For other platforms, see the corresponding location.

   This directory should contains SQL to create the repository tables.

   Note: If Oracle is not on the same machine as iBSP copy iwse.ora or iwse.ora9 to the Oracle machine. Then, from a command prompt on the Oracle machine, navigate to the directory containing the iwse.ora or iwse.ora9 file.

3. Issue the following command depending on your Oracle release:

   sqlplus userid/password @database @ iwse.ora

   or

   sqlplus userid/password
   @database @ iwse.ora9

The SQL needed to create the repository is installed in the following file on Windows:

C:\Program Files\iWay60\etc\setup\sybase-iwse.sql

For other platforms, see the corresponding location.

A Sybase DBA should submit this SQL to create the repository tables and structure.

The SQL needed to create the repository is installed in the following file on Windows:

C:\Program Files\iWay60\etc\setup\db2-iwse.sql

For other platforms, see the corresponding location.

A DB2 DBA should submit this SQL to create the repository tables and structure.

1. Copy the JDBC driver for you database into the iWay60\lib directory, for example:

   drive:\Program Files\iWay60\lib

   The driver files depend on your database and driver. For more information about third-party driver files, see Required Database Driver Files.

2. Open the Web Console and log on:

   http://hostname:9999

   where:

   hostname

   Is the name of the host on which iWay is installed.

3. In the left pane, click Configuration, System Properties, and then Web Services.
4. Complete the available fields. The following table lists and describes the fields.

   Repository Name	Specify the type of repository that you are using.
   Driver Name	Provide the JDBC Class to connect to the database. For SQL Server 2000: com.microsoft.jdbc.sqlserver.SQLServerDriver For SQL Server 2005: com.microsoft.jdbc.sqlserver.SQLServerDriver For SQL Server 2008: com.microsoft.jdbc.sqlserver.SQLServerDriver 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 your IBM driver documentation.
   Repository URL	Provide the JDBC URL to connect to the database. For information on repository URL formats, see Repository URL Formats.
   User	Provide the user ID to access the repository database.
   Password	Provide the password to access the repository database.

5. Click Save.
6. Click Restart.

   When Service Manager restarts, you should reverify iBSP using the sample Web service at:

   http://hostname:9000

To enter connection information for Servlet iBSP:

1. Determine the JDBC driver for your database.

   The required driver files depend on your database and driver type. For more information on required third-party driver files, see Required Database Driver Files.

2. Copy the JDBC driver into the iWay60\lib directory.
3. Make the JDBC driver for your database available to the iBSP Web application. You can do this by adding the JDBC driver to your application server CLASSPATH or by copying the driver into the ibsp\WEB-INF\lib directory of the ibsp Web application.

   Refer to your application server documentation for information on setting CLASSPATH.

   For example, if you deployed an expanded directory, you can copy the driver directly into the expanded WEB-INF\lib directory, for example:

   C:\Program Files\iWay60\webapps\ibse\WEB-INF\lib

   For Tomcat, if you deployed ibsp.war, Tomcat expanded it and you can copy the driver into this expanded directory, for example:

   C:\Program Files\Apache Group\Tomcat 4.1\webapps\ibse\WEB-INF\lib

4. Restart your application server.
5. Log on to the Servlet iBSP Configuration page at:

   http://hostname:port/ibse

6. At the bottom of the page, provide the repository connection information.

   The following table lists and describes the fields.

   Field	Description
   Repository Type	Specify the type of repository you are using.
   Repository URL	Provide a JDBC URL to connect to the database. For information on repository URL formats, see Repository URL Formats.
   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.jdbc.sqlserver.SQLServerDriver For SQL Server 2008: com.microsoft.jdbc.sqlserver.SQLServerDriver 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 your IBM driver documentation.
   Repository User	Provide the user ID to access the repository database.
   Repository Password	Provide the password to access the repository database.

7. Click Save.

   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, your repository is not actually used.

8. Restart the application server.

   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 in:

   http://hostname:port/ibse/IBSEConfig

The repository URLs have the forms listed in the following table.

jdbc:microsoft:sqlserver://hostname:port;DatabaseName=dbname;SelectMethod=cursor

jdbc:sybase:Tds:hostname:port

jdbc:db2://hostname:port/dbname

jdbc:db2:dbname

After you create the database repository, you must add the required driver files to the CLASSPATH of your application server. The required driver files depend on your database and driver.

For information on how to add the driver files to the CLASSPATH of your application server, see the documentation for your application server.

The following table below lists the driver files for common versions of the databases for which iWay provides database setup scripts.

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.