Re: Quick JDBCR4 questions

Chuck,

JDBCR4 works with Java 1.3 or higher. However, the individual database drivers also have their requirements.

In your case, it sounds like you are using the jTDS driver (for Microsoft SQL Server).

If I recall correctly the version of Java that jTDS requires varies with the version of jTDS that you're using. jTDS 1.3.x requires Java 7, and jTDS 1.2.x works with older versions of Java.

So, you'll either want to install Java 7 (sometimes called "1.7") and if necessary, set your JAVA_HOME environment variable to point to it... or get an older version of jTDS. I used 1.2.5 successfully with older JVMs.

Good luck!



On 2/13/2014 2:38 PM, Graves, Chuck wrote:

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