Ok, here is the query i made, but i don't know if it works. The connection to the db exists, but it won't execute. To make it clearer it doesn't reach the line "qdsUser.executeQuery();".
I hope i am clearer know,
thank you!
//check validation of username and password in db
QueryDataSet qdsUser= new QueryDataSet(); qdsUser.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(databaseOne, "SELECT USERNAME from USER WHERE USER.\"USERNAME\"=" +username+ "AND USER.\"PASSWORD\"=" +password+" ", null, true,Load.ALL));
If you put the whole query in a string and look at it (or log it -- although, you should probaly be careful about the password part appearing the a log), you will notice that you don't have a space between the username and the "AND ..." and you do have an extraneous space at the end of the query.
I don't know if this is the cause of the problem you're having based one the meager clues you've provided, though...
Previous Topic
