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

Moderator: NorbertKrupa

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

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

Post by JimKnicely » Thu Oct 10, 2013 5:58 pm

Wait, I see you are doing a COPY LOCAL. The exception and rejection files will then have to be stored on the client.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

kleysonr
Newbie
Newbie
Posts: 17
Joined: Thu Oct 10, 2013 2:09 pm

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

Post by kleysonr » Thu Oct 10, 2013 6:12 pm

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.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

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

Post by JimKnicely » Thu Oct 10, 2013 6:26 pm

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
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Error Codes”