Hi, I have found the solution in another post :
-------------------------------------------------------------------------------------------------------
Re: Quick questions JDBCR4
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!
-------------------------------------------------------------------------------------------------------
I have installed the old version of JTDS 1.2.8 instead of 1.3.1 and now the program works correctly.
Many thanks.
-----Messaggio originale-----
Da: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Per conto di CRPence
Inviato: sabato 22 febbraio 2014 19:37
A: rpg400-l@xxxxxxxxxxxx
Oggetto: Re: "JVMCFRE003 bad major version" message when using JDBCR4 service program by Scott Klement with V7R1M0
On 21-Feb-2014 02:14 -0800, Romanò Claudio wrote:
I am seeking help to get past this problem of connecting to an
external database.
I am attempting to connect to an external database from an iSeries
machine (V7R1M0) using the JTDS (Sourceforge) driver for SQLServer.
I have created an RPG program with the JDBCR4 service program bound
into it. All I'm try to do at present is connect to the database.
When I run the program I am unable to connect to the database and I
get the CPF9897 "JVMCFRE003 bad major version" message.
On Java console :
class=net/sourceforge/jtds/jdbc/Driver, offset=6 error message
<<SNIP>>
There are two [albeit improperly collated] comments that are located at the following link, both from "Craig.Schulstad... on Dec 12, 2012"
that may be of assistance. What is apparently the earlier post is an exact match to the symptoms included above along with the JTDS version, and what is apparently a later followup post includes what was an apparent resolution by having updated the JTDS driver to a newer version:
<
http://iprodeveloper.com/application-development/sql-server-jdbc-driver-tip>
"... I was able to sort out the issue with the jar file. I needed the
1.2.5 version ...
...
... I tried an older version of the JTDS driver file (1.2), but that did not resolve that issue. ..."
FWiW the effective identical code snippet appears in a sourceforge.net discussion forum, describing the identical symptom, and has no responses:
<
http://sourceforge.net/p/jtds/discussion/104389/thread/08d26b06/>
Creator: Rob Marais Created: 2013-11-20
--
Regards, Chuck
--
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.
midrange.com
