есть страничка в которой нужно ввести номер авто а в ответ должен с базы вытащить данные у меня выдает такое сообщение может что то пропустил ?

в логе

SEVERE: Servlet.service() for servlet jsp threw exception
org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 69 in the jsp file: /electricity/electricity.jsp
VEHICLE_ID cannot be resolved
66: Logger.info(Logger.COMMON, "[electricity.jsp] payment session state switched to PROCESSING: " + paymentSession.getSessionId());
67: statement = connection.createStatement();
68:
69: resultSet = statement.executeQuery("SELECT vehicle_id, TIME, VIOLATION_LOCATION, VIOLATION, PROCESS_STATUS from [dbo].[GAIAccount] where VEHICLE_ID = "+ VEHICLE_ID +"");
70:
71: if (resultSet.next()) {
72: Logger.info(Logger.COMMON, "[electricity.jsp] account information found, parsing");


в коде

String account = paymentRequest.getRequestProperty("VEHICLE_ID");

Logger.info(Logger.COMMON, "[electricity.jsp] check started");
connection = DriverManager.getConnection("jdbc:sqlserver://" + msSqlServer + ";databaseName=" + msSqlDatabase + ";user=" + msSqlUser + ";password=" + msSqlPassword);
Logger.info(Logger.COMMON, "[electricity.jsp] input connection created");
paymentSession = PaymentSessionFactory.getInstance().newSession(paymentRequest.getSessionId());
Logger.info(Logger.COMMON, "[electricity.jsp] payment session created: " + paymentSession.getSessionId());
PaymentSessionFactory.setSessionState(paymentSession, PaymentSession.STATE_PROCESSING);
Logger.info(Logger.COMMON, "[electricity.jsp] payment session state switched to PROCESSING: " + paymentSession.getSessionId());
statement = connection.createStatement();

resultSet = statement.executeQuery("SELECT vehicle_id, TIME, VIOLATION_LOCATION, VIOLATION, PROCESS_STATUS from [dbo].[GAIAccount] where VEHICLE_ID = "+ VEHICLE_ID +"");

if (resultSet.next()) {
Logger.info(Logger.COMMON, "[electricity.jsp] account information found, parsing");
paymentRequest.setResponseProperty("VEHICLE_ID", resultSet.getString("VEHICLE_ID"));
paymentRequest.setResponseProperty("TIME", resultSet.getString("TIME"));
paymentRequest.setResponseProperty("VIOLATION_LOCATION", resultSet.getString("VIOLATION_LOCATION"));
paymentRequest.setResponseProperty("VIOLATION", resultSet.getString("VIOLATION"));
paymentRequest.setResponseProperty("PROCESS_STATUS", resultSet.getString("PROCESS_STATUS"));

}
else {
Logger.info(Logger.COMMON, "[electricity.jsp] no results in database for this account, exiting");
paymentRequest.setErrorCode(17);
PaymentSessionFactory.setSessionState(paymentSession, PaymentSession.STATE_ERROR);
Logger.info(Logger.COMMON, "[electricity.jsp] payment session state switched to ERROR: " + paymentSession.getSessionId());
}

rema174,

код чучуть подправил теперь возвращает только не понятно что

if (resultSet.next()) {
Logger.info(Logger.COMMON, "[electricity.jsp] account information found, parsing");
paymentRequest.setResponseProperty("VEHICLE_ID", resultSet.getString("VEHICLE_ID"));
paymentRequest.setResponseProperty("TIME", resultSet.getString("TIME"));
paymentRequest.setResponseProperty("VIOLATION_LOCATION", resultSet.getString("VIOLATION_LOCATION"));
paymentRequest.setResponseProperty("VIOLATION", resultSet.getString("VIOLATION"));
paymentRequest.setResponseProperty("PROCESS_STATUS", resultSet.getString("PROCESS_STATUS"));

}
else {
Logger.info(Logger.COMMON, "[electricity.jsp] no results in database for this account, exiting");
paymentRequest.setErrorCode(17);
PaymentSessionFactory.setSessionState(paymentSession, PaymentSession.STATE_ERROR);
Logger.info(Logger.COMMON, "[electricity.jsp] payment session state switched to ERROR: " + paymentSession.getSessionId());
}

из конструкции отрабатывается else

rema174,

работает если селектить SELECT vehicle_id, TIME, VIOLATION_LOCATION, VIOLATION, PROCESS_STATUS from [dbo].[GAIAccount] where vehicle_id='5848b01'; а не переменная :(

rema174,
спасибо брат решил :)