RE: JAVA400-L Digest, Vol 3, Issue 17

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: murali dhar
> 
> We use a proxy that uses pure sql requests and have the option of
using
> proxy files which uses introspection to determine AS400 file
description
> so there fore its truly platform independent..

You may want to stop using buzzwords in your posts and start just
telling us what the software does.  The buzzwords are conflicting.

For example, how does introspection make SQL more platform independent?
Introspection is used on classes, so how can introspection determine the
fields of a file?  Unless you are performing introspection on a JTOpen
class such as the AS400FileDescription, at which point you are LESS
platform independent, not more.

It seems you want to use pure JDBC in order to access your data.  That's
a reasonable approach in fairly trivial applications, but it's slower as
you've already seen.  A better solution in many cases is stored
procedures; and for the iSeries the best is to use a message-based
server solution communicating with an RPG back end.  This is what I do.

In any case, the real trick of platform independence is NOT to use the
lowest common denominator (JDBC).  The real trick is to build
intelligence into your application and use some sort of configuration
file to allow you to use the best possible component for each part of
your application.

But, back to your original question, my guess is that you want to
somehow access QTEMP files with JDBC.  That means you need to use the
same job for the JDBC requests as you do for the programs you call that
build the temporary files.  I have no idea how to do that.

Joe