Andrew Jensen escribió:
Hi Arial
Have you tried appending
;default_schema=true
To the connection line as
jdbc:hsqldb:hsql://localhost/my_hsqldb;default_schema=true
This clears up the issue for me here.
Drew Jensen
On 4/20/07, Ariel <[EMAIL PROTECTED]> wrote:
Hello everybody.
These are the problems I've found connecting to HSQL running as a Server.
See the issue
http://dba.openoffice.org/issues/show_bug.cgi?id=55029
Do I duplicate the issue or vote for it?
Driver:
org.hsqldb.jdbcDriver
TEST CLASS: OK. Driver loaded successfully
Data source URL:
jdbc:hsqldb:hsql://localhost/my_hsqldb
TEST CONNECTION: OK. The connection was established successfully
PROBLEMS:
* when I try to edit a table, in the "Table Design" window there are NO
Field name or Filed Type when I open a table,
* it is impossible to insert new records (but I can execute INSERT
commands via the Tools – SQL dialog). [It isn't a problem of privileges:
I tested it with the default admin. "sa" and with a new user with all
granted.]
* when I try to use the Form, Report and Query Wizards, OOo shows the
following message: "The field names from "XXX" could not be retrieved",
the Wizards open, and every time I select a table on the list box (1.
Step of the Wizard), OOo displays the same message (different table name
only)
PS: the connection pool is disabled (I mention it because sometimes, in
other issues, it seems to be its fault)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Yes I did and worked, just as it was suggested in the issue 55029
http://dba.openoffice.org/issues/show_bug.cgi?id=55029
My question was if I should vote for it, duplicate it, or do nothing,
for the target was set to OOo later.
By and thanks
Ariel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
