First off, you probably should be use Oracle enterprise edition, unless you're on a box with less than 128meg of memory. Oracle personal edition for 8i and 9i is really designed for simple uses. The scenario you've described will probably mean storing the text as a clob or in multiple columns. keep in mind if you store it as a clob, it limits your ability to search performance. breaking the text into columns will allow you to index the content easier. If query time is important, you may want to generate summaries of the text and use that for your indexes instead. as far as connecting to oracle, it's fairly straight forward. databases are handy, but take care with how you implement the application. If you don't need to index the content, or do not need transaction capabilities, you're better off using file system to store the text. RDBMS are designed specifically to handle relational data. If your data isn't relational, using Oracle is a bit over kill. Using the right tool will make your life easier in the long run. peter Swapneel Dange <[EMAIL PROTECTED]> wrote:hi !
frankly speaking, i am very new to the database concepts. i am trying to use the "Oracle Database Personal Edition" for my use here. But i can tell about the version of the TOMCAT, i am using , its 3.3.1a. if u could tell me in detail as to what ORACLE product i should use will be great. By the way i am using this database for the users to send data from 3 different states on the webserver i am running here. so that when that data which are huge files coem over here, i can massage them and get the particular details i want for my use. thanx ! Swapneel Dange 505-642-4126 http://www.cs.nmsu.edu/~sdange >From: "Andoni" >Reply-To: "Tomcat Users List" >To: "Tomcat Users List" >Subject: Re: JDBC & ORACLE implementation ! >Date: Wed, 19 Feb 2003 10:09:16 -0000 > >The implementation is based on which driver you use, which mostly depends >on >which version of Oracle you are running. > >What version numbers are you using for Oracle & Tomcat > >----- Original Message ----- >From: "Swapneel Dange" >To: >Sent: Wednesday, February 19, 2003 9:47 AM >Subject: JDBC & ORACLE implementation ! > > > > hi there ~ > > > > i am curious to know as to how can u implement ORACLE database in the > > TOMCAT. and can somebody tell me as to where i can read the >DOCUMENTATION > > for the implementation of the JDBC connectivity under TOMCAT. > > > > Swapneel Dange > > 505-642-4126 > > http://www.cs.nmsu.edu/~sdange > > > > > > > > > > _________________________________________________________________ > > MSN 8 with e-mail virus protection service: 2 months FREE* > > http://join.msn.com/?page=features/virus > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------- Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day
