Hi,

 

I try to access a Oracle database by the JDBC Plugin (using oracle thin jar).

 

When I use a a table or a view in the same database the sql query it works fine. 

If I use a synonym I only get errors back.

 

Is there a way to access synonyms?

 

(I tested the sql query with DbVisualizer and the same java jar, the query is correct and works)

 

Thanks for help

 

Markus

I have done some more test.

 

If the table I try to access is a synonym name, I get a onl ERROR back with

 

jdbcFieldNames ( $table )

 

and

 

jdbcGetValue ( $columnName )

 

Is it a bug?

 

the query looks like (which works perfect in DBVisualizer)

select sample_name, amount, location, barcode from inventory where sample_name like 'aSampleName';

 

Markus