Bug 93320 - New port: databases/hsqldb an embeddable java database
Summary: New port: databases/hsqldb an embeddable java database
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: Normal Affects Only Me
Assignee: Herve Quiroz
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-02-14 07:50 UTC by Michael Winking
Modified: 2006-02-16 16:06 UTC (History)
1 user (show)

See Also:


Attachments
hsqldb.shar (2.93 KB, text/plain)
2006-02-14 07:50 UTC, Michael Winking
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Winking 2006-02-14 07:50:03 UTC
	New port: databases/hsqldb an embeddable java database

How-To-Repeat: 	N/A
Comment 1 Herve Quiroz freebsd_committer freebsd_triage 2006-02-14 10:27:47 UTC
Responsible Changed
From-To: freebsd-ports-bugs->hq

I'll handle this.
Comment 2 Herve Quiroz freebsd_committer freebsd_triage 2006-02-14 10:35:59 UTC
State Changed
From-To: open->feedback

I applied some modifications: 

- Set PORTVERSION to 1.8.0.2 as it seems from the homepage that the version 
string is a 4 numbers string. 
- Converted spaces to tabs. Sometimes when you copy/paste tabs are not pasted 
as tabs. But portlint(1) will report this anyway 
- Removed JAVA_OS and JAVA_VENDOR entries (they were just redundant with the 
default behavior) 

Could you please review the new version? 


# This is a shell archive.  Save it in a file, remove anything before 
# this line, and then unpack it by entering "sh file".  Note, it may 
# create directories; files and directories will be owned by you and 
# have default permissions. 
# 
# This archive contains: 
# 
#	hsqldb 
#	hsqldb/pkg-descr 
#	hsqldb/Makefile 
#	hsqldb/distinfo 
# 
echo c - hsqldb 
mkdir -p hsqldb > /dev/null 2>&1 
echo x - hsqldb/pkg-descr 
sed 's/^X//' >hsqldb/pkg-descr << 'END-of-hsqldb/pkg-descr' 
XHSQLDB is the leading SQL relational database engine written in  
XJava. It has a JDBC driver and supports a rich subset of ANSI-92 
XSQL (BNF tree format) plus SQL 99 and 2003 enhancements. 
XIt offers a small (less than 100k in one version for applets), 
Xfast database engine which offers both in-memory and disk-based 
Xtables and supports embedded and server modes. Additionally,  
Xit includes tools such as a minimal web server, in-memory query 
Xand management tools (can be run as applets) and a number of 
Xdemonstration examples. 
X 
XWWW: http://hsqldb.org/ 
END-of-hsqldb/pkg-descr 
echo x - hsqldb/Makefile 
sed 's/^X//' >hsqldb/Makefile << 'END-of-hsqldb/Makefile' 
X# New ports collection makefile for:   hsqldb 
X# Date created:        14 Feb 2006 
X# Whom:                Michael Winking <mwfp@foldl.net> 
X# 
X# $FreeBSD$ 
X# 
X 
XPORTNAME=	hsqldb 
XPORTVERSION=	1.8.0.2 
XCATEGORIES=	databases java 
XMASTER_SITES=	${MASTER_SITE_SOURCEFORGE} 
XMASTER_SITE_SUBDIR=	hsqldb 
XDISTNAME=	hsqldb_${PORTVERSION:S/./_/g} 
XEXTRACT_SUFX=	.zip 
X 
XMAINTAINER=	mwfp@foldl.net 
XCOMMENT=	An embeddable SQL database written in Java 
X 
XUSE_JAVA=	yes 
XJAVA_VERSION=	1.4+ 
XUSE_ANT=	yes 
XUSE_ZIP=	yes 
XWRKSRC=		${WRKDIR}/${PORTNAME} 
XBUILD_WRKSRC=	${WRKSRC}/build 
XALL_TARGET=	hsqldb hsqljdbc 
XPLIST_FILES=	%%JAVAJARDIR%%/${PORTNAME}.jar %%JAVAJARDIR%%/hsqljdbc.jar 
X 
X.if !defined(NOPORTDOCS) 
XPORTDOCS=	hsqlFindFile.html hsqldb_lic.txt hypersonic_lic.txt guide images 
X.endif 
X 
Xdo-install: 
X	@${ECHO_MSG} -n ">> Installing JAR files to ${JAVAJARDIR}..." 
X	@${INSTALL_DATA} ${WRKSRC}/lib/hsqldb.jar  
X		${JAVAJARDIR}/hsqldb.jar 
X	@${INSTALL_DATA} ${WRKSRC}/lib/hsqljdbc.jar  
X		${JAVAJARDIR}/hsqljdbc.jar 
X	@${ECHO_MSG} " [DONE]" 
X.if !defined(NOPORTDOCS) 
X	@${ECHO_MSG} -n ">> Installing documentation..." 
X	@${MKDIR} ${DOCSDIR} 
X	@cd ${WRKSRC}/doc && ${FIND} guide images  
X	  | ${CPIO} -pdmu -R ${SHAREOWN}:${SHAREGRP} ${DOCSDIR} > /dev/null 2>&1 
X	@${INSTALL_DATA} ${WRKSRC}/doc/hsqlFindFile.html  
X		${WRKSRC}/doc/hsqldb_lic.txt  
X		${WRKSRC}/doc/hypersonic_lic.txt  
X		${DOCSDIR}/ 
X	@${ECHO_MSG} " [DONE]" 
X.endif 
X 
X.include <bsd.port.mk> 
END-of-hsqldb/Makefile 
echo x - hsqldb/distinfo 
sed 's/^X//' >hsqldb/distinfo << 'END-of-hsqldb/distinfo' 
XMD5 (hsqldb_1_8_0_2.zip) = c4a70d1fefdc2729a59c3b6b45fc88a3 
XSHA256 (hsqldb_1_8_0_2.zip) = f21e932b1cec5fca9f38ee6d880a6a0b3986824c9a78a5497180a597af4ecc55 
XSIZE (hsqldb_1_8_0_2.zip) = 3212934 
END-of-hsqldb/distinfo 
exit
Comment 3 Michael Winking 2006-02-14 12:43:02 UTC
Hi,

