Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 242324 - dev-db/hsqldb: add commandline wrapper for hsqldb-databasemanager
Summary: dev-db/hsqldb: add commandline wrapper for hsqldb-databasemanager
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High enhancement (vote)
Assignee: Java team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-16 09:59 UTC by Zhang Weiwu
Modified: 2016-01-26 08:44 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Zhang Weiwu 2008-10-16 09:59:23 UTC
Hello. I find it very useful to creat /usr/bin/hsqldb-databasemanager with the following content right after having installed dev-db/hsqldb:

#!/bin/sh
pkgs=`java-config --list-available-packages | awk '/^\[jdbc/ {ORS=","; print $1;} END {ORS=""; print "hsqldb";}' | tr -d '[]'`
java -cp `java-config --classpath $pkgs` org.hsqldb.util.DatabaseManagerSwing

reason:
1) user probably installed hsqldb in order to get a generic GUI tool to access other databases. However it wouldn't be easy to get it running without having finished the gentoo guide for Java and knows how to collect the classpath for jdbcs. Me for example spent a whole day to get to the point I can run DatabaseManagerSwing access my MySQL + PostSQL db.
2) finding the classpath for jdbc-libraries require distribution-specific knowledge, which means even if hsqldb development team wished to have a shortcut commandline to launch their GUI, they couldn't effectively write one that uses jdbc drivers on the target machine, which push the task to write such handy script to the porter of each distribution.

P.S. the awt-based interface for HSQL Database Manager presented several problem due to the awt widget-set doesn't have a tabe widget to hold the result of SQL queries. I suffered these problems before I switch to the Swing version, but I forgot what problem there had been with awt, only remember there are some. Hence I am defaulting to use swing version in the above script.
Comment 1 Zhang Weiwu 2008-10-16 10:00:20 UTC
I forgot to mention the request itself.

My reuqest is to have /usr/bin/hsqldb-databasemanager automatically created by the ebuilds during emerge.
Comment 2 Patrice Clement gentoo-dev 2016-01-26 08:44:08 UTC
No, we don't add one-off, personal bash scripts to the Portage tree. Get back to us with something that has a bit more "consistency" and we might consider it. Closing this bug.