Bugzilla Bug 111960

The 1.8.0 version of hsqldb is included in OpenOffice 2.0 already.
Maybe the same version should be added to the portage tree as well?


Reproducible: Always
Steps to Reproduce:
1. emerge --sync
2. ls -l /usr/portage/dev-db/hsqldb

Actual Results:  
There is only a dev-db/hsqldb-1.7.3.1-r1 version in the portage.


Expected Results:  
To have a 1.8.0.1 and/or 1.8.0.2 version(s) of hsqldb in the portage.


Important!

The 1.7.3.1-r1 version doesn't allow to have more than one database when
run in the 'Server Mode' - using /etc/init.d/hsqldb script.

I'll file another bug report soon and post a comment here pointing to it.

Ok, so I've filed another bug report for the hsqldb-1.7.3.1-r1.
It's recorded as the Bug #111963.

I would propose to change the "use"-line in /etc/init.d/hsqldb to something
like: "use dns net localmount netmount nfsmount" instead of just "use net" in
this new version.
If not, hsqldb can come up too early (especially in conjunction with
RC_NET_STRICT_CHECKING="no") and will fail (with "java-config" not found) if
the /usr partition is not yet mounted.

Well, my last comment was nonsense. The problem is not the "use line"
(postgresql can live with "use net" too without starting up too early), but the
line "JAVA_EXECUTABLE=$(java-config --java)" which leads to an error during
boot on systems with a seperate /usr-partition because /usr is not mounted yet.
Should I open a new bug-report for that?

Recently I've managed to create an updated ebuild for hsqldb-1.8.0.4.
It contains a number of improvements, namely:

* is based on hsqldb-1.7.3.1-r3.ebuild
* uses a new style generation-2 java
* and doesn't use $(java-config --java) anymore
* adds IUSE="sqltools" which in effect puts more classes in hsqldb.jar,
  so programs like "HSQL Transfer Tool" (for dump/restore/transfer)
  can actually work
* uses CONFIG_PROTECT for database files
* has more informative comments in 'server.properties' and 'sqltool.rc'
  with explanation of database definitions syntax and global server settings
* IMPORTANT!
  resolves symlinks (Tomcat style) for authorization files in order to
  avoid the error: "Fix permissions on ${FILE} like 'chmod 600 {$FILE}'"
* IMPORTANT!
  puts the new style url line for default database in 'sqltool.rc'
  - url jdbc:hsqldb:hsql://localhost
  + url jdbc:hsqldb:hsql://localhost/
  without which hsqldb-1.8.0 refuses to start
* has reworked einfo/ewarn messages in pkg_postinst()
* mentions some Java command line and graphical tools for data management
  along with their invocations
* corrects several typos

I tested the upgrade path from hsqldb-1.7.3.1-r3 and it looks okay for me.
However, I'm not completely sure if I handled the CONFIG_PROTECT correctly,
since I did this by the first time and haven't seen many ebuild examples that
do it in an automatic way. Comments and ideas are appreciated.

Ebuild and patches will follow.

Created an attachment (id=91267) [details]
dev-db/hsqldb/hsqldb-1.8.0.4.ebuild

Complete ebuild for easier maintenance.
Tested on x86 and amd64 only.

Created an attachment (id=91268) [details]
hsqldb-1.8.0.4.ebuild.diff

A diff between hsqldb-1.7.3.1-r3.ebuild and hsqldb-1.8.0.4.ebuild
for easier reference.

Created an attachment (id=91269) [details]
files/resolve-config-softlinks.patch

Patch against /var/lib/hsqldb/bin/hsqldb script.
Resolves symlinks for authorization files, in Tomcat's catalina.sh style ;)

Created an attachment (id=91270) [details]
files/bundle-all-tools.patch

Patch against buil/buil.xml file that removes several <exclude> sections in
order to put more classes into hsqldb.jar.
This allows tools like "HSQL Transfer Tool" to actually work.

Created an attachment (id=91271) [details]
files/server.properties-1.8

Updated version of 'server.properties' authorization file.

Created an attachment (id=91272) [details]
files/server.properties-1.8

A correct version of updated 'server.properties' authorization file.

Created an attachment (id=91273) [details]
hsqldb/files/sqltool.rc-1.8

Updated version of 'sqltool.rc' authorization file.

Created an attachment (id=91274) [details]
files/35hsqldb

An env file which is installed into /etc/env.d - enables CONFIG_PROTECT
for Hsqldb database files.

Created an attachment (id=91275) [details]
init.d-hsqldb-typos.patch

Small corrections for /etc/init.d/hsqldb script.

hsqldb 1.8.0.6 is out.  The ebuild works well, but fails on sun-jdk-1.6.  

Any news on this one?

Version 1.8.0.7 was released, still dependent on jdk-1.5 no changes to ebuild
needed.

An update would remove one build from the openoffice source build.

added to "java-migration-overlay" with little dependencies and typos
modifications

(In reply to comment #17)
> added to "java-migration-overlay" with little dependencies and typos
> modifications
> 

Why not 1.8.0.7?
Also, does it really need 1.5 JDK no matter what? It would mean forcing 1.5 on
everything that depends on it. openoffice currently builds own hsqldb 1.8 and
can build with just 1.4 jdk (on amd64 it's even mandatory), so maybe it's just
some extra features needing 1.5?

I am currently working on JBoss ebuild and i just bumped to this version as it
is needed by jboss... My actions were to take the ebuild in there, control what
it does and test it with this new version and verify that all was done
correctly.
After that, that's true we can do the same for 1.8.0.7... 

Bumped to 1.8.0.7 and changed the JDK dep to || ( 1.4 1.5 ) because it builds
just fine with 1.4. Also some style cleanup. Builds ok but needs testing. Also
I'm not sure about this:

> adds IUSE="sqltools" which in effect puts more classes in hsqldb.jar
> so programs like "HSQL Transfer Tool" (for dump/restore/transfer)
> can actually work

IMHO tools belong to hsqltool.jar or hsqldbutil.jar. Programs shouldn't expect
that to be in hsqldb.jar... java-config -p hsqldb will bring all those jars to
classpath...

http://hsqldb.org/doc/guide/apg.html:
In version 1.8.0 Transfer Tool is no longer part of the hsqldb.jar. You can
build the hsqldbutil.jar using the Ant command of the same name, to build a jar
that includes Transfer Tool and the Database Manager.

So, I dropped the useflag and made it build and install also hsqldbutil.jar.
Next issue is that the init script doesn't background and return, it runs in
foreground...
And there should probably be launchers for the sql/dbmanager tools, and
possible src_test() (there are some junit testcases).

*** This bug has been marked as a duplicate of bug 201799 ***