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