My database name is TEST usename is db2inst1 password is db2inst1 table name is USERS
when i execute this code i get com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2INST1.USERS, DRIVER=3.50.152 please help String username=request.getParameter("user"); username.trim(); String password=request.getParameter("pass"); password.trim(); Connection con=null; try{ Class.forName("com.ibm.db2.jcc.DB2Driver"); con = DriverManager.getConnection("jdbc:db2://localhost:50000/TEST","db2inst1","db2inst1"); out.println("connection made\n"); out.println("0"); Statement stmt = con.createStatement(); out.println("1"); ResultSet rs = stmt.executeQuery("SELECT * FROM USERS WHERE USERNAME='"+username+"'"); out.println("2"); if(rs.next()) { String pass = rs.getString("PASSWORD"); if(pass.equals(password)) { out.println("login successful"); } } }catch(Exception e){out.println(e.toString()); } -- You received this message because you are subscribed to the Google Groups "Java EE (J2EE) Programming with Passion!" group. To post to this group, send email to java-ee-j2ee-programming-with-passion@googlegroups.com To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.