JSP and Oracle

[Bebacha]

I have an application that will contain several items called cards.
Each card will access some attributes of some tables in the Oracle database via a select sql string and display those attributes in a jsp page.
Each card will be different about what data it accesses. There will be an option of adding new cards with new sql strings.
Some of these strings could be very long.
Does anyone have any idea where or how I can store and manage these strings?
Thanks

 

[xplorer99]

When you refer to "Strings" are you referring to the SQL statements themselves or to the atctual content of the cards?

If you are talking about the SQL statements, you have serveral option that range from resource files to XML files. I usually use XML because it gives me more flexibility and you can modify them any time.

If its the actual data for the cards, use varchar2 unless the string are really huge.