|
That's probably why it's making you specify userid and password. If you are able to use the DB2 JDBC driver (i.e. DRDA), you don't need to specify a userid and password, null parameters will do, it just runs under whatever is the default user profile for the DRDA link - if *LOCAL the user profile of your job, if SNA the default for the appopriate mode's comms entry at the target. If TCP/IP DRDA link my experience is that you do need a userid/password, but others may be able to help. If you're doing a *local* Toolbox connection you may be able to get away with null userid and password too - anyone able to comment? Mandy Marco_Van_Maris@ept.lu on 10/27/2000 12:36:47 PM Please respond to JAVA400-L@midrange.com To: JAVA400-L@midrange.com cc: (bcc: Mandy Shaw/Pacific/UK) Subject: Re: JDBC : How to handle user-id and password I am using the Toolbox JDBC driver. marco mandy.shaw@uk.catalyst-solutions.com on 27/10/2000 13:04:37 Please respond to JAVA400-L@midrange.com To: JAVA400-L@midrange.com cc: (bcc: Marco Van Maris/EPT) Subject: Re: JDBC : How to handle user-id and password Are you using the DB2 or the Toolbox JDBC driver? The situation varies depending on the answer to this. Marco_Van_Maris@ept.lu on 10/27/2000 10:28:29 AM Please respond to JAVA400-L@midrange.com To: JAVA400-L@midrange.com cc: (bcc: Mandy Shaw/Pacific/UK) Subject: JDBC : How to handle user-id and password
Dear all. I've written a Java programm which extracts data from tables on our AS/400 using JDBS calls. The programm is supposed to run on the AS/400 (OS 4.3). The question is how do I best handle the userid and password that are needed to connect to the DB2 using the DriverManager.getConnection method ? Right now I have hardcoded both into my programm what I don't really like. The doc says that if you run it on the AS/400 the user-profile and password from the user that started th job would be used. In our case this does not happen,you have to indicate user-id and password. Is this some PTF stuff or will OS 4.4 or 4.5 resolve that issue ? Thanks for your feedback Marco van Maris EPT Luxembourg Electronic information is not secure, therefore the Entreprise des Postes et Télécommunications accepts no responsibility whatsoever for the contents of this message, which is intended for the addressee only. Its contents and any attached files are strictly confidential. If you have received this message in error, please telephone the following number 4765-1. +--- | 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 +--- Regards, Mandy Shaw Catalyst Solutions plc Kingfisher House Frimley Business Park Camberley Surrey GU16 5SG UK http://www.catalyst-solutions.com Email: Mandy.Shaw@uk.catalyst-solutions.com Telephone: +44 (0)870 166 1000 DDI: +44 870 166 1324 Facsimile: +44 870 168 3920 Mobile: +44 410 447966 Email to mobile 'phone: mandyshaw@sms.genie.co.uk ---------------------------------------------------------------------- ---------------------------------------------------------------------- Catalyst Solutions plc. Registered No 2918101. Registered @ Kingfisher House, Frimley Business Park, Frimley, Surrey. GU16 5SG U.K. NOTICE: This message is intended only for the named addressee(s) and may contain confidential and/or privileged information. If you are not the named addressee you should not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify postmaster@catalyst-solutions.com and delete the message and any attachments accompanying it immediately. ---------------------------------------------------------------------- Regards, Mandy Shaw Catalyst Solutions plc Kingfisher House Frimley Business Park Camberley Surrey GU16 5SG UK http://www.catalyst-solutions.com Email: Mandy.Shaw@uk.catalyst-solutions.com Telephone: +44 (0)870 166 1000 DDI: +44 870 166 1324 Facsimile: +44 870 168 3920 Mobile: +44 410 447966 Email to mobile 'phone: mandyshaw@sms.genie.co.uk ---------------------------------------------------------------------- ---------------------------------------------------------------------- Catalyst Solutions plc. Registered No 2918101. Registered @ Kingfisher House, Frimley Business Park, Frimley, Surrey. GU16 5SG U.K. NOTICE: This message is intended only for the named addressee(s) and may contain confidential and/or privileged information. If you are not the named addressee you should not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify postmaster@catalyst-solutions.com and delete the message and any attachments accompanying it immediately. ----------------------------------------------------------------------
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.