How to add SQL on multiple lines in - SQL.properties file

Question

JEE Project - Separating SQL from code: I have SQL in my sql.properties file like this .. on 4 lines.

emp_sql=select * \  
from employees \  
  where \   
name = 'JON' 

The loader sees only first line - rest of the lines are being ignored. what am I doing wrong. thanks.

Answer 1

Check to make sure there are no blanks after the \ backslashes at the end of each line. A blank in the position cancels the effect of the backslash.