>>
Unexpected method call prepareStatement("SELECT AGE FROM CUSTMR WHERE ID = 3", 1003, 1007):
prepareStatement("SELECT AGE FROM CUSTMR WHERE ID = 3"): expected: 1, actual: 0
<<

When you mock the prepareStatement() call, u need to specify the resultSetType & resultSetConcurrency also. Since at run time that is the version that is connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency) that is invoked

Mario Briggs