Re: JDBC error -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

On Mon, 28 Oct 2013, CRPence wrote:

On 10/28/13 1:10 PM, James Rich wrote:

<<SNIP>> There is something unusual happening when *any* file named
COCTLP is placed into library DMSIDEV. Whether I move the file,
create it new from source, or copy it from another location the
second row of results contains invalid data
*even though the data is correct when queried or viewed with DSPPFM*.

Perhaps an issue related to [prepared statement] caching. I would
try specifying a column-list for the SELECT instead of using the
asterisk to test if the problem is circumvented. FWiW I also would not
ignore close errors.

Fascinating. Changing the prepared statement did cure the problem. I'm doing my testing from a laptop that has been turned off over the weekend, so the caching that is occurring must be happening on the System i. Any suggestions on how I can instruct the System i to clear the cache besides an IPL?

James Rich

if you want to understand why that is, there are many good books on
the design of operating systems. please pass them along to redmond
when you're done reading them :)
- Paul Davis on ardour-dev

This mailing list archive is Copyright 1997-2024 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.