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 file that you are replacing before starting Waveset.
Databases that are managed resources also utilize
JDBC driver JAR files 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 JAR files,
Oracle recommends renaming JAR files 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
Note: A JDBC Type 4 driver should be downloaded.
Type 2 OCI drivers are not supported.
|
-
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 Waveset software
and completing database selections on the Locate Waveset Repository
panel.
If your selection is:
|
Enter
|
JDBC 2.0 Data Source
|
Enter the database location. Optionally enter the password you selected
when you set up the database.
|
MySQL
|
Enter the database location and the password you selected when you set
up the database.
|
Oracle
|
Enter the database location and the password you selected when you set
up the database.
|
DB2
|
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
|
Enter the directory location, or click Browse to locate it.
|
Directory Server (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.
|