morleycallaghan
asked on
JSP and Oracle
I have a jsp application running on Tomcat with an Oracle backend.
The app creates many items called Cards that each display a unique collection of data culled from various different attributes of different tables in the Oracle database via a simple select sql string.
Some of these strings will be VERY long.
There is also the option of creating a new card with a new string that must be created and stored with the others. Each string will be identified by it's relevant card.
Does anyone have any idea where or how I should store and manage these strings?
Text files?
Stored procedures?
CallableStatements?
HELP!
The app creates many items called Cards that each display a unique collection of data culled from various different attributes of different tables in the Oracle database via a simple select sql string.
Some of these strings will be VERY long.
There is also the option of creating a new card with a new string that must be created and stored with the others. Each string will be identified by it's relevant card.
Does anyone have any idea where or how I should store and manage these strings?
Text files?
Stored procedures?
CallableStatements?
HELP!
ASKER
I think that the strings would be too long to store in a database: I know they are too long for Access. But I could store the address or path of the text file. I wonder, though, if anyone has had success using some other method?
I've previously used a system that pulled the SQL string from a text file. It allowed me to change the SQL string without having to change the programming.
In Oracle a varchar(2) column can hold up to 4,000 characters. For larger strings you can use LONG or CLOB which will easily hold up to 2 gigabytes.
In Oracle a varchar(2) column can hold up to 4,000 characters. For larger strings you can use LONG or CLOB which will easily hold up to 2 gigabytes.
ASKER
Ahh I wasn't sure how big a varchar2 could be. I am doing the prelminary work with Access and Access sure can't manage it.
That makes more sense that trying to play with things like stored procedures which give me the heebie jeebies.
That makes more sense that trying to play with things like stored procedures which give me the heebie jeebies.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you store them in a table and design the application around it you can make the number of your cards dynamic, based on the strings stored in the table. Just add a new string to the DB table to add a new card. From the description the table would only have to be two columns, a card ID and the string.