Re: Data access across libraries

["Dave Wall" <dawall@xxxxxxxxxx>]

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.