Sun Identity Manager 8.1 Installation

Appendix C Database Reference

If you plan to use a database, you may need to copy one or more files to the idm/WEB-INF/lib directory on your application server during the Identity Manager installation process. The following table shows the download or installed product location of one or more .jar files you need to copy for your database type.

Notes on Configuring Databases and Downloading Supporting JAR Files

Note –

For any given database, there should only be one JAR file with JDBC drivers installed at any given time. When installing JAR files, inspect WEB-INF/lib and remove any JAR files that contain conflicting JDBC drivers. For example, if installing a JAR file containing Oracle JDBC drivers, remove the Oracle JAR that you are replacing before starting Identity Manager.

Databases that are managed resources also utilize JDBC driver JARs located in the WEB-INF/lib directory. The same JAR file that supports your repository will also support any managed database resources from the same vendor.

Tip –

To help avoid conflicts when installing JDBC driver JARs, Sun recommends renaming JARs using the format dbNamejdbc.jar. The name of the JAR file does not matter, but renaming a .jar file to include the name of the database followed by jdbc is recommended to help administrators avoid JAR file collisions in the future.

Database	Download or Product Location	Configuration Notes
DB2	`Db2/java/db2java.zip` —OR— If you are using the Type 4 network driver, use this file instead: `db2jcc.jar` If you are using at least DB2 8.1.2, you will also need the following files: `db2jcc_license_cisuz.jar` `db2jcc_license_cu.jar`	Unzip the `db2java.zip` file. Note: On Windows systems rename the `db2java.zip` to `db2java.jar`. Copy the appropriate JAR files to the `WEB-INF\lib` directory. Optional: Rename the `.jar` file to `db2jdbc.jar`. Start the JDBC driver: On UNIX systems, enter: `db2jstrt port#` (default 6789) running under instant owner On Windows systems, start from services
MySQL	`http://dev.mysql.com/downloads/` Select a version of MySQL Connector/J to download.	Unpack the connector package. Copy the `mysql-connector-`Version`-bin.jar` file to the `WEB-INF\lib` directory. Optional: Rename the `.jar` file to `mysqljdbc.jar`.
Oracle	`Oracle/jdbc/lib/ojdbc14.jar` or Oracle Database 11g release JDBC drivers	Copy the `.jar` file to the `idm\WEB-INF\lib` directory. Optional: Rename the `.jar` file to `oraclejdbc.jar`.
SQL Server	`Microsoft SQL Server 2005 Driver for JDBC/lib`	Copy the `sqljdbc.jar` file to the `WEB-INF\lib` directory. Optional: Rename `sqljdbc.jar` to `mssqlserver.jar`.
JDBC 2.0 Data Source	Depends on the directory service. Consult the documentation for your application server or other directory service to locate an appropriate JAR that contains the InitialContextFactory class.	Copy the appropriate JAR (or JARs) to the `WEB-INF/lib` directory.

Note –

For a DataSource connection, you must copy or download (and place into WEB-INF/lib) a JAR that contains the InitialContextFactory class.

Refer to the following table when installing the Identity Manager software and completing database selections on the Locate Identity Manager Repository panel.

If your selection is:	Enter
JDBC 2.0 Data Source Initial Context Factory: `com.sun.jndi.fscontext.RefFSContextFactory` DataSource Name/Path: `jdbc/SampleDB`	Enter the database location. Optionally enter the password you selected when you set up the database.
MySQL URL: `jdbc:mysql://localhost/waveset` JDBC Driver: `org.gjt.mm.mysql.Driver` Connect as User: `waveset`	Enter the database location and the password you selected when you set up the database.
Oracle URL: `java:oracle:thin:@host.your.com:1521:dbname` JDBC Driver: `oracle.jdbc.driver.OracleDriver` Connect as User: `waveset`	Enter the database location and the password you selected when you set up the database.
DB2 URL: `jdbc:db2://host.your.com:6789/dbname` JDBC Driver:`COM.ibm.db2.jdbc.net.DB2Driver— OR—com.ibm.db2.jcc.DB2Driver` Connect as User: `Waveset`	Enter the database location and the password you selected when you set up the database.
SQLServer Default values, to be used with the Microsoft SQL Server 2005 JDBC Driver: URL: `“jdbc:sqlserver://host.your.com:1433; DatabaseName=dbname”` JDBC Driver: `com.microsoft.sqlserver.jdbc.SQLServerDriver` Connect as User: `waveset` Use the following values with the Microsoft SQL Server 2000 JDBC Driver: URL: `“jdbc:microsoft:sqlserver://host.your.com:1433; DatabaseName=dbname;SelectMethod=Cursor”` JDBC Driver: `com.microsoft.jdbc.sqlserver.SQLServerDriver` Connect as User: `waveset`	Enter the database location and the password you selected when you set up the database. Note: All connections to SQL Server must be performed using the same version of the JDBC driver. This includes the repository as well as all resource adapters that manage or require SQL Server accounts or tables, including the Microsoft SQL adapter, Microsoft Identity Integration Server adapter, Database Table adapter, Scripted JDBC adapter, and any custom adapter based on these adapters. Conflict errors occur if you attempt use different versions of the driver.
LocalFiles Path: `c:\jakarta-tomcat\webapps\idm\config`	Enter the directory location, or click Browse to locate it.
Sun Java System Directory Server Initial Context Factory: `com.sun.jndi.ldap.LdapCtxFactory` URL: `ldap://host.your.com/dc=myDomain,dc=your,dc=com` User: `waveset`	Enter the database location. Optionally enter the password you selected when you set up the database.