Jul 13, 2017 IBM Data Server Driver 11.1 License File sam41.lic July 12, 2017 05:20 PM Hello, We've upgraded from DS Driver 10.5 to 11.1 and it appears that the license file now required is sam41.lic. It is working with that license, but I'm trying to confirm that this is the correct file so that we don't have any issues down the road (such as having a time.
Note –For any given database, there should only be one JAR file withJDBC drivers installed at any given time. When installing JAR files, inspect WEB-INF/lib and remove any JAR files that contain conflicting JDBCdrivers. 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 utilizeJDBC driver JAR files located in the WEB-INF/lib directory.The same JAR file that supports your repository will also support any manageddatabase 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 renaminga .jar file to include the name of the database followedby jdbc is recommended to help administrators avoid JARfile 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 followingfiles: db2jcc_license_cisuz.jar db2jcc_license_cu.jar |
|
MySQL | Select a version of MySQL Connector/J to download. |
|
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. |
|
SQL Server | Microsoft SQL Server 2005 Driver for JDBC/lib |
|
JDBC 2.0 Data Source | Depends on the directory service. Consult the documentation for yourapplication server or other directory service to locate an appropriate JARthat contains the InitialContextFactory class. | Copy the appropriate JAR (or JARs) to the WEB-INF/lib directory. |
For a DataSource connection, you must copy or download (and placeinto WEB-INF/lib) a JAR that contains the InitialContextFactory class.
Refer to the following table when installing the Waveset softwareand completing database selections on the Locate Waveset Repositorypanel.
If your selection is: | Enter |
|---|---|
JDBC 2.0 Data Source
| Enter the database location. Optionally enter the password you selectedwhen you set up the database. |
MySQL
| Enter the database location and the password you selected when you setup the database. |
Oracle
| Enter the database location and the password you selected when you setup the database. |
DB2
| Enter the database location and the password you selected when you setup the database. |
SQLServer Default values, to be used with the MicrosoftSQL Server 2005 JDBC Driver:
| Enter the database location and the password you selected when you setup the database. Note: All connections to SQL Servermust be performed using the same version of the JDBC driver. This includesthe repository as well as all resource adapters that manage or require SQLServer accounts or tables, including the Microsoft SQL adapter, MicrosoftIdentity Integration Server adapter, Database Table adapter, Scripted JDBCadapter, and any custom adapter based on these adapters. Conflict errors occurif you attempt use different versions of the driver. |
LocalFiles
| Enter the directory location, or click Browse to locate it.
|
Directory Server (Sun Java System DirectoryServer)
| Enter the database location. Optionally enter the password you selectedwhen you set up the database. |
Am getting this error can you please helpjcct410509134544.14.113 Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalidor was not activated for the DB2 for z/OS subsystem.
If you are connecting directly tothe data server and using DB2 Connect Unlimited Edition for System z, perform theactivation step by running the activation program in the license activation kit.If you are using any other edition of DB2 Connect, obtain the license file,db2jcclicensecisuz.jar, from the license activation kit, and follow the installationdirections to include the license file in the class path. ERRORCODE=-4230, SQLSTATE=42968.