- Concerning the tabs I'll have to look if emacs is configured to
untabify plain text files when I do send-pr, since I have no other
explanation how they got there (portlint -N didn't complain about
spaces, though I may have ignored some other warnings). Hope this time
there are no spaces in place of tabs.
- The shar file you submitted contained an extra whitespace at the end
of each line, which prevented it from extracting correctly and had some
other side effects, though this was easily resolved.
- The newline backslash escapes in the makefile got lost, which
prevented make install from working. I have appended a corrected shar.

Otherwise things look fine.

Could you please cc: your answer to mwfp@foldl.net since gnats has for
some reason changed my originator address and I won't receive an answer
(I have already mailed bugmeister@freebsd.org to find out why this has
happened)

Thank you. 


# This is a shell archive.  Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file".  Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
#	hsqldb
#	hsqldb/pkg-descr
#	hsqldb/Makefile
#	hsqldb/distinfo
#
echo c - hsqldb
mkdir -p hsqldb > /dev/null 2>&1
echo x - hsqldb/pkg-descr
sed 's/^X//' >hsqldb/pkg-descr << 'END-of-hsqldb/pkg-descr'
XHSQLDB is the leading SQL relational database engine written in 
XJava. It has a JDBC driver and supports a rich subset of ANSI-92
XSQL (BNF tree format) plus SQL 99 and 2003 enhancements.
XIt offers a small (less than 100k in one version for applets),
Xfast database engine which offers both in-memory and disk-based
Xtables and supports embedded and server modes. Additionally, 
Xit includes tools such as a minimal web server, in-memory query
Xand management tools (can be run as applets) and a number of
Xdemonstration examples.
X
XWWW: http://hsqldb.org/
END-of-hsqldb/pkg-descr
echo x - hsqldb/Makefile
sed 's/^X//' >hsqldb/Makefile << 'END-of-hsqldb/Makefile'
X# New ports collection makefile for:   hsqldb
X# Date created:        14 Feb 2006
X# Whom:                Michael Winking <mwfp@foldl.net>
X#
X# $FreeBSD$
X#
X
XPORTNAME=	hsqldb
XPORTVERSION=	1.8.0.2
XCATEGORIES=	databases java
XMASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
XMASTER_SITE_SUBDIR=	hsqldb
XDISTNAME=	hsqldb_${PORTVERSION:S/./_/g}
XEXTRACT_SUFX=	.zip
X
XMAINTAINER=	mwfp@foldl.net
XCOMMENT=	An embeddable SQL database written in Java
X
XUSE_JAVA=	yes
XJAVA_VERSION=	1.4+
XUSE_ANT=	yes
XUSE_ZIP=	yes
XWRKSRC=		${WRKDIR}/${PORTNAME}
XBUILD_WRKSRC=	${WRKSRC}/build
XALL_TARGET=	hsqldb hsqljdbc
XPLIST_FILES=	%%JAVAJARDIR%%/${PORTNAME}.jar %%JAVAJARDIR%%/hsqljdbc.jar
X
X.if !defined(NOPORTDOCS)
XPORTDOCS=	hsqlFindFile.html hsqldb_lic.txt hypersonic_lic.txt guide
images
X.endif
X
Xdo-install:
X	@${ECHO_MSG} -n ">> Installing JAR files to ${JAVAJARDIR}..."
X	@${INSTALL_DATA} ${WRKSRC}/lib/hsqldb.jar \
X		${JAVAJARDIR}/hsqldb.jar
X	@${INSTALL_DATA} ${WRKSRC}/lib/hsqljdbc.jar \
X		${JAVAJARDIR}/hsqljdbc.jar
X	@${ECHO_MSG} " [DONE]"
X.if !defined(NOPORTDOCS)
X	@${ECHO_MSG} -n ">> Installing documentation..."
X	@${MKDIR} ${DOCSDIR}
X	@cd ${WRKSRC}/doc && ${FIND} guide images \
X	  | ${CPIO} -pdmu -R ${SHAREOWN}:${SHAREGRP} ${DOCSDIR} > /dev/null
2>&1
X	@${INSTALL_DATA} ${WRKSRC}/doc/hsqlFindFile.html \
X		${WRKSRC}/doc/hsqldb_lic.txt \
X		${WRKSRC}/doc/hypersonic_lic.txt \
X		${DOCSDIR}/
X	@${ECHO_MSG} " [DONE]"
X.endif
X
X.include <bsd.port.mk>
END-of-hsqldb/Makefile
echo x - hsqldb/distinfo
sed 's/^X//' >hsqldb/distinfo << 'END-of-hsqldb/distinfo'
XMD5 (hsqldb_1_8_0_2.zip) = c4a70d1fefdc2729a59c3b6b45fc88a3
XSHA256 (hsqldb_1_8_0_2.zip) =
f21e932b1cec5fca9f38ee6d880a6a0b3986824c9a78a5497180a597af4ecc55
XSIZE (hsqldb_1_8_0_2.zip) = 3212934
END-of-hsqldb/distinfo
exit
Comment 4 Michael Winking 2006-02-14 15:59:15 UTC
This time the shar shouldn't be mangled

