How to use @JDBCDBColumn for typ ahead in xpages

Using Notes 9 and extension library's data controls...

I want to use the @JDBCDbColumn() to get the type ahead values from an Oracle table.

Is that possible at all? Does it work the same way the standard DBColumn in the type ahead?

Note that the DBColumn is looking in a huge table, but I specify a where clause that should filter what the JDBCDBColumn returns.

Somehow, nothing happens. Work sfine with Notes data though, but I need to get this working with the Oracle data.

Thanks!

Update 1: Code I have...

@JdbcExecuteQuery(
    "oracle",
    "select distinct postal_code from cifadmin.postal_codes where postal_code like '"
      + getComponent("CodePostal").getValue() + "%'")

Update 2: Here is the code I have right now, but it doesn't return anything:

var CodePostal = getComponent("rsSearchQuery").getValue();
if(!!CodePostal) {
    var params = [CodePostal];
    var a = @JdbcDbColumn("oracle", "postal_codes", "postal_code", "postal_code like ?", params); 
    return @Unique(a);
} else {
    return "--";
}

Solution

OK, I got it working thanks to all your comments and a bit of intuition!!!

Here is the working code:

var sql = "SELECT DISTINCT POSTAL_CODE FROM cifadmin.POSTAL_CODES WHERE POSTAL_CODE LIKE'" +     getComponent("PostalCode").getValue() +"%' ORDER BY POSTAL_CODE";
var res = @JdbcExecuteQuery("oracle", sql);
var values = new Array();
while (res.next()) {
values.push(res.getString("POSTAL_CODE"));
}   
return values;

The thing that got it working was when I have forced 'values' as an array. Without that, it just doesn't work.

Picky and sensitive, XPages are!!!

Thanks to all for your help ;)