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