insert into esme_hourly_master values(?,?,?,?,?,?,?,?,?,now(),'MIS'"

Side comment: Please specify column names (in parens, after the table name.) This will self-document the statement, future-proof against additional (not null) columns, and protect against column order changes.