#4 cannot access hsqldb table

closed
Dave Glasser
None
5
2003-07-13
2003-06-23
Anonymous
No

in the case of hsqldb,
there are table owner.
so, no user id before table name.

for example insert ,table not found
SQL statement error occured.
"table not found .memo"
because,no need dot before table name.

it occured when insert,select,update, delete all SQL
statement.

Discussion

  • Dave Glasser
    Dave Glasser
    2003-07-13

    Logged In: YES
    user_id=547875

    Sorry for the delayed action. I still haven't figured out how to
    set this so I get email notifications when new bugs are
    entered.

    Anyway, the fix for this is in CVS, the file is
    org/glasser/sql/TableInfo.java. If you rebuild the program with
    this file, your problem should go away. I haven't tested it with
    hsqldb, but it's a very simple fix so it should work. The fix will
    be in the next release of QueryForm, but I'm holding back on
    the next release until Sourceforge gets their download stats
    fixed.

     
  • Dave Glasser
    Dave Glasser
    2003-07-13

    • assigned_to: nobody --> dglasser
    • status: open --> closed