RE: Connecting to the iSeries DB using a user with no password

[Colin Williams <colin.williams@xxxxxxxxxxxx>]

Martin,

Is this a local connection to the database, or is this from another system, 
as I don't think that local connections need a userid or password, 
they can use the current user profile to connect? 

Eg

                Connection con = null;

                CallableStatement cst = null;

                try
                {

                        log();

                        System.out.println(
                                "*** Running on JDK: " +
System.getProperty("java.version"));

                        // Declare JDBC driver name. 


                        Class.forName("com.ibm.db2.jdbc.app.DB2Driver");

                        // Create a JDBC connection object. 

                        Properties properties = new Properties();

                        properties.put("errors", "full");

                        properties.put("trace", "true");

                        properties.put("naming", "system");

                        con = DriverManager.getConnection("jdbc:db2:*local",
properties);
                        // toolbox equiv
"jdbc:as400://naming=system;trace=true;");

                        cst = null;

                        String sql_str = "call XX0080(?)";

                        cst = con.prepareCall(sql_str);

                        cst.setString(1, "X");

                        // Call the stored procedure. 

                        cst.execute();

                        // Read the output parameters into local variables. 

                        System.out.println("call successful");

cheers
Colin.W
 
Extension   5800
Direct dial   0870 429 6676
 


-----Original Message-----
From: McCallion, Martin [mailto:martin.mccallion@xxxxxxxxx] 
Sent: 21 May 2004 16:30
To: 'java400-l@xxxxxxxxxxxx'
Subject: Connecting to the iSeries DB using a user with no password


Hi all.

Our application has to integrate with another application which submits our
server job as a batch job.  Now the other application runs its batch jobs
under a paranoid level of security, in that the user profile it runs batch
jobs under has its password set to *NONE (I think it is also disabled, which
to my mind ought to mean that it shouldn't run the batch job, but that's
another story).

So our app has to run under that user.  Now I've modified our data queue
access so that such a user works, based on Dave Wall's post from the
archive: http://archive.midrange.com/java400-l/200204/msg00024.html.
Basically you call the AS400 constructor with no parameters, and then you
_don't_ call system.connectService(AS400.DATAQUEUE).  So our data queue
connections now work.

But I also have to make _database_ connections work.  So in short, is there
any way to make a database connection (using either toolbox or native
driver) using a user profile with password *NONE?

Cheers,

Martin.

-- 
Martin McCallion
Senior Technical Consultant
Misys Wholesale Banking Systems
1 St George's Road, London, SW19 4DR, UK
T +44 (0)20 8486 1951
F +44 (0) 20 8947 3373
martin.mccallion@xxxxxxxxx
www.misys.com

This email and any attachments have been scanned for known viruses using
multiple scanners. We believe that this email and any attachments are virus
free, however the recipient must take full responsibility for virus
checking. This email message is intended for the named recipient only. It
may be privileged and/or confidential. If you are not the intended named
recipient of this email then you should not copy it or use it for any
purpose, nor disclose its contents to any other person. You should contact
the Misys Banking and Securities Division as shown below so that we can take
appropriate action at no cost to yourself. 

Misys Banking and Securities Division, 1 St George's Road, Wimbledon,
London, SW19 4DR, England. Email: banking.postmaster@xxxxxxxxxx Tel: +44 (0)
20 8879 1188 Fax: +44 (0) 20 8947 3373 
_______________________________________________
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.


This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is The Nest, Rosary Road Norwich NR1 1TF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.