public void signInHost(Session session,Packets.HelloServer hello) {
		synchronized (mSignInSemaphore) {
			//Connection mConnection=null;
			CallableStatement mStatement = null;
			ResultSet mResult = null;

			try {
				try{
					
					//mConnection=getDbConnection();
					mStatement = mConnection.prepareCall("CALL SIGN_IN_HOST(?,?,?,?,?,?,?,?)");
					mStatement.setString(1, hello.name);
					mStatement.setString(2, hello.password);
					
                                        ....................................................
					....................................................

					mResult = mStatement.executeQuery();
					mConnection.commit();
					
					if (mResult.next()) {

						if (mResult.getString(1).equals("NOT_REGISTERED")) {
							session.sendData(new Packets.Error(ErrorCodes.INVALID_USERNAME_OR_PASSWORD));
							session.killSession();
						} else if (mResult.getString(1).equals("BUSY")) {
							session.killSession();
						} else if (mResult.getString(1).equals("ONLINE")) {
							session.setSessionId(mStatement.getResultSet().getInt(4));
							session.setLogId(mStatement.getResultSet().getInt(3));
							session.setHostId(mStatement.getResultSet().getInt(2));
							session.sessionType = Session.SessionType.Host;
							session.sendData(new Packets.HelloHost());
							session.setEncryptionKey(hello.password.substring(0, 15));
		
							HOSTS_SESSIONS.put(session.getHostId(), session);
						}

					} else {
						session.killSession();
					}
				}
				catch(SQLException e){
					LogHelper.logError(e, "signInHost");
					session.killSession();
					if(mConnection!=null){mConnection.rollback();}
				}
			} catch (Exception e) {
				LogHelper.logError(e, "signInHost");
				session.killSession();
			}
			finally {
				try {
					//if (mConnection!=null){mConnection.close();}
					if (mStatement != null) {mStatement.close();}
					if (mResult != null) {mResult.close();}
				} catch (SQLException e) {
					LogHelper.logError(e, "signInHost");
				}
			}
		}
    }