Re: JDBC ORACLE implementation !

2003-02-25 Thread Peter Lin
keep in mind it's a matter of scale. If the application will take several years to grow beyond the current requirements, then you're fine. If the requirements are going to grow rapidly, then you may still want to use Oracle for your mined data. If you're dealing with only a couple thousand

RE: JDBC ORACLE implementation !

2003-02-25 Thread Mike Jackson
:07 PM To: Tomcat Users List Subject: Re: JDBC ORACLE implementation ! 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

RE: JDBC ORACLE implementation !

2003-02-25 Thread Mike Jackson
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

RE: JDBC ORACLE implementation !

2003-02-24 Thread Swapneel Dange
commment on this ! 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: Thu, 20 Feb 2003 09:14:52 -0800 clip

RE: JDBC ORACLE implementation !

2003-02-24 Thread Peter Lin
-To: Tomcat Users List To: Tomcat Users List Subject: RE: JDBC ORACLE implementation ! Date: Thu, 20 Feb 2003 09:14:52 -0800 senior DBA's help. when ever I need to tune oracle, I ask my Oracle DBA friends who have 8 yrs of exp for help. peter Me too, oracle can be a pain. If you stay small

Re: JDBC ORACLE implementation !

2003-02-24 Thread Chong Yu Meng
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

Re: JDBC ORACLE implementation !

2003-02-24 Thread Swapneel Dange
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

Re: JDBC ORACLE implementation !

2003-02-24 Thread Peng Tuck Kwok
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

Re: JDBC ORACLE implementation !

2003-02-24 Thread Swapneel Dange
to the FILESYSTEM! comments awaited ! Swapneel Dange 505-642-4126 http://www.cs.nmsu.edu/~sdange From: Peng Tuck Kwok [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 15

Re: JDBC ORACLE implementation !

2003-02-23 Thread Swapneel Dange
[EMAIL PROTECTED] Subject: Re: JDBC ORACLE implementation ! Date: Thu, 20 Feb 2003 17:11:35 +0800 Hi Swapneel ! I need you to clarify something : are you processing the files first, then putting them into the database, or are you putting all the raw data inside the database and doing SQL operations

Re: JDBC ORACLE implementation !

2003-02-20 Thread Chong Yu Meng
Hi Swapneel ! I need you to clarify something : are you processing the files first, then putting them into the database, or are you putting all the raw data inside the database and doing SQL operations to extract the data you want ? I am assuming that you want to do the second option, am I

Re: JDBC ORACLE implementation !

2003-02-20 Thread Peter Lin
/~sdange From: Peter Lin Reply-To: Tomcat Users List To: Tomcat Users List Subject: Re: JDBC ORACLE implementation ! Date: Wed, 19 Feb 2003 18:09:36 -0800 (PST) First off, you probably should be use Oracle enterprise edition, unless you're on a box with less than 128meg of memory. Oracle

Re: JDBC ORACLE implementation !

2003-02-20 Thread Erik Price
Chong Yu Meng wrote: As a rough indicator (and I invite others to correct me), it takes : - 1 month to understand Oracle - 2 weeks to get JDBC working the way you want Is this indicator specific to Oracle? I set up the MySQL JDBC driver and had working queries in a matter of hours. (I am

Re: JDBC ORACLE implementation !

2003-02-20 Thread Peter Lin
Database are a lot of fun (well to me they are), but they do a lot more than just queries. Learning every aspect of Oracle is fairly complex and takes years of experience. there's a reason why Oracle DBA's make big bucks. Most people will never use the high end features of Oracle. Things like

RE: JDBC ORACLE implementation !

2003-02-20 Thread Mike Jackson
1. If you are committing 1MB of data into the database per operation, that would take a looong time, and I'm not sure if that is the most efficient, or even the easiest way to do what you are trying to do. Why I say that is, Oracle is fine when you break up the data and commit, perhaps line

RE: JDBC ORACLE implementation !

2003-02-20 Thread Mike Jackson
]] Sent: Thursday, February 20, 2003 8:01 AM To: Tomcat Users List Subject: Re: JDBC ORACLE implementation ! Chong Yu Meng wrote: As a rough indicator (and I invite others to correct me), it takes : - 1 month to understand Oracle - 2 weeks to get JDBC working the way you want

