Bug 218800 - HSQLDB doesn't yet support named parameters (":link_from_brand")
HSQLDB doesn't yet support named parameters (":link_from_brand")
Product: Fedora
Classification: Fedora
Component: hsqldb (Show other bugs)
i386 Linux
medium Severity medium
: ---
: ---
Assigned To: Deepak Bhole
Depends On:
  Show dependency treegraph
Reported: 2006-12-07 11:11 EST by Brian Johnson
Modified: 2007-11-30 17:11 EST (History)
3 users (show)

See Also:
Fixed In Version: hsqldb-
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2007-01-26 12:26:47 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Brian Johnson 2006-12-07 11:11:32 EST
Description of problem:

Version-Release number of selected component (if applicable):

How reproducible:

Steps to Reproduce:
1. make 2 tables in oo.org base using a native database file
2. create a relationship between 2 fields in the tables
3. use the form wizard to make a form with a subform (for the other table)
Actual results:
Gives an error related to the oo.org created subform SQL about the colon (":")
in ":link_to_table2"

Expected results:
Should work without errors

Additional info:
oo.org base uses named parameters (ie variables) to link the table data for the
subform to the table data for the main form.
This version doesn't recognize that it is a named parameter.
Comment 1 Caolan McNamara 2006-12-07 11:32:58 EST
Did you report this upstream
(http://qa.openoffice.org/issue_handling/pre_submission.html), this is a little
out of my expertise, and you'll likely get a quicker resolution. If you do,
mention the upstream issue id here.
Comment 2 Brian Johnson 2006-12-07 12:01:49 EST
I've been working with the openoffice dba mailing list.

Not sure if I totally understand the technicallities 

It sounds as though the issue is fixed in new versions of hsqldb 

Also, sounds like new versions of oo.org base auto-compensate for older versions
of hsqldb

Comment 3 Caolan McNamara 2006-12-07 12:29:45 EST

a) Latest stable version of hsqldb: so rawhide should be bumped to this

b) perhaps a backport of this named parameters feature to the FC-6 hsqldb is
indicated here.
Comment 4 Brian Johnson 2006-12-13 15:07:08 EST
Is there a work around for this while waiting for corrected hsqldb rpm (if that
is what will fix it)?

It currently appears impossible to use subforms with native oo.org db files in FC6.
Comment 5 Robert L Blake 2007-01-15 13:45:40 EST
I had exactly the same problem.  I downloaded the release of HSQLDB from
sourceforge, extracted the jar files from the lib directory of the zip into my
home, and added those JARs to the classpath within OOo (Tools -> Options ->
Openoffice.Org General -> Java -> Classpath -> Add Archive).  My subform is now
working fine, though slowly.  Maybe I just have unreasonable expectations for speed?

Anyway, this is a workaround that seems to work at first glance.  Which probably
means it will hose my data as soon as I turn my back, though that's not so
important to me at this precise moment.  That said, if this were fixed perhaps
by an official update to FC6 HSQLDB it would:

(a) make me very happy
(b) perhaps allow me to use one of these things for a client.  They have a
mailing list in Excel and some donation information, which is as far as I can
tell a textbook 1-to-many relationship.  But they need simple and transferable,
which an embedded DB would be.  I'd like to be able to offer this as on option,
since the many-tables-in-Excel strategy has been a disaster for them already,
but I'm reluctant (to say the least) until this is worked out.

Thank you!
Comment 6 Caolan McNamara 2007-01-16 03:22:20 EST
caolanm->dbhole: FYI re the request to get jpackage bumped to the hsqldb
Comment 7 Fedora Update System 2007-01-26 12:10:02 EST
hsqldb- has been pushed for fc6, which should resolve this issue.  If these problems are still present in this version, then please make note of it in this bug report.

Note You need to log in before you can comment on or make changes to this bug.