@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.
