forums.smartfoxserver.com

Code: Select all

String userSQL = "SELECT * FROM BLABLA WHERE NAME=? LIMIT 1";
userResult = (ISFSArray) _dbManager.executeQuery(userSQL, new Object[] {username});

Code: Select all

public class LoginEventHandler extends BaseServerEventHandler
{
// Obtain the DBManager and reference the zone name specified in Main.java.
   private IDBManager _dbManager = SmartFoxServer.getInstance().getZoneManager().getZoneByName(Main.ZONE).getDBManager();

   // Bad username/password error
    private SFSErrorData _errData = new SFSErrorData(SFSErrorCode.LOGIN_BAD_USERNAME);

   @Override
   public void handleServerEvent(ISFSEvent event) throws SFSException
   {
        trace("<-LOGIN EVENT->");
        ISession session = (ISession) event.getParameter(SFSEventParam.SESSION);
        String username = (String) event.getParameter(SFSEventParam.LOGIN_NAME);
        String encryptedPass = (String) event.getParameter(SFSEventParam.LOGIN_PASSWORD);
        ISFSApi smartfox = SmartFoxServer.getInstance().getAPIManager().getSFSApi();
        ISFSArray userResult = null;

        //String userSQL = "SELECT * FROM BLABLA WHERE NAME=? LIMIT 1";

        try {
            Connection conn = _dbManager.getConnection();
            PreparedStatement sql = conn.prepareStatement("SELECT * FROM BLABLA WHERE NAME=? LIMIT 1");
            sql.setString(1, username);
            ResultSet res = sql.executeQuery();
            userResult = SFSArray.newFromResultSet(res);
            conn.close();

            //userResult = (ISFSArray) _dbManager.executeQuery(userSQL, new Object[] {username});
        } catch (SQLException sqlErr) {
            trace("SQL Exception: "+sqlErr);
            throw new SFSLoginException("Username or password incorrect.", _errData);
        }

Code: Select all

08:47:31,611 ERROR [main] db.SFSDBManager     - 
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Exception: org.h2.jdbc.JdbcSQLException
Message: This method is not allowed for a prepared statement; use a regular statement instead. [90130-148]
Description: The DBManager Test SQL failed
Please double check your SQL code and make sure that Database server is running.
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::