RE: JDBC connectivityfor ORACLE !!!
XP is different. Usually under windows the install is alot smoother than under the flavors of unix I have available. All I can really say is good luck, can't help you further. After you get it installed I might be able to offer further advice. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Swapneel Dange [mailto:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 8:03 PM To: [EMAIL PROTECTED] Subject: RE: JDBC connectivityfor ORACLE !!! 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 [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] 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 [EMAIL PROTECTED] -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] -Original Message- From: Swapneel Dange [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9: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
RE: JDBC connectivityfor ORACLE !!!
If you're installing oracle on windows, the easiest thing is to just do the default install. Once you get familiar, you can then create a new database with optimized settings for tablespaces and so on. peter Swapneel Dange [EMAIL PROTECTED] wrote: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 Reply-To: Tomcat Users List To: Tomcat Users List 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 [EMAIL PROTECTED] -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED] 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 / 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 [EMAIL PROTECTED] -Original Message- From: Swapneel Dange [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9: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 Reply-To: Tomcat Users List To: Tomcat Users List 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 Reply-To: Tomcat Users List To: Tomcat Users List 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
RE: JDBC connectivityfor ORACLE !!!
thanx MIKE and PATER. i am starting to work on it, lets see how quickly i go ahead with the installation and all that stuff. trying best to do the TIGHT-ROPE-WALK ! 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 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 [EMAIL PROTECTED] -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED] 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 [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]
RE: JDBC connectivityfor ORACLE !!!
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 [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] 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 [EMAIL PROTECTED] -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] -Original Message- From: Swapneel Dange [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9: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
Re: JDBC connectivityfor ORACLE !!!
Unfortunately Swapneel, I know nuts about oracle :) .I'm more of a SAP DB person. Connecting tomcat and oracle using jndi should be ok I guess, there is a example in the tomcat docs. Swapneel Dange wrote: 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 - 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]
RE: JDBC connectivityfor ORACLE !!!
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
RE: JDBC connectivityfor ORACLE !!!
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
Re: JDBC connectivityfor ORACLE !!!
I haven't had a chance to play with Oracle 9i, but I do have experience with 8i and classes112.zip is the drivier you want. the older 8i jdbc driver did not have pooling support and had several bugs. one bug I found with a co-worker was verified in classes111.zip driver and fixed in classes112.zip peter --- Chong Yu Meng [EMAIL PROTECTED] wrote: Oh dear ! I had 2 consultants from Oracle India helping me the last time, and it took about 2 weeks to get everything right, but that involved installing and tuning Oracle 8 and 8i, setting up automated backups, etc., along with JDBC. Cost a bomb, but they were quite good. I don't think I could have done the job without them. The way I would start would be : 1. Find out the version of Oracle - 8.1.5, like I said, has pretty flaky drivers (not sure if Oracle has released any new versions since my last disastrous encounter back in 2000), but 8.1.7 seems to be ok. DataDirect drivers are still your safest bet, I believe, and they're pretty cheap (in Singapore anyway). 2. Read up on JDBC and SQL. There are some excellent tutorials on the Internet. Try IBM Developerworks (http://www.ibm.com/developer). If your implementation is simple enough (i.e. do most of your processing outside the database, and use the database only as a repository), this should be all you need. 3. See if you can get help from a resident Oracle guru. I suppose you could post your questions here, but I'm no expert in Oracle, and I'd be unable to help you. I'm not sure about the level of Oracle support on the newsgroups or websites. For IBM's DB2, the support is the best I have ever experienced, with the original developers sometimes pitching in to help in the newsgroups. Hope this helps ! Regards, pascal chong Swapneel Dange wrote: 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 - 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]
Re: JDBC connectivityfor ORACLE !!!
Actually, I believe it's classes12.zip (and needs to be renamed classes12.jar). Keep in mind Oracle recommends using ojdbc14.jar with JDK 1.4. I've used it, and it works fine. At 2/27/2003 05:15 AM, you wrote: I haven't had a chance to play with Oracle 9i, but I do have experience with 8i and classes112.zip is the drivier you want. the older 8i jdbc driver did not have pooling support and had several bugs. one bug I found with a co-worker was verified in classes111.zip driver and fixed in classes112.zip peter --- Chong Yu Meng [EMAIL PROTECTED] wrote: Oh dear ! I had 2 consultants from Oracle India helping me the last time, and it took about 2 weeks to get everything right, but that involved installing and tuning Oracle 8 and 8i, setting up automated backups, etc., along with JDBC. Cost a bomb, but they were quite good. I don't think I could have done the job without them. The way I would start would be : 1. Find out the version of Oracle - 8.1.5, like I said, has pretty flaky drivers (not sure if Oracle has released any new versions since my last disastrous encounter back in 2000), but 8.1.7 seems to be ok. DataDirect drivers are still your safest bet, I believe, and they're pretty cheap (in Singapore anyway). 2. Read up on JDBC and SQL. There are some excellent tutorials on the Internet. Try IBM Developerworks (http://www.ibm.com/developer). If your implementation is simple enough (i.e. do most of your processing outside the database, and use the database only as a repository), this should be all you need. 3. See if you can get help from a resident Oracle guru. I suppose you could post your questions here, but I'm no expert in Oracle, and I'd be unable to help you. I'm not sure about the level of Oracle support on the newsgroups or websites. For IBM's DB2, the support is the best I have ever experienced, with the original developers sometimes pitching in to help in the newsgroups. Hope this helps ! Regards, pascal chong Swapneel Dange wrote: 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 - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JDBC connectivityfor ORACLE !!!
thanks for the correction :) I haven't updated my driver, since I'm still using 8i myself for my dev toys. All else fails, go to Oracle's site and check for the latest driver. Oracle also provides sample jdbc code if you are new to oracle. You can download all of it through oracle (OTN) section. sorry for the out of date info. peter --- Mark [EMAIL PROTECTED] wrote: Actually, I believe it's classes12.zip (and needs to be renamed classes12.jar). Keep in mind Oracle recommends using ojdbc14.jar with JDK 1.4. I've used it, and it works fine. __ 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]
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 [EMAIL PROTECTED] -Original Message- From: Swapneel Dange [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9: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
RE: JDBC connectivityfor ORACLE !!!
Also, http://www.orafaq.com is extremely helpful for answering questions. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] -Original Message- From: Swapneel Dange [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9: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
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
Re: JDBC connectivityfor ORACLE !!!
Oh dear ! I had 2 consultants from Oracle India helping me the last time, and it took about 2 weeks to get everything right, but that involved installing and tuning Oracle 8 and 8i, setting up automated backups, etc., along with JDBC. Cost a bomb, but they were quite good. I don't think I could have done the job without them. The way I would start would be : 1. Find out the version of Oracle - 8.1.5, like I said, has pretty flaky drivers (not sure if Oracle has released any new versions since my last disastrous encounter back in 2000), but 8.1.7 seems to be ok. DataDirect drivers are still your safest bet, I believe, and they're pretty cheap (in Singapore anyway). 2. Read up on JDBC and SQL. There are some excellent tutorials on the Internet. Try IBM Developerworks (http://www.ibm.com/developer). If your implementation is simple enough (i.e. do most of your processing outside the database, and use the database only as a repository), this should be all you need. 3. See if you can get help from a resident Oracle guru. I suppose you could post your questions here, but I'm no expert in Oracle, and I'd be unable to help you. I'm not sure about the level of Oracle support on the newsgroups or websites. For IBM's DB2, the support is the best I have ever experienced, with the original developers sometimes pitching in to help in the newsgroups. Hope this helps ! Regards, pascal chong Swapneel Dange wrote: 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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
jdbc with oracle
hi guys... i have installed Oracle 9i on my Pc having window 2000 professional edition i used to login like.. hr/tiger... i don't put the tsn name.. 1)-can anyone tell me..why..why it works without the tsn name 2) also i'm not able to make a simple..connection to the database.. can anyone tell me the code...or send me the code... i'm ...waiting... thanx ... __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
JDBC and Oracle
I have a question about JDBC and Oracle. In my Jsp I make a connection pool bean to connect with Oracle. And I found when I access the Oracle it will build a new session every time. So at last I can=A1=AFt connect = with Oracle when it reaches the max session number. But if I don=A1=AFt use = the bean to connect with Oracle (direct write connection pool in the jsp page), I found there is no new session built. Help me!!!
JDBC and Oracle
I have a question about JDBC and Oracle. In my Jsp I make a connection pool bean to connect with Oracle. And I found when I access the Oracle it will build a new session every time. So at last I can't connect with Oracle when it reaches the max session number. Just when I restart Tomcat the sessin disappear. But if I don't use the bean to connect with Oracle (direct write connection pool in the jsp page), I found there is no new session built. Help me!!!
Re: JDBC and Oracle
On Mon, 20 Aug 2001 19:52:14 +0800 [EMAIL PROTECTED] wrote: I have a question about JDBC and Oracle. In my Jsp I make a connection pool bean to connect with Oracle. And I found when I access the Oracle it will build a new session every time. So at last I can't connect with Oracle when it reaches the max session number. Just when I restart Tomcat the sessin disappear. But if I don't use the bean to connect with Oracle (direct write connection pool in the jsp page), I found there is no new session built. Help me!!! This doesn't sound like a Tomcat problem. Your bean is probably set to request scope, in which case each time a new request comes in, it will make a new connection/session w/Oracle. There are about a million ways to have a connection pool shared by all JSPs... - r