Menu

#21 jdbc driver expects quoted database name

open
nobody
None
5
2005-09-17
2005-09-16
Anonymous
No

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"

Discussion

  • Nobody/Anonymous

    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.

     
  • Uwe Voigt

    Uwe Voigt - 2005-09-17
    • milestone: 472436 -->
     

Log in to post a comment.

MongoDB Logo MongoDB