RE: How to get the current user ID after sign on to AS400

["Todd Cameron" <todd_cameron@xxxxxxxxxxxxxxxx>]

Xu, Weining,

Sorry for any confusion I may have caused you.
I need to force a connection in the code before it can work. Here is another
attempt.

import java.io.File;
import java.sql.*;

import javax.swing.*;
import com.ibm.as400.access.*;

public class ConnectTest {

  public static void main(String args[]) {

    AS400 myAS400 = new AS400("MYSYSTEM");
    String jdbcURL = "";

    try {
      myAS400.connectService(AS400.CENTRAL);
      Class.forName("com.ibm.as400.access.AS400JDBCDriver");
    } catch(Exception e) {
            System.out.println(e.toString());
    }

    String systemName  = myAS400.getSystemName();
    String userID = myAS400.getUserId();
    Connection c;

    JOptionPane.showMessageDialog(null, "UserID =" + userID);

    try {
      if (userID.equals("TODD"))
          jdbcURL = "jdbc:as400://" + systemName + "/TODD";
      else
        if (userID.equals("Tom"))
          jdbcURL = "jdbc:as400://" + systemName + "/databaseTom";

      c = DriverManager.getConnection(jdbcURL);
      System.out.println("Driver connected -- Success");
      c.close();
    }

    catch (Exception e) {
      System.out.println("Driver failed - null Connection returned." + e);
    }

    System.out.println("\nConnection Test Done.");
    System.exit(0);
  } // end main
}


--- "Xu, Weining" <Weining.Xu@AIG.com> wrote:
> Hi, all,
>
> I have a program using JDBC driver to access DB2 on
> AS400.  I will let the
> different users to use different testing
> databases(libraries) on AS400.  So
> after the program connected to AS400, I need to know
> the user ID who just
> signed on AS400 in order to set up a URL as
> "jdbc:as400://mysystem/databaseXYZ".  Then use this
> URL to make a
> connection, such as:  con =
> DriverManager.getConnection(URL);
>
> Is there anyway I could get the current userID,
> something like:
>
> if (userID.equals("John")){
>       URL = "jdbc:as400://mysystem/databaseJohn";
> }
> else if (userID.equals("Tom")){
>       URL = "jdbc:as400://mysystem/databaseTom";
> }
>
> con = DriverManager.getConnection(URL);
>
> Thanks for any helps.
>
> Wayne
>
>
>
> _______________________________________________
> 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.
>


__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
_______________________________________________
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.