RE: Java Programs that Access Files created in QTEMP

No, you can not access the same QTEMP from command call connection and JDBC
connection, because when you use a Command Call connections , it has its own
QTEMP, and when you create the JDBC connections, it's has another QTEMP. is
not the same!!, The best solution I found when I had the same problem was as
follow: I just create members over a File.

I hope this helps!!
Ricardo Torres
Via Systems 
MIS Team

> -----Original Message-----
> From: Jerrold_Bisera@countrywide.com [SMTP:Jerrold_Bisera@countrywide.com]
> Sent: Tuesday, July 25, 2000 11:45 AM
> To:   JAVA400-L@midrange.com
> Subject:      Re: Java Programs that Access Files created in QTEMP
> 
> 
> The programs would run on the AS400.  I was thinking about using a Java
> program that called a CL/RPG to create a file in QTEMP.  The file would
> then be used by the Java program to do some processing.  JDBC request
> would
> be made by the Java program using the native driver.
> 
> 
> 
> 
> 
> Andrew_Goodspeed@lbss.com@midrange.com on 07/25/2000 09:26:29 AM
> 
> Please respond to JAVA400-L@midrange.com
> 
> Sent by:  owner-java400-l@midrange.com
> 
> 
> To:   JAVA400-L@midrange.com
> cc:
> 
> Subject:  Re: Java Programs that Access Files created in QTEMP
> 
> 
> 
> 
> Yes, but the question is which QTEMP?
> 
> If you are running programs over a single  AS/400 connection (within the
> same
> AS/400 job), then there is only one QTEMP, and there should be no
> problems.
> The
> problems occur when you, for example, create a file in QTEMP from a
> program
> run
> over a connection, and then try to access it with a JDBC request, which is
> served by a different job with its own QTEMP; of course the file is not
> going to
> be there.
> 
> As with most thing, it comes down to figuring out what you are trying to
> do, and
> picking an appropriate solution.
> 
> Is that at all helpful?
> 
> Andrew Goodspeed
> London Bridge Group
> Atlanta (Norcross), GA  USA
> 
> 
> 
> 
> >Has anyone created a file in QTEMP and used a java program to access it?
> >I'm new to Java and wanted to know if this is easy to do and if there are
> >any special considerations.  Any code examples would be of great help.
> >Thanks in advance.
> 
> 
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to JAVA400-L@midrange.com.
> | To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: joe@zappie.net
> +---
> 
> 
> 
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to JAVA400-L@midrange.com.
> | To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: joe@zappie.net
> +---
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---