RE: issue with Authority while setting connection library list

Ashish,

If you are running auditing (you should consider it if you are not) then
you can check QAUDJRN for the security exception. Specifying *AUTFAIL
for QAUDLVL is what will take care of that particular exception. When
auditing, it would show up using something like: DSPJRN JRN(QAUDJRN)
FROMTIME(somedate) ENTTYP(AF).

David Morris

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Thursday, May 04, 2006 8:53 AM
To: java400-l@xxxxxxxxxxxx
Subject: issue with Authority while setting connection library list

Hi
Is it possible to find which library user is not
authorized while creating JDBC connection.
It creates a connection but gives error saying library
list not set bcause of authority issue.
Here is the code i am using

AS400JDBCConnectionPoolDataSource dataSource = new  
AS400JDBCConnectionPoolDataSource(ip,userId,
password);
         dataSource.setDateFormat("iso");
         dataSource.setPrompt(false);
         dataSource.setTimeFormat("hms");
         dataSource.setNaming("system");
         dataSource.setErrors("full");
         dataSource.setTrace(true);
         dataSource.setTranslateBinary (true);
         dataSource.setLibraries(libraryList);

         AS400JDBCConnectionPool pool = new
AS400JDBCConnectionPool(dataSource);
         pool.fill(minConnection);
         return pool;



A$HI$H