Syntax question /i and java/Vertica JDBC
Posted: Thu Sep 26, 2013 1:17 am
I am not sure what I am doing wrong here .. this is not my area of expertise. Essentially I need to have a file run based on a trigger from an event in SQL, for other things like this, we have called a simple java program to do things like run a copy command.
For this, I need to execute commands inside a text file
I am getting the error
Error: java.sql.SQLException: [Vertica][VJDBC](100081) ERROR: Syntax error at or near "\"
when running this
boolean result= stmt.execute ("\\i /home/dbadmin/text.txt;");
basically I want to execute ( I have // instead of / because it is apparantly an escape character)
\i /home/dbadmin/text.txt;
Any help would be appreciated
Thanks
For this, I need to execute commands inside a text file
I am getting the error
Error: java.sql.SQLException: [Vertica][VJDBC](100081) ERROR: Syntax error at or near "\"
when running this
boolean result= stmt.execute ("\\i /home/dbadmin/text.txt;");
basically I want to execute ( I have // instead of / because it is apparantly an escape character)
\i /home/dbadmin/text.txt;
Any help would be appreciated
Thanks