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 Thu, 27 Feb 2003 09:38:21 GMT
hi ~
thanx for the files u sent me . hope that i should be able to use then 
successfully, but i am curious to know if i will use another version of 
ORACLE such as the Oracle Personal Edition then will this driver still be 
applicable.

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





>From: "Galbayar Dorjgotov" <galbayar@mobinet.mn>
>To: <s_dange@hotmail.com>
>Subject: RE: JDBC connectivityfor ORACLE !!!
>Date: Thu, 27 Feb 2003 16:36:14 +0800
>
>Attached oracle8i JDBC driver.
>copy oracle.jar tomcat\common\lib dir or WEB-INF\lib dir
>
>Simple JSP
><%
>		try
>		{
>			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
>     			java.sql.Connection conn = DriverManager.getConnection
>("jdbc:oracle:thin:@host:SID","username","password");
>			String Query="select * from blabla";
>			java.sql.PreparedStatement st=conn.prepareStatement(Query);
>			java.sql.ResultSet rs=st.executeQuery();
>			while (rs.next()) out.println(rs.getString(1)+"<br>");
>			rs.close();
>			st.close();
>			conn.close();
>		}
>		catch(Exception e)
>		{
>			out.println(e.getMessage());
>			//e.printStackTrace();
>		}
>%>
>
>
>
>-----Original Message-----
>From: Swapneel Dange [mailto:s_dange@hotmail.com]
>Sent: Thursday, February 27, 2003 1: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
>
><< ConnectToOracle.java >>
><< oracle.jar >>


_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail


---------------------------------------------------------------------
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