nerdexam
IBM

C9510-418 · Question #29

An administrator configures an IBM DB2data source at cell scope. The environment variable DB2UNIVERSAL_JDBC_DRIVER_PATH is configured at cluster scope. The data source test connection on one node…

The correct answer is C. DB2UNIVERSAL_JDBC_DRIVER_PATH is configured at cluster scope. Check that the variable is correctly defined at the scope where the JDBCProvider/DataSource is Note: At runtime, WebSphere Application Server invokes a physical data source by resolving the appropriate variable at a level where one of the following criteria exists: The scope of…

Troubleshooting

Question

An administrator configures an IBM DB2data source at cell scope. The environment variable DB2UNIVERSAL_JDBC_DRIVER_PATH is configured at cluster scope. The data source test connection on one node succeeds, but fails on the other node with java.lang.ClassNotFoundException:com.ibm.db2.jcc.DB2ConnectionPoolDataSource. Which of the below is the likely cause for the exception?

Options

  • AThe data source is configured at cell scope.
  • BMultiple driver JARs are installed on the second node.
  • CDB2UNIVERSAL_JDBC_DRIVER_PATH is configured at cluster scope.
  • DA different version of the JDBC driver JAR does not exist on the second node.

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    80% (24)
  • D
    13% (4)

Explanation

Check that the variable is correctly defined at the scope where the JDBCProvider/DataSource is Note: At runtime, WebSphere Application Server invokes a physical data source by resolving the appropriate variable at a level where one of the following criteria exists: The scope of the variable can contain the data source configuration; that is, the variable has the The variable and the data source have identical scopes. Application Server meets these conditions by attempting to resolve the variable at each level of the scope spectrum. That is, the product tries to resolve the variable in the server scope, then the cluster scope, then the node scope, and lastly the cell scope.

Topics

#JDBC driver#environment variable scope#cluster scope#ClassNotFoundException

Community Discussion

No community discussion yet for this question.

Full C9510-418 Practice