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

Thanks, Don,

The getUserId() method could be called for a AS400 object.  But in my case,
I have the code like this:

String URL = "jdbc:as400://mysystem/databaseXYZ";
Class.forName("com.ibm.as400.access.AS400JDBCDriver");
con = DriverManager.getConnection(URL);

How do I get the AS400 object here.  The AS400 sign on screen was invoked at
the line of code:  con = DriverManager.getConnection(URL); After this line
was executed, con has an implicit object as400_ which contains the userId I
just signed on.
So I assume that I should have something like this after con =
DriverManager.getConnection(URL);

String user = aAS400.getUserID();

How could I get this implicit aAS400 object from con?  If I create a AS400
object as: AS400 aAS400 = new AS400(); that would not be the same object
(as400_) after the connection.

Any suggestions?

Wayne

-----Original Message-----
From: Donald Whittaker [mailto:donald_whittaker@yahoo.com]
Sent: Wednesday, September 19, 2001 4:16 PM
To: java400-l@midrange.com
Subject: Re: How to get the current user ID after sign on to AS400


   The AS400 (connection) object has a .getUserID()
method that returns a String.
URL = "jdbc:as400://mysystem/database" +
myAS400.getUserID();

Hope this helps,
Don Whittaker

--- "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.