tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Swapneel Dange" <s_da...@hotmail.com>
Subject RE: JDBC connectivityfor ORACLE !!!
Date Sun, 02 Mar 2003 04:03:10 GMT
hey MIKE !

may be this is a DUMB QUESTION but all this procedure for installation 
remains tha same irrespective of the fact that i am trying to implement 
ORACLE under XP. right ?

Swapneel Dange
505-642-4126
http://www.cs.nmsu.edu/~sdange







>From: "Mike Jackson" <mjackson@cdi-hq.com>
>Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>Subject: RE: JDBC connectivityfor ORACLE !!!
>Date: Thu, 27 Feb 2003 08:56:19 -0800
>
>Also, http://www.orafaq.com is extremely helpful for answering questions.
>
>--mikej
>-=-----
>mike jackson
>mjackson@cdi-hq.com
>
> > -----Original Message-----
> > From: Mike Jackson [mailto:mjackson@cdi-hq.com]
> > Sent: Thursday, February 27, 2003 8:53 AM
> > To: Tomcat Users List
> > Subject: RE: JDBC connectivityfor ORACLE !!!
> >
> >
> > To Install Oracle:
> >
> > 	Create three groups, "sysdba", "sysoper", "oinstall"
> >
> > 	Create an oracle user, default group "oinstall", member of
> > "sysdba" and
> > "sysoper"
> >
> > 	Setup environment variables for "ORACLE_HOME", and "ORACLE_SID"
> >
> > 	Change the PATH to include $ORACLE_HOME/bin
> >
> > 	Get the CDROMS
> >
> > 	Mount the CDROMS
> >
> > 	cd /<where the cdrom is mounted>
> >
> > 	As the oracle user ./runInstaller.sh
> >
> > 	For the most part follow the instructions, but do not, and
> > I repeat do not
> > let it to the "copy the inital database", in fact when you get the 
>option
> > have it install the software only.
> >
> > 	After oracle is installed run "dbca"
> >
> > 	Create the initial database, take the option that creates a database
> > without using a template
> >
> > As for JDBC drivers, I've never had a problem with the oracle drivers,
> > except in their JDBC2.0 connection pooling, so as long as you use 
>another
> > connection pool I'd use the standard ones.
> >
> > --mikej
> > -=-----
> > mike jackson
> > mjackson@cdi-hq.com
> >
> > > -----Original Message-----
> > > From: Swapneel Dange [mailto:s_dange@hotmail.com]
> > > Sent: Wednesday, February 26, 2003 9:50 PM
> > > To: tomcat-user@jakarta.apache.org
> > > Subject: JDBC connectivityfor ORACLE !!!
> > >
> > >
> > > hi MIKE, PENG , CHONG !!
> > >
> > > guys, there seems to be a problem here for me with the database
> > > implementation. After all the discussion i was all set to
> > implemenent the
> > > database as a FILESYSTEM only but my BOSS insists that ORACLE shoudl 
>be
> > > implemented. Can somebody of u enlighten me with the SITES and
> > > README files
> > > about impplementing ORACLE under TOMCAT umbrella and what could be the
> > > DRIVERS i need to know before i plunge into the deep sea of ORACLE
> > > implementation. some of the drivers suggested are the ones made
> > > by DATATAKE,
> > > JBOSS (i guess, i may be wrong)or the default drivers which come
> > > up with the
> > > ORACLE.
> > >
> > > Comments are really awaited !
> > >
> > > Swapneel Dange
> > > 505-642-4126
> > > http://www.cs.nmsu.edu/~sdange
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > >From: "Mike Jackson" <mjackson@cdi-hq.com>
> > > >Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> > > >To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> > > >Subject: RE: JDBC & ORACLE implementation !
> > > >Date: Tue, 25 Feb 2003 09:20:31 -0800
> > > >
> > > >SQLPlus is part of oracle.  You can't do sqlplus without oracle.
> > > >
> > > >--mikej
> > > >-=-----
> > > >mike jackson
> > > >mjackson@cdi-hq.com
> > > >
> > > > > -----Original Message-----
> > > > > From: Swapneel Dange [mailto:s_dange@hotmail.com]
> > > > > Sent: Monday, February 24, 2003 11:20 PM
> > > > > To: tomcat-user@jakarta.apache.org
> > > > > Subject: Re: JDBC & ORACLE implementation !
> > > > >
> > > > >
> > > > > hey CHONG , PENG !
> > > > >
> > > > > i think i have really given up the idea of putting up ORACKLE for

>my
> > > > > support. after all this discussion, i just think that there i
> > > sno urgent
> > > > > need for me to take up a HUMONGOUS taks of using ORACLE and i
> > > > > guess i will
> > > > > IMPLEMENT the SQLPLUS or the FILESYSTEM as my alternatives to the
> > > > > DATABASE
> > > > > application.
> > > > >
> > > > > but in the end i would really like to know as to between SQLPLUS

