jdbc driver expects quoted database name
Brought to you by:
uwe_ewald
Database: Advantage Database Server, jdbc driver for
7.1 and newer
ADS expects the Databasename in Statements quoted
with "
dbedit.core.DataException: Couldn't execute
query:select * from //server/catalog."tablename"
com.extendedsystems.jdbc.advantage.ADSException:
[Extended Systems][Advantage SQL Engine]Expected
lexical element not found: <identifier> missing table
name There was a problem parsing the table names
after the FROM keyword in your SELECT statement. --
Location of error in the SQL statement is: 55
The correct Statemant has to be:
select * from "//server/catalog"."tablename"
Logged In: NO
Most databases that supports catalogs reject statements with
quoted catalogs. The ADS JDBC driver should return the
catalogs in quoted format if it needs them quoted in statements.
Otherwise that would be a feature request rather than a bug
report.