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 attachment 91267 [details] dev-db/hsqldb/hsqldb-1.8.0.4.ebuild Complete ebuild for easier maintenance. Tested on x86 and amd64 only.
Created attachment 91268 [details, diff] 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 attachment 91269 [details, diff] 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 attachment 91270 [details, diff] 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 attachment 91271 [details, diff] files/server.properties-1.8 Updated version of 'server.properties' authorization file.
Created attachment 91272 [details] files/server.properties-1.8 A correct version of updated 'server.properties' authorization file.
Created attachment 91273 [details] hsqldb/files/sqltool.rc-1.8 Updated version of 'sqltool.rc' authorization file.
Created attachment 91274 [details] files/35hsqldb An env file which is installed into /etc/env.d - enables CONFIG_PROTECT for Hsqldb database files.
Created attachment 91275 [details, diff] 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 ***