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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 1:50 PM
To: [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
>Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]>
>To: "Tomcat Users List" <[EMAIL PROTECTED]>
>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
>[EMAIL PROTECTED]
>
> > -----Original Message-----
> > From: Swapneel Dange [mailto:[EMAIL PROTECTED]
> > Sent: Monday, February 24, 2003 11:20 PM
> > To: [EMAIL PROTECTED]
> > 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 <[EMAIL PROTECTED]>
> > >Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]>
> > >To: Tomcat Users List <[EMAIL PROTECTED]>
> > >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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> > _________________________________________________________________
> > Add photos to your e-mail with MSN 8. Get 2 months FREE*.
> > http://join.msn.com/?page=features/featuredemail
> >
> >
> > ---------------------------------------------------------------------
> > 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]

<< 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to