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?

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.