Re: Data access across libraries

[Donald Whittaker <donald_whittaker@xxxxxxxxx>]

   Just a wild guess, but are these problems compiled
with the same DYNUSRPRF?

Don Whittaker

--- "Bharath V.S. Dhurjati" <bharath@pswebworks.com>
wrote:
> 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.
> > >
>
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com