I am building a JSP app running on Tomcat.
The app uses an Oracle backend for data management and things like passwords and so on.
There are several objects created by the app called cards. Each card will make use of different but similar groups of data, attributes of tables.
There will also be the capability of creating a new card with a new group of data.
I am assuming that this group of data will be accessed via an sql string but nothing is written in stone at this point except the technologies of jsp and Oracle.
Some of these sql strings will be VERY long.
Does anyone have any idea where I can store and manage these strings? Text files? Stored Procedures? CallableStatements?