Re: Data access across libraries

["Bharath V.S. Dhurjati" <bharath@xxxxxxxxxxxxxx>]

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