Resolving problems with the JDBC driver
HCL Workload Automation is supplied using the JDBC driver type 4 for DB2® and type 2 for Oracle. However, each can use the other driver type, if necessary. HCL Software Support might ask you to change to this driver. This section tells you how.
Attention: This procedure must only be performed under the control of HCL Software Support.
To change the driver you need to change the data source properties
following the procedure described in Changing the database host name, port, or database name. However, the parameters
that you change are different. This is an example of the type 4 and
type 2 parameters for DB2:
- JDBC driver type 4 parameters
-
################################################################ # DB2 Type4 Resource Properties ################################################################ DB2Type4JndiName=jdbc/twsdb DB2Type4DatabaseName=TWSZ DB2Type4DriverType=4 DB2Type4ServerName=myhost.mydomain.com DB2Type4PortNumber=50000 DB2Type4SslConnection=false DB2Type4Description= DB2Type4TraceLevel= DB2Type4TraceFile= DB2Type4FullyMaterializeLobData=true DB2Type4ResultSetHoldability=2 DB2Type4CurrentPackageSet= DB2Type4ReadOnly=false DB2Type4DeferPrepares=true DB2Type4CurrentSchema= DB2Type4CliSchema= DB2Type4RetrieveMessagesFromServerOnGetMessage=true DB2Type4ClientAccountingInformation= DB2Type4ClientApplicationInformation= DB2Type4ClientUser= DB2Type4ClientWorkstation= DB2Type4CurrentPackagePath= DB2Type4CurrentSQLID= DB2Type4KerberosServerPrincipal= DB2Type4LoginTimeout=0 DB2Type4SecurityMechanism= DB2Type4TraceFileAppend=false DB2Type4CurrentFunctionPath= DB2Type4CursorSensitivity= DB2Type4KeepDynamic= DB2Type4CurrentLockTimeout= DB2Type4EnableMultithreadedAccessDetection=false DB2Type4Reauthentication=false DB2Type4JmsOnePhaseOptimization=false DB2Type4PreTestSQLString=SELECT 1 FROM SYSIBM.SYSDUMMY1 DB2Type4DbFailOverEnabled=false DB2Type4ConnRetriesDuringDBFailover=100 DB2Type4ConnRetryIntervalDuringDBFailover=3000 # DB2Type4IsolationLevel can be one of the following: # CURSOR_STABILITY or READ_STABILITY DB2Type4IsolationLevel=CURSOR_STABILITY - JDBC Driver type 2 parameters
-
################################################################ # DB2 Type2 Resource Properties ################################################################ DB2Type2JndiName= DB2Type2Description= DB2Type2ConnectionAttribute=cursorhold=0 DB2Type2EnableMultithreadedAccessDetection=false DB2Type2Reauthentication=false DB2Type2JmsOnePhaseOptimization=false DB2Type2DatabaseName=TWSZ_DB DB2Type2PreTestSQLString=SELECT 1 FROM SYSIBM.SYSDUMMY1