Re: JDBC - log in?

The native JDBC driver does not need a user profile and password to run a
program.  It works just like the CLI would in this case.  Here is a portion
of the template program I use to recreate user issues.  Because I pass long
programs I create with this template for others to use, I do not want to be
concerned about my user profile and password being in the file.  This
always works just fine for me... I don't think you can connect with the
Toolbox JDBC driver without a user profile and password, but I do not know
for sure.


   public static final String DRIVER = "com.ibm.db2.jdbc.app.DB2Driver";
   //public static final String DRIVER =
"com.ibm.as400.access.AS400JDBCDriver";

// Configurable stuff...
   public String system         = "*LOCAL";
   public String userId         = "";
   public String password       = "";
   public String url            = "jdbc:db2://" +  system;
   public Connection connection = null;

/**
Handle all the needed setup work.
**/
   public void setup() {
      try {
         // Register the JDBC driver.
         Class.forName(DRIVER);

         // Get a global connection - choose how you which
         // to get the connection.
         connection = connectWithProperties();
         //connection = connectWithUserAndPassword();
         //connection = connectWithURLOnly();


         // Method for creating a new table if needed...
         // setupTable();


         // Handle starting the timer.
         if (doTiming)
            startTimer();

      } catch (Exception e) {
         System.out.println("Caught exception: " + e.getMessage());
         e.printStackTrace();
      }
   }

/**
Connect to the database passing in a URL and a properties object.
**/
   public Connection connectWithProperties()
   throws java.sql.SQLException {

      Properties properties = new Properties ();

      if (userId.length() != 0)
         properties.put ("user", userId);
      if (password.length() != 0)
         properties.put ("password", password);

      // Insert any other properties you would like....

      return DriverManager.getConnection(url, properties);
   }



Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

                                                                              

 Edgar Allan Poe
                                                                              

The Tell-Tale Heart"




"Luther Ananda Miller" <luther.miller@HYPERE.COM> on 02/08/2000 01:51:27 AM

Please respond to JAVA400-L@midrange.com

To:   "L-JAVA400@midrange.com" <JAVA400-L@midrange.com>
cc:
Subject:  JDBC - log in?




I think I already know the answer to this question ("NO") but I'll ask
anyway.

With C I can used embedded SQL and when a user runs the C program I compile
it into, no explicit database log in needs to be made. E.g., the program
just runs using the profile it was compiled with or run with depending on
how it was created. But the program does not need to know a username and
password to log in with.

Is there a way to accomplish this in Java too with native DB2 JDBC drivers,
or even the toolbox drivers? I would like the user to be able to run a java
program on the AS/400 without the program needing to either prompt the user
for a name and password or read a name and password in from a properties
file. I would like it to just use the user's profile ...

Luther

luther.miller @ hypere.com


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---