Re: store JDBC SQL in Properties

Erik Price schrieb:
> I have a Java class that has a kind of large SQL query.  Right now it is 
> a series of concatenated strings, occupying about twenty lines of my 
> source code file.  Performance is not a concern to me at this point, but 
> I would like to store the SQL query string in a Properties file so that 
> it does not clutter my code.  However, I can't find a reference to 
> acceptable Properties file syntax -- is it allowed to have multiline 
> property values?  Like this:
> 
> # jdbc.sql.properties
> com.erikprice.sql.select=SELECT some_value,
>                                 some_other_value,
>                                 yet_another_value
>                          FROM some_table
>                          WHERE some_condition
> 
Although this is not a JDBC question :-)

The Properties class supports the line continuation character \


com.erikprice.sql.select=SELECT some_value,        \
                                 some_other_value,  \
                                 yet_another_value  \
                          FROM some_table           \
                          WHERE some_condition      \


Thomas