Where do you put your SQL Queries?

Question

We are using a mix of EJB 2.1 and JDBC to access our Database.

I just had a co-worker mention the idea to put his SQL Queries into a .properties file.

How and Where do you put your SQL Queries?

EDIT:

Do you inline it with the code, put into the class instantiation?

Answer 1

In DAOs since I consider them part of my application and not a configurable (changeable by a sysadmin) element of the application.

Answer 2

I use Ibatis so all the queries reside in Ibatis XML files. If not Ibatis then in DAO java code.

Answer 3

I usually add queries as static strings in the DAO implementation that uses them.

Answer 4

Where I work now we use properties files to store our SQL queries. I quite like it since I've always thought it looks rather messy when in the code. I dont really see it as configurable by a sys admin since they will all be bundled with the jar and hence invisible.

Answer 5

We store our SQL queries as string literals in DAOs. The DAOs hide the potentially ugly SQL syntax from the rest of the application. When you do dig down into the DAO code, having the SQL queries in the context in which they will be used helps make code easier to understand.