# This is a shell archive.  Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file".  Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
#	hsqldb
#	hsqldb/pkg-descr
#	hsqldb/Makefile
#	hsqldb/distinfo
#
echo c - hsqldb
mkdir -p hsqldb > /dev/null 2>&1
echo x - hsqldb/pkg-descr
sed 's/^X//' >hsqldb/pkg-descr << 'END-of-hsqldb/pkg-descr'
XHSQLDB is the leading SQL relational database engine written in 
XJava. It has a JDBC driver and supports a rich subset of ANSI-92
XSQL (BNF tree format) plus SQL 99 and 2003 enhancements.
XIt offers a small (less than 100k in one version for applets),
Xfast database engine which offers both in-memory and disk-based
Xtables and supports embedded and server modes. Additionally, 
Xit includes tools such as a minimal web server, in-memory query
Xand management tools (can be run as applets) and a number of
Xdemonstration examples.
X
XWWW: http://hsqldb.org/
END-of-hsqldb/pkg-descr
echo x - hsqldb/Makefile
sed 's/^X//' >hsqldb/Makefile << 'END-of-hsqldb/Makefile'
X# New ports collection makefile for:   hsqldb
X# Date created:        14 Feb 2006
X# Whom:                Michael Winking <mwfp@foldl.net>
X#
X# $FreeBSD$
X#
X
XPORTNAME=	hsqldb
XPORTVERSION=	1.8.0.2
XCATEGORIES=	databases java
XMASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
XMASTER_SITE_SUBDIR=	hsqldb
XDISTNAME=	hsqldb_${PORTVERSION:S/./_/g}
XEXTRACT_SUFX=	.zip
X
XMAINTAINER=	mwfp@foldl.net
XCOMMENT=	An embeddable SQL database written in Java
X
XUSE_JAVA=	yes
XJAVA_VERSION=	1.4+
XUSE_ANT=	yes
XUSE_ZIP=	yes
XWRKSRC=		${WRKDIR}/${PORTNAME}
XBUILD_WRKSRC=	${WRKSRC}/build
XALL_TARGET=	hsqldb hsqljdbc
XPLIST_FILES=	%%JAVAJARDIR%%/${PORTNAME}.jar %%JAVAJARDIR%%/hsqljdbc.jar
X
X.if !defined(NOPORTDOCS)
XPORTDOCS=	hsqlFindFile.html hsqldb_lic.txt hypersonic_lic.txt guide images
X.endif
X
Xdo-install:
X	@${ECHO_MSG} -n ">> Installing JAR files to ${JAVAJARDIR}..."
X	@${INSTALL_DATA} ${WRKSRC}/lib/hsqldb.jar \
X		${JAVAJARDIR}/hsqldb.jar
X	@${INSTALL_DATA} ${WRKSRC}/lib/hsqljdbc.jar \
X		${JAVAJARDIR}/hsqljdbc.jar
X	@${ECHO_MSG} " [DONE]"
X.if !defined(NOPORTDOCS)
X	@${ECHO_MSG} -n ">> Installing documentation..."
X	@${MKDIR} ${DOCSDIR}
X	@cd ${WRKSRC}/doc && ${FIND} guide images \
X	  | ${CPIO} -pdmu -R ${SHAREOWN}:${SHAREGRP} ${DOCSDIR} > /dev/null 2>&1
X	@${INSTALL_DATA} ${WRKSRC}/doc/hsqlFindFile.html \
X		${WRKSRC}/doc/hsqldb_lic.txt \
X		${WRKSRC}/doc/hypersonic_lic.txt \
X		${DOCSDIR}/
X	@${ECHO_MSG} " [DONE]"
X.endif
X
X.include <bsd.port.mk>
END-of-hsqldb/Makefile
echo x - hsqldb/distinfo
sed 's/^X//' >hsqldb/distinfo << 'END-of-hsqldb/distinfo'
XMD5 (hsqldb_1_8_0_2.zip) = c4a70d1fefdc2729a59c3b6b45fc88a3
XSHA256 (hsqldb_1_8_0_2.zip) = f21e932b1cec5fca9f38ee6d880a6a0b3986824c9a78a5497180a597af4ecc55
XSIZE (hsqldb_1_8_0_2.zip) = 3212934
END-of-hsqldb/distinfo
exit
Comment 5 Herve Quiroz freebsd_committer freebsd_triage 2006-02-16 16:06:11 UTC
State Changed
From-To: feedback->closed

New port added. 

Thanks for your contribution!