Search found 13 matches

by caprile
Thu Jun 14, 2012 3:43 pm
Forum: JDBC
Topic: Vertica 6.0 and COPY LOCAL issue
Replies: 15
Views: 53736

Re: Vertica 6.0 and COPY LOCAL issue

I believe yes, it seems a bug.
If you see the link on myVertica you will read that it is a bug.
by caprile
Thu Jun 14, 2012 6:52 am
Forum: JDBC
Topic: Vertica 6.0 and COPY LOCAL issue
Replies: 15
Views: 53736

Re: Vertica 6.0 and COPY LOCAL issue

I wrote on myVertica forum, http://my.vertica.com/forums/topic/vertica-6-0-and-copy-local-issue/ they wrote that COPY LOCAL write rejected file only with superuser and vertica engineering team is looking into it. Anyway, my application is running on a different machine, the vertica database is runni...
by caprile
Wed Jun 13, 2012 11:18 am
Forum: JDBC
Topic: Vertica 6.0 and COPY LOCAL issue
Replies: 15
Views: 53736

Re: Vertica 6.0 and COPY LOCAL issue

It's only for test, for checking if JVM can write into rejected directory and after the out.close() the rejected file in on HDD into rejected directory. I suppose that i don't need to open a OutputStream but Vertica have to do this for me and write the rejected record according to the COPY LOCAL sta...
by caprile
Wed Jun 13, 2012 9:45 am
Forum: JDBC
Topic: Vertica 6.0 and COPY LOCAL issue
Replies: 15
Views: 53736

Re: Vertica 6.0 and COPY LOCAL issue

I do not use a Servlet but a simple java class. The main method where the COPY LOCAL statement is executed : private void loadData(java.sql.Connection connection) throws Exception { //create the empty file FileOutputStream out = new FileOutputStream(new File("/var/VERTICA_FLOW/rejected/VERTICA_FLOW8...
by caprile
Wed Jun 13, 2012 9:13 am
Forum: JDBC
Topic: Vertica 6.0 and COPY LOCAL issue
Replies: 15
Views: 53736

Re: Vertica 6.0 and COPY LOCAL issue

Ok, JVM has permission for writing.
I execute a test where I create the empty reject file before execute the COPY statement on vertica.
The rejected empty file is correctly created, but same error during COPY statement execution.
by caprile
Wed Jun 13, 2012 8:52 am
Forum: JDBC
Topic: Vertica 6.0 and COPY LOCAL issue
Replies: 15
Views: 53736

Re: Vertica 6.0 and COPY LOCAL issue

Yes, JDBC driver version 6
by caprile
Tue Jun 12, 2012 9:42 pm
Forum: JDBC
Topic: Vertica 6.0 and COPY LOCAL issue
Replies: 15
Views: 53736

Re: Vertica 6.0 and COPY LOCAL issue

I have an application running on linux machine on jboss application server. This application loading data via JDBC by the descripted statement on a remote machine where Vertica is running and I want the rejected file is written on the linux machine where the application resides. the var directory is...

Go to advanced search