hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steinmaurer Thomas" <Thomas.Steinmau...@scch.at>
Subject Generated query by DBOutputFormat.constructQuery - Problem with Oracle
Date Tue, 20 Sep 2011 11:46:38 GMT


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?





  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message