Page 2 of 2

Re: [Vertica][VJDBC](100172) One or more rows were rejected

Posted: Thu Oct 10, 2013 5:58 pm
by JimKnicely
Wait, I see you are doing a COPY LOCAL. The exception and rejection files will then have to be stored on the client.

Re: [Vertica][VJDBC](100172) One or more rows were rejected

Posted: Thu Oct 10, 2013 6:12 pm
by kleysonr
A silly question. Does Vertica-JDBC drive store some kind of error logs on client side ?

My application, Kettle Pentaho, show me just an exception with the insert statement, but also using place holders instead of values.

Kleyson Rios.

Re: [Vertica][VJDBC](100172) One or more rows were rejected

Posted: Thu Oct 10, 2013 6:26 pm
by JimKnicely
I'm not the best person to ask about JDBC :(

Do you have access to the 6..x Programmer's Guide? Check out the section "Identifying Accepted and Rejected Rows" on page 143. It's specific for JDBC connections.

You can get to online here:

https://my.vertica.com/docs/6.1.x/PDF/H ... sGuide.pdf