>or
> > > > > FILESYSTEM, which will be convinient for me to HANDLE string
> > > stripping ,
> > > > > string comparison and all that stuff ! ( BTW, i have really 
>started
> > > > > implementing the FILESYSTEM to a good level )
> > > > >
> > > > > do commment about this !
> > > > >
> > > > > Swapneel Dange
> > > > > 505-642-4126
> > > > > http://www.cs.nmsu.edu/~sdange
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >From: Chong Yu Meng <chongym@cymulacrum.net>
> > > > > >Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> > > > > >To: Tomcat Users List <tomcat-user@jakarta.apache.org>
> > > > > >Subject: Re: JDBC & ORACLE implementation !
> > > > > >Date: Tue, 25 Feb 2003 07:06:31 +0800
> > > > > >
> > > > > >I think if you take Oracle installation, configuration and
> > > > > maintenance out
> > > > > >of the picture, you definitely have a much more workable plan.
I
> > > > > agree with
> > > > > >Peter, in that designing the tables and application logic are
> > > > > going to be
> > > > > >tough. I once wrote a servlet that processed CDR data from a
> > > > > Cisco switch,
> > > > > >and I spent a lot of time getting the logic just right. If I
> > > > > understand you
> > > > > >correctly, Swapneel, you need the database for storage only,
> > > > > correct ? Are
> > > > > >you planning to use the Oracle text indexer, or are you
> > > > > implementing that
> > > > > >yourself?
> > > > > >
> > > > > >One last thing : JDBC may take you a shorter time to learn than
> > > > > the 2 weeks
> > > > > >I put down in an earlier email. On reflection, that is probably
> > > > > padding too
> > > > > >much, but I recommend that you do not underestimate the time
> > > > > taken to get
> > > > > >the JDBC connection going, especially for Oracle. I've had 
>problems
> > > >with
> > > > > >8.1.5 before and had to resort to DataDirect drivers. 8.1.7
> > > > > seems to be ok,
> > > > > >though.
> > > > > >
> > > > > >Regards,
> > > > > >chong
> > > > > >
> > > > > >
> > > > > >Peter Lin wrote:
> > > > > >
> > > > > >>
> > > > > >>overall, using JDBC with Tomcat is the easy part. Deciding
how 
>to
> > > > > >>implement your tables and application logic will be the hard
> > > > > part. If your
> > > > > >>data is not normalized and doesn't need to be, then the
> > first thing
> > > >you
> > > > > >>should look into is statistical analysis of text. there are
> > > > > several well
> > > > > >>tested algo's for doing this type of processing.
> > > Unfortunately I don't
> > > > > >>know the name of the algo's. I worked on integrating
> > personalization
> > > > > >>applications a couple years back relating to filtering news.
> > > > > >>
> > > > > >>If your needs aren't too complex, it shouldn't take too long
to
> > > > > implement
> > > > > >>some form of statistical analysis. Using file system to store
> > > > > the entire
> > > > > >>text doesn't necessarily mean you can't store the text
> > summaries in
> > > > > >>Oracle. Google for related topics and you should be to find
> > > > > some examples.
> > > > > >>If you're needs are more complex, you'll need to look into
> > > > > grammar based
> > > > > >>parsing, which is a slow process. Most of the comparison
> > > > > between grammar
> > > > > >>based and statistical parsing has shown that statistical
is more
> > > > > >>effective. hope that helps.
> > > > > >>
> > > > > >>peter
> > > > > >>
> > > > > >>Swapneel Dange <s_dange@hotmail.com> wrote:hey peter,
> > mike & chong !
> > > > > >>
> > > > > >>so if i stay with a small thing like SQLPLUS, the JDBC
> > > > > connectivity wont
> > > > > >>be a tough thing to do as compared to the ORACLE
> > > > > implementation. right ?
> > > > > >>because in last few days after consulting with some people
> > > > > in-house here,
> > > > > >>i am thinking over the OPTION of SQLPLUS.
> > > > > >>
> > > > > >>do commment on this !
> > > > > >>
> > > > > >>Swapneel Dange
> > > > > >>505-642-4126
> > > > > >>http://www.cs.nmsu.edu/~sdange
> > > > > >>
> > > > > >>
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > >---------------------------------------------------------------------
> > > > > >To unsubscribe, e-mail: 
>tomcat-user-unsubscribe@jakarta.apache.org
> > > > > >For additional commands, e-mail:
> > tomcat-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > > _________________________________________________________________
> > > > > Add photos to your e-mail with MSN 8. Get 2 months FREE*.
> > > > > http://join.msn.com/?page=features/featuredemail
> > > > >
> > > > >
> > > > >
> > ---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > > > > For additional commands, e-mail: 
>tomcat-user-help@jakarta.apache.org
> > > > >
> > > >
> > > >
> > > >
> > > >---------------------------------------------------------------------
> > > >To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > > >For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> > >
> > >
> > > _________________________________________________________________
> > > Protect your PC - get McAfee.com VirusScan Online
> > > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> > >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>


_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message