I imagine the problem is with assigning names to them.

Usually I've seen people keeping them in hibernate xml with named queries, or some proprietrary .xml files.

CDATA is overkill IMHO, easier to escape the few problematic characters.

Nice becuase you can get SQL syntax highlighting.

This.

Remember, SQL statements are source code.