Hello,

 

there seems to be problem when writing data in a reducer to an Oracle
table. The reason is, that the generated INSERT INTO statement in
DBOutputFormat.constructQuery(...) appends a ";" at the end of the
INSERT INTO statement, which obviously fails with the Oracle JDBC driver
due to PreparedStatement.executeBatch() call in DBRecordWriter.close. I
get a "ORA-00911: invalid character" exception here. The Oracle JDBC
driver (or JDBC in general?) doesn't like the ";" at the end of a
statement when executed in context of a batch.

 

Any comments?

 

Thanks,

Thomas

 

Reply via email to