SQL-92 error while executing SQL query

[Subhransu]

Hi,
I am able to connect to Sports.db through JDBC connection but could not able to execute "Select country from customer" from the java code. It is throwing the below exeption.

[DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not found (7519)

Please let me know how can I resolve it?

Thanks.
Subhransu

 

[TomBascom]

It might help if you showed your actual code.

My first guess is that you didn't specify the schema -- IOW: "select pub.country from pub.customer"

 

[Subhransu]

It worked. Thank you Sir.

 

[tamhas]

I think you mean pub.customer.country, but I think country is sufficient once you have used pub in the from.