RE: JDBC ORACLE implementation !

2003-02-20 Thread Mike Jackson
clip senior DBA's help. when ever I need to tune oracle, I ask my Oracle DBA friends who have 8 yrs of exp for help. peter Me too, oracle can be a pain. If you stay small however all the tuning defaults should work for you. --mikej -=- mike jackson [EMAIL PROTECTED]

JDBC ORACLE implementation !

2003-02-19 Thread Swapneel Dange
hi there ~ i am curious to know as to how can u implement ORACLE database in the TOMCAT. and can somebody tell me as to where i can read the DOCUMENTATION for the implementation of the JDBC connectivity under TOMCAT. Swapneel Dange 505-642-4126 http://www.cs.nmsu.edu/~sdange

Re: JDBC ORACLE implementation !

2003-02-19 Thread Andoni
9:47 AM Subject: JDBC ORACLE implementation ! hi there ~ i am curious to know as to how can u implement ORACLE database in the TOMCAT. and can somebody tell me as to where i can read the DOCUMENTATION for the implementation of the JDBC connectivity under TOMCAT. Swapneel Dange 505-642

Re: JDBC ORACLE implementation !

2003-02-19 Thread Chong Yu Meng
Hi Swapneel ! If you absolutely MUST use Oracle with Tomcat, use the DataDirect JDBC drivers, not the JDBC drivers bundled with Oracle. I am assuming (since you did not mention the version number of Oracle) that you are pretty new to the Oracle database product. You should then go for the

Re: JDBC ORACLE implementation !

2003-02-19 Thread Swapneel Dange
://www.cs.nmsu.edu/~sdange From: Andoni [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: Re: JDBC ORACLE implementation ! Date: Wed, 19 Feb 2003 10:09:16 - The implementation is based on which driver you use, which mostly depends

RE: JDBC ORACLE implementation !

2003-02-19 Thread Mike Jackson
:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 4:11 PM To: [EMAIL PROTECTED] Subject: Re: JDBC ORACLE implementation ! hi ! frankly speaking, i am very new to the database concepts. i am trying to use the Oracle Database Personal Edition for my use here. But i can tell about

RE: JDBC ORACLE implementation !

2003-02-19 Thread Swapneel Dange
. awaiting reply ! 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: Wed, 19 Feb 2003 16:24:25 -0800 So, you

RE: JDBC ORACLE implementation !

2003-02-19 Thread Mike Jackson
Message- From: Swapneel Dange [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 4:49 PM To: [EMAIL PROTECTED] Subject: RE: JDBC ORACLE implementation ! hi mike ! the files i am using are quite small in size like 200-300 KB but sometimes i get files of the size 1MB or so

Re: JDBC ORACLE implementation !

2003-02-19 Thread Peter Lin
: Re: JDBC ORACLE implementation ! Date: Wed, 19 Feb 2003 10:09:16 - The implementation is based on which driver you use, which mostly depends on which version of Oracle you are running. What version numbers are you using for Oracle Tomcat - Original Message - From: Swapneel Dange

Re: JDBC ORACLE implementation !

2003-02-19 Thread Chong Yu Meng
Hi Swapneel ! I have to agree with Peter on this. Try to keep your application as simple as possible. Don't use a database (especially NOT Oracle, if you are new to databases) if you can help it, because things can get very, very complicated very quickly. I think your main problem will not be

Re: JDBC ORACLE implementation !

2003-02-19 Thread Swapneel Dange
: JDBC ORACLE implementation ! Date: Wed, 19 Feb 2003 18:09:36 -0800 (PST) First off, you probably should be use Oracle enterprise edition, unless you're on a box with less than 128meg of memory. Oracle personal edition for 8i and 9i is really designed for simple uses. The scenario you've