RE: Quick JDBCR4 questions

What version of Java and/or components of Java do I need to make this program work? I'm now on my 3rd attempt to get this iSeries-->SQL Server working. I always get the following errors..

UnsupportedClassVersionError: net/sourceforge/jtds/jdbc/Driver

And a whole wrath of other messages, all related to ClassLoader



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Monday, October 07, 2013 3:32 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Quick JDBCR4 questions

James,

The object group cleans up everything /except/ the 'rsmd' object. You still need to clean that up when you're done. (Unless there's an additional begin/end object group that's taking care of it.)

You can refer to it throughout your program after it has been retrieved
-- UNTIL it gets cleaned up (for example, by ending the object group it's a part of, or freeing that particular object directly, etc.)

-SK


On 10/7/2013 1:14 PM, James H. H. Lampert wrote:

I probably shouldn't be given coffee breaks; it takes too long to
retrain me afterwards:

I have a ResultSetMetaData on a Connection, and I'm keeping it in a
static, module-level variable, in my interface program that calls the
JDBCR4 service program.

Scott's JDBC_GetMetaData function in JDBCR4 looks like:

jdbc_begin_object_group(50);
monitor;
temp = getMetaData( rs );
jdbc_end_object_group(temp: rsmd); on-error;
jdbc_end_object_group();
return *NULL;
endmon;
return rsmd;

I think I'm finding the answers for myself, just by framing the
questions, but

(1) the object group takes care of allocation and deallocation, so I
don't have to deallocate anything manually, do I?

(2) And since I'm putting what Scott's JDBC_GetMetaData in a static
variable, I can continue to access it so long as my interface program
remains active, right?

--
JHHL
(Back from a 2-week vacation, and forgetting a lot of what I was just
working on 2 weeks ago!)

--
This is the RPG programming on the IBM i (AS/400 and 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.




[Rodda Paint Company!]
Chuck Graves
Director of Information Systems
Rodda Paint Co.<http://www.roddapaint.com>
6107 N. Marine Drive
Portland, Oregon 97203
(503) 737-6042