>Or can somebody suggest another solution? Maybe ask your DBA to increase max open cursors allowed? ;)
Honestly, I never quite understood iBATIS statement cacheing performance gains with oRACLE (which IMO maintains stetement cache on its own). Are you sure disabling it throughout your application affects performance?