MX 2.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—524944-008

3-35

Troubleshooting MFC

When performing the above operations, the execute() call fails when an invalid module

file is found in the MFC. However, subsequent prepare() calls create a new module file.

This open issue is similar to the Driver Side Cache (DSC) present in the JDBC/T4

driver.

Stmt1.execute() Success Failure MXOSRVR turned the

SQL/MX CQD

recompilation_warnings

ON. SQL/MX throws

SQL exception upon

similarity check failure

and MXOSRVR drops

the invalid module file

from the

<compiled_module_l

ocation> location.

Stmt1 = Pre-

pare("select * from

testing")

Success Success A new plan is created in

the MFC location.

Stmt1.execute() Success Success MFC statement works

as expected.