Upgrade from 6.1 (with all latest cume/groups) to 7.1 (with all latest cume/groups)...
Coincidently perhaps, things seem to be working. As a workaround I set the native SQL PATH in the subprocedure that creates the JDBC connection. The idea was to issue the SET PATH = "lib1","lib2" to force native SQL to have the necessary libs. I think just by changing the module that creates the JDBC connection to SQLRPGLE the SQL server mode is smart enough to grab the calling job's libl now. Before it was blank, and now it has the full libl -- not just the couple of libs I specified in the SET PATH.
Very odd, but hopefully this will continue to work.
----------------------------------------
From: "Luis Rodriguez" <luisro58@xxxxxxxxx>
Sent: Monday, July 26, 2010 11:24 AM
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Subject: Re: SQL Errors after 7.1 upgrade?
Dave,
From which release are you upgrading?
Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries
--
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.