Thanks a million!!! It worked. but its a little weird though. I have to put the Library with the jdbc jars in BOTH the executable jar file AND the lib folder in $HADOOP_HOME. Do all of you do the same thing or is it just my computer acting strange??
Anyway, thanks for the help. :clap: Amandeep Khurana wrote: > > 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 <[email protected]> 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 >> >>>> "[email protected]" . 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 >> <[email protected] >> > >> >>>>>> 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 >> <[email protected]> >> >>>>>>> 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. >> >> > > -- View this message in context: http://www.nabble.com/HADOOP-2536-supports-Oracle-too--tp21823199p22074829.html Sent from the Hadoop core-user mailing list archive at Nabble.com.
