SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 05:20 AM
| ||||
| ||||
 SQLException When attempting to use the native iSeries JDBC driver to access the local iSeries DB2 db, I get the following SQLException: "The Username and/or password supplied is incorrect." (SQL1403N) The JDBC Driver used is: com.ibm.db2.jdbc.app.DB2Driver and the URL string is: jdbc:db2:MYDATABASE;errors=full;translate binary=true;naming=system;libraries=ICBSUATDB1 ICBSSMS712;user=MYUSER;password=MYPASSWORD The configuration is a Java application and a DB2 both on the _same_ iSeries (AS/400) machine. I have tried different renditions of the URL string, in particular: 1) With *LOCAL instead of MYDATABASE and 2) Without the user and password properties Four (4) combinations in all. In all four cases the above error ("The Username and/or password supplied is incorrect.") was gotten! (Reminder: Both Java app and DB2 db live on the same iSeries box) Any help as to (i) why this error occurs and (ii) how it can be eliminated would be _greatly_ appreciated!!! Panagiotis Varlagas Senior Software Developer, NovaBank S.A. varlagpa@novabank.gr varlagas@yahoo.com      |
|
02-27-2008, 05:21 AM
| ||||
| ||||
| Re: SQLException varlagas@yahoo.com wrote: > When attempting to use the native iSeries JDBC driver to access the > local iSeries DB2 db, I get the following SQLException: > > "The Username and/or password supplied is incorrect." (SQL1403N) > > The JDBC Driver used is: com.ibm.db2.jdbc.app.DB2Driver Try this: Connection con = DriverManager.getConnection("jdbc:db2:MYDATABASE;e rrors=full;translate binary=true;naming=system", "myuser, "mypass"); If this fails: Properties prp = new Properties(); prp.put("errors","full"); prp.put("translate binary","true"); prp.put("naming","system"); prp.put("user","myuser"); prp.put("password","mypass"); Connection con = DriverManager.getConnection("jdbc:db2:MYDATABASE", prp); Bernd -- "Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?" "Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe des 18. März in Berlin |
Linear Mode
