Re: Shared login for JDBC

This is what I have found to work.

When using the native driver, specify a system of *local or localhost in
the URL. (Blank doesn't work).

String driver = "com.ibm.db2.jdbc.app.DB2Driver";
String url = "jdbc:db2:*local";

When using the Toolbox driver, specify a system of localhost or leave it
blank in the URL.  Leaving it blanks causes a local connection to be used
when executing on the iSeries.  If you are running from your PC, it
prompts.

String driver = "com.ibm.as400.access.AS400JDBCDriver";
String url = "jdbc:as400:localhost";

I don't specify a userid, password in the URL or properties in these cases.



                                                                           
             Franco Biaggi                                                 
             <fbiaggi@xxxxxxxx                                             
             om>                                                        To 
             Sent by:                  Java Programming on and around the  
             java400-l-bounces         iSeries / AS400                     
             @midrange.com             <java400-l@xxxxxxxxxxxx>            
                                                                        cc 
                                                                           
             06/06/2005 12:24                                      Subject 
             PM                        Re: Shared login for JDBC           
                                                                           
                                                                           
             Please respond to                                             
             Java Programming                                              
             on and around the                                             
              iSeries / AS400                                              
             <java400-l@midran                                             
                  ge.com>                                                  
                                                                           
                                                                           




Adam,
if I right understand your need,
user *local as userdId without password.

Ciao.

Adam Stotts wrote:

> Hi everyone,
>
> My client wants to use the user profile of the job that's running the
> RUNJVA
> command for authenticating JDBC Connections. Is there a way to "adopt"
> the batch job's USRPRF when
> opening a JDBC connection using a JDBC driver, without requiring the
> user's password (which you
> can't access programmatically anyway)?
>
> TIA,
>
> Stubber



--
-----------------------------------------------------------------------------

*** This messages was scanned for malicious contents ***
-----------------------------------------------------------------------------

Franco Biaggi
CH-6807 Taverne


--
This is the Java Programming on and around the iSeries / AS400 (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.