some diffrence in oracle query and mysql query

View: New views
1 Messages — Rating Filter:   Alert me  

some diffrence in oracle query and mysql query

by mfa :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

sir i see both query in SessionBean1

mysql  query

SELECT ALL usert.username,
                    usert.userid,
                    usert.camid  FROM usert

this not use user name


oracle query


SELECT ALL MFA.LUSER.USERID,
                    MFA.LUSER.TITLE,
                    MFA.LUSER.CAMPID,
                    MFA.LUSER.PWD,
                    MFA.LUSER.USERNAME
FROM MFA.LUSER


the user name mfa is use in this query you can see

this is main diffrence

but i yse both in code but not get result


try {
            RowKey userRowKey = luserDataProvider.findFirst
              (new String[] { "MFA.LUSER.USERNAME" },
               new Object[] { textField4.getText()});
           if (userRowKey == null) {
            textField3.setText("11111");  
               return null;
           }               else {
               textField3.setText("22222");  
                return null;          
           }
        }
                 catch (Exception e) {
            log("Cannot perform login for userid " + textField3.getText(), e);
            error("Cannot perform login for userid " + textField3.getText() + ": " + e);
          textField3.setText("77777");  
            return null;
       






problem in only oracle not in mysql

please give me idea how i get result

thank you



LightInTheBox - Buy quality products at wholesale price