As long as you are using the version of that release, ie 8 or 9, it should work. there's no difference in the jdbc driver for 8i Ent vs personal.
peter --- Swapneel Dange <[EMAIL PROTECTED]> wrote: > 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] > __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]