Setting the JavaBinaryForUDx Configuration Parameter

tester

SELECT SET_CONFIG_PARAMETER('JavaBinaryForUDx','/usr/java/default/bin/java');

Giving me an error of -bash: syntax error near unexpected token '('

Anyone?

Abhishek_Rana

It is type of syntax error only.. Check the syntax which you are using & see for correct quotes being used.

Try running it from vsql & from dbadmin user.

Regards'

Abhishek

tester

The syntax is should be right. U mean to run vsql inside dbadmin? How do u go about doing that? Thanks Abhishek

wwong2

Hi, it looks like you ran the SELECT SET_CONFIG_PARAMETER('JavaBinaryForUDx','/usr/java/default/bin/java'); command at linux command line, what you need to do is issue that within Vertica.
You can get in either through admintools to connect to db

$> /opt/vertica/bin/admintools

or direct through vsql

$>/opt/vertica/bin/vsql

Regards

tester

Thank you, it works perfectly now.