It should either be in the jar or in the lib folder in the Hadoop installation.
If none of them work, check the jar that you are including. Amandeep Khurana Computer Science Graduate Student University of California, Santa Cruz On Wed, Feb 18, 2009 at 12:08 AM, sandhiya <sandhiy...@gmail.com> wrote: > > Enis ... I have tried JAR-ing with the library folder as you said. But > still > no luck. I keep getting the same ClassNotFoundException again and > again..... > :,( > > Enis Soztutar-2 wrote: > > > > There is nothing special about the jdbc driver library. I guess that you > > have added the jar from the IDE(netbeans), but did not include the > > necessary libraries(jdbc driver in this case) in the TableAccess.jar. > > > > The standard way is to include the dependent jars in the project's jar > > under the lib directory. For example: > > > > example.jar > > -> META-INF > > -> com/... > > -> lib/postgres.jar > > -> lib/abc.jar > > > > If your classpath is correct, check whether you call > > DBConfiguration.configureDB() with the correct driver class and url. > > > > sandhiya wrote: > >> Hi, > >> I'm using postgresql and the driver is not getting detected. How do you > >> run > >> it in the first place? I just typed > >> > >> bin/hadoop jar /root/sandy/netbeans/TableAccess/dist/TableAccess.jar > >> > >> at the terminal without the quotes. I didnt copy any files from my local > >> drives into the Hadoop file system. I get an error like this : > >> > >> java.lang.RuntimeException: java.lang.ClassNotFoundException: > >> org.postgresql.Driver > >> > >> and then the complete stack trace.... > >> > >> Am i doing something wrong? > >> I downloaded a jar file for postgresql jdbc support and included it in > my > >> Libraries folder (I'm using NetBeans). > >> please help.... > >> > >> Fredrik Hedberg-3 wrote: > >> > >>> Hi, > >>> > >>> Although it's not MySQL; this might be of use: > >>> > >>> > http://svn.apache.org/repos/asf/hadoop/core/trunk/src/examples/org/apache/hadoop/examples/DBCountPageView.java > >>> > >>> > >>> Fredrik > >>> > >>> On Feb 16, 2009, at 8:33 AM, sandhiya wrote: > >>> > >>> > >>>> @Amandeep > >>>> Hi, > >>>> I'm new to Hadoop and am trying to run a simple database connectivity > >>>> program on it. Could you please tell me how u went about it?? my > >>>> mail id is > >>>> "sandys_cr...@yahoo.com" . A copy of your code that successfully > >>>> connected > >>>> to MySQL will also be helpful. > >>>> Thanks, > >>>> Sandhiya > >>>> > >>>> Enis Soztutar-2 wrote: > >>>> > >>>>> From the exception : > >>>>> > >>>>> java.io.IOException: ORA-00933: SQL command not properly ended > >>>>> > >>>>> I would broadly guess that Oracle JDBC driver might be complaining > >>>>> that > >>>>> the statement does not end with ";", or something similar. you can > >>>>> 1. download the latest source code of hadoop > >>>>> 2. add a print statement printing the query (probably in > >>>>> DBInputFormat:119) > >>>>> 3. build hadoop jar > >>>>> 4. use the new hadoop jar to see the actual SQL query > >>>>> 5. run the query on Oracle if is gives an error. > >>>>> > >>>>> Enis > >>>>> > >>>>> > >>>>> Amandeep Khurana wrote: > >>>>> > >>>>>> Ok. I created the same database in a MySQL database and ran the same > >>>>>> hadoop > >>>>>> job against it. It worked. So, that means there is some Oracle > >>>>>> specific > >>>>>> issue. It cant be an issue with the JDBC drivers since I am using > >>>>>> the > >>>>>> same > >>>>>> drivers in a simple JDBC client. > >>>>>> > >>>>>> What could it be? > >>>>>> > >>>>>> Amandeep > >>>>>> > >>>>>> > >>>>>> Amandeep Khurana > >>>>>> Computer Science Graduate Student > >>>>>> University of California, Santa Cruz > >>>>>> > >>>>>> > >>>>>> On Wed, Feb 4, 2009 at 10:26 AM, Amandeep Khurana <ama...@gmail.com > > > >>>>>> wrote: > >>>>>> > >>>>>> > >>>>>> > >>>>>>> Ok. I'm not sure if I got it correct. Are you saying, I should > >>>>>>> test the > >>>>>>> statement that hadoop creates directly with the database? > >>>>>>> > >>>>>>> Amandeep > >>>>>>> > >>>>>>> > >>>>>>> Amandeep Khurana > >>>>>>> Computer Science Graduate Student > >>>>>>> University of California, Santa Cruz > >>>>>>> > >>>>>>> > >>>>>>> On Wed, Feb 4, 2009 at 7:13 AM, Enis Soztutar <enis....@gmail.com> > >>>>>>> wrote: > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>> Hadoop-2536 connects to the db via JDBC, so in theory it should > >>>>>>>> work > >>>>>>>> with > >>>>>>>> proper jdbc drivers. > >>>>>>>> It has been tested against MySQL, Hsqldb, and PostreSQL, but not > >>>>>>>> Oracle. > >>>>>>>> > >>>>>>>> To answer your earlier question, the actual SQL statements might > >>>>>>>> not be > >>>>>>>> recognized by Oracle, so I suggest the best way to test this is to > >>>>>>>> insert > >>>>>>>> print statements, and run the actual SQL statements against > >>>>>>>> Oracle to > >>>>>>>> see if > >>>>>>>> the syntax is accepted. > >>>>>>>> > >>>>>>>> We would appreciate if you publish your results. > >>>>>>>> > >>>>>>>> Enis > >>>>>>>> > >>>>>>>> > >>>>>>>> Amandeep Khurana wrote: > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>>> Does the patch HADOOP-2536 support connecting to Oracle > >>>>>>>>> databases as > >>>>>>>>> well? > >>>>>>>>> Or is it just limited to MySQL? > >>>>>>>>> > >>>>>>>>> Amandeep > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> Amandeep Khurana > >>>>>>>>> Computer Science Graduate Student > >>>>>>>>> University of California, Santa Cruz > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>> > >>>>> > >>>> -- > >>>> View this message in context: > >>>> > http://www.nabble.com/HADOOP-2536-supports-Oracle-too--tp21823199p22032715.html > >>>> Sent from the Hadoop core-user mailing list archive at Nabble.com. > >>>> > >>>> > >>> > >>> > >> > >> > > > > > > -- > View this message in context: > http://www.nabble.com/HADOOP-2536-supports-Oracle-too--tp21823199p22073986.html > Sent from the Hadoop core-user mailing list archive at Nabble.com. > >
