jdbc query parameter

Community Support
1

Hey,

I query kdb tables with jdbc.

In test.java(http://code.kx.com/wsvn/code/kx/kdb%2B/c/test.java?op=dl&rev=1741&peg=1741):

ResultSet r = e.executeQuery("select * from t);

It will query correct.

but, when I add a where clause, the result will be nothing.

ResultSet r = e.executeQuery(“select * from t where s=‘`qwe’”);

Anyone knows how to add parameter for query?

Thanks,

Roy

2

maybe some quotes etc got messed up in email, but that should be

ResultSet r = e.executeQuery(“q)select * from t where s=`qwe”);

if s is a symbol vector. Note the q) prefix

3

Charles,
It works.

but, you’d better:

ResultSet r = e.executeQuery(“q)select from t where s=`qwe”);

NO *

4

yes, sorry about that