× 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.



Sorry, I don't know much about embedding SQL in RPG.  I still recommend
working this through service.

David Wall
AS/400 Toolbox for Java




                    "Bharath V.S.
                    Dhurjati"                To:     <java400-l@midrange.com>
                    <bharath@pswebwork       cc:
                    s.com>                   Subject:     Re: Data access 
across libraries
                    Sent by:
                    java400-l-admin@mi
                    drange.com


                    10/16/2001 10:08
                    AM
                    Please respond to
                    java400-l





Yes, Dave. All connections are setup the same way, same userid/pwd, same
naming (system) with the same default library.
The worst part is that this does not happen consistently: We've isolated
the
problem to some stored procedures that use SQL.
Is there something with embedded SQL in RPG that might cause this?

Thanks.

Regards,
Bharath.

----- Original Message -----
From: "Dave Wall" <dawall@us.ibm.com>
To: <java400-l@midrange.com>
Sent: Tuesday, October 16, 2001 10:50 AM
Subject: Re: Data access across libraries


>
> Are all the connections set up the same?  Do they all use the same naming
> convention?  Do they all specify the same default library (or omit the
> default library)?  I can't think of anything else that would cause data
to
> come from the 'wrong' library.  If it isn't a connection setup difference
> then the next step is to call service so they can take some traces to
find
> out what is going on.
>
> David Wall
> AS/400 Toolbox for Java
>
>
>
>
>                     "Bharath V.S.
>                     Dhurjati"                To:
<java400-l@midrange.com>
>                     <bharath@pswebwork       cc:
>                     s.com>                   Subject:     Re: Data access
across libraries
>                     Sent by:
>                     java400-l-admin@mi
>                     drange.com
>
>
>                     10/16/2001 09:32
>                     AM
>                     Please respond to
>                     java400-l
>
>
>
>
>
> 1. Yes, there is connection pooling going on: We are using WebLogic
> provided
> connection pooling
> 2. The 'change lib' procedure is called every time after getting a
> connection from the pool and before invoking normal stored procedure.
>
> Thanks.
>
> Regards,
> Bharath.
>
>
> ----- Original Message -----
> From: "Dave Wall" <dawall@us.ibm.com>
> To: <java400-l@midrange.com>
> Sent: Tuesday, October 16, 2001 10:11 AM
> Subject: Re: Data access across libraries
>
>
> >
> > Is there any connection creation or connection pooling going on?
> >
> >    Connection creation -- each new connection results in a new server
job
> >    on the AS/400, so you need to re-run your CL program every time you
> >    create  new connection.
> >
> >    Connection pool -- re-run you CL program each time you grab a
> connection
> >    out of a pool so the library is correct.
> >
> > David Wall
> > AS/400 Toolbox for Java
> >
> >
> >
> >
> >                     "Bharath V.S.
> >                     Dhurjati"                To:
> <java400-l@midrange.com>
> >                     <bharath@pswebwork       cc:
> >                     s.com>                   Subject:     Data access
> across libraries
> >                     Sent by:
> >                     java400-l-admin@mi
> >                     drange.com
> >
> >
> >                     10/16/2001 12:39
> >                     AM
> >                     Please respond to
> >                     java400-l
> >
> >
> >
> >
> >
> > This is a multi-part message in MIME format.
> > --
> > [ Picked text/plain from multipart/alternative ]
> > Hi folks,
> >
> > Background:
> > We are using DB2 on an AS/400 V4R4 from a WebLogic server housed on a
> Win2K
> > m/c.
> > DB2 access is via JDBC using the ToolBox driver.
> >
> > We use stored procedures for most of the data access.
> > We have the same set of tables in various libraries but the data in
them
> is
> > different.
> > Before calling any  stored procedure, we call a special "library
switch"
> > stored proc ( a CL program to switch current library).
> >
> > Problem:
> > We are facing a problem: Sometimes, the stored procedures fetch data
from
> a
> > library other than the intended 'current' library?
> > This occurs randomly.
> >
> > Why is this happening? Is there a fix?
> >
> > Thanks.
> >
> > Regards,
> > Bharath.
> >
> > --
> >
> > _______________________________________________
> > This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L)
> > mailing list
> > To post a message email: JAVA400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > or email: JAVA400-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/java400-l.
> >
> >
> >
> >
> >
> > _______________________________________________
> > This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L)
> mailing list
> > To post a message email: JAVA400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > or email: JAVA400-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/java400-l.
> >
> >
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400
(JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>
>
>
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400
(JAVA400-L)
mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.







As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.