Forgot to mention, connection info goes into the system log. DSPLOG QHST. You may find more information there.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Kimmel
Sent: Friday, December 09, 2011 11:38 AM
To: Java Programming on and around the IBM i
Subject: RE: More, Re: Can anybody suggest any reasons why BIRT would be unable to establish a JDBC connection, when running on the same physical box?

QZDASOINIT jobs all run under QUSER, but the effective user profile is switched when the connection is made. There should be an entry in your logs like

User BRAD from client 10.8.2.134 connected to server.

When that entry is made the user profile is switched.

Your connection is probably being refused with no user and password being included. That may not even get to a QZDASOINIT job. I think the user validation is done by the listener job, which, I think, is QZDASRVSD on port 8471. Once validated, the listener binds one of the QZDASOINIT jobs to the user profile and then turns over communications to it.


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of James Lampert
Sent: Friday, December 09, 2011 10:51 AM
To: Java Programming on and around the IBM i
Subject: More, Re: Can anybody suggest any reasons why BIRT would be unable to establish a JDBC connection, when running on the same physical box?

The QZDASOINIT jobs appear to be running under QUSER. And the WTI1### library is *PUBLIC *ALL, as are the PFs, native LFs, and SQL Views therein.

--
JHHL
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx 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 IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx 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-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2022 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.