RE: Embeded SQL ODP problem

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Schadd,

I'll bet your program is running in a named activation group that has not
yet been reclaimed.  You'll need to RCLACTGRP to close out the existing copy
of your program.

One easy fix (probably not the best way) is to recompile the program to
ACTGRP(*NEW), which should ensure that the activation group is destroyed
whenever the program ends.  Note that there is some overhead associated with
creating a new activation group, but I wouldn't expect it to be a problem in
most cases.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Schadd D Gray [mailto:list@xxxxxxxxxxxxx]
Sent: Tuesday, December 16, 2003 12:38 PM
To: RPG programming on the AS400 / iSeries
Subject: Embeded SQL ODP problem


I have a SQLRPGLE with a select statement in it.  I have compiled this
program with CLOSQLCSR(*ENDMOD).  However, after the program finishes I look
at the Open Data Paths for my job and the files in the SELECT statement are
still open.  I close the cursor prior to exiting the program.

I put the program in debug and my joblog shows the message SQL7914 "ODP not
deleted".

The main place this is causing me issue is in JDBC calls to these SQLRPGLE
programs, which are registered as stored procedures.  The system jobs for
JDBC end up having 300+ ODP's.

Is there a way to ensure the ODP's are deleted?

By the way, this is a hard coded SELECT statement (Not a prepared
statement).

OS - V5R2

Thanks,
Schadd Gray
Damon Technologies, Inc.
www.damontech.com
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.