RSS Feed for This PostCurrent Article

Java: Alter Oracle Session Information using iBATIS

There are times that you may want to alter Oracle session information. If you are using iBATIS, this can be done the following way

Create the update statement. E.g.

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-// SQL Map 2.0//EN" "" >
<sqlMap namespace="TEST">
    <update id="update_sort_area_size" parameterClass="int">
        alter session set sort_area_size=#value#
     <update id="update_sort_area_retained_size" parameterClass="int">
        alter session set sort_area_retained_size=#value#

Then just use the SqlMapClient.update method to call the respective statement. E.g.

Integer val = 65535;

Trackback URL

Sorry, comments for this entry are closed at this time.