DbUtils is a small set of classes designed to make working with JDBC easier.

JDBC resource cleanup code is mundane, error prone work so these classes
abstract out all of the cleanup tasks from your code leaving you with what
you really wanted to do with JDBC in the first place: query and update data.

WWW: http://jakarta.apache.org/commons/dbutils/

PR:		93324
Submitted by:	Michael Winking <mwfp@foldl.net>

5 files changed, 80 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 881ce61c43f7..f9dcde865388 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -71,6 +71,7 @@
     SUBDIR += ip4r
     SUBDIR += ipa_sdb
     SUBDIR += isql-viewer
+    SUBDIR += jakarta-commons-dbutils
     SUBDIR += jasperreports
     SUBDIR += java-sqlrelay
     SUBDIR += jdb
diff --git a/databases/jakarta-commons-dbutils/Makefile b/databases/jakarta-commons-dbutils/Makefile
new file mode 100644
index 000000000000..8157b8d83796
--- /dev/null
+++ b/databases/jakarta-commons-dbutils/Makefile
@@ -0,0 +1,50 @@
+# Ports collection makefile for:	Jakarta Commons DbUtils
+# Date created:			14 Feb 2006
+# Whom:				Michael Winking <mwfp@foldl.net>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	commons-dbutils
+PORTVERSION=	1.0
+CATEGORIES=	databases java
+MASTER_SITES=	${MASTER_SITE_APACHE_JAKARTA}
+MASTER_SITE_SUBDIR=	commons/dbutils/source
+PKGNAMEPREFIX=	jakarta-
+DISTNAME=	${PORTNAME}-${PORTVERSION}-src
+
+MAINTAINER=	mwfp@foldl.net
+COMMENT=	JDBC helper library
+
+BUILD_DEPENDS=	${JAVALIBDIR}/junit.jar:${PORTSDIR}/java/junit
+
+USE_JAVA=	yes
+JAVA_VERSION=	1.3+
+USE_ANT=	yes
+
+MAKE_ARGS=	-cp ${JAVAJARDIR}/junit.jar
+ALL_TARGET=	dist
+WRKSRC=		${WRKDIR}/${PORTNAME}-${PORTVERSION}
+PLIST_FILES=	%%JAVAJARDIR%%/${PORTNAME}.jar
+
+.if !defined(NOPORTDOCS)
+PORTDOCS=	LICENSE.txt api
+.endif
+
+do-install:
+	@${ECHO_MSG} -n ">> Installing JAR as ${JAVAJARDIR}/${PORTNAME}.jar..."
+# strangely the jar archive from a 1.0 build contains 1.1 as version number
+	@${INSTALL_DATA} ${WRKSRC}/dist/commons-dbutils-1.1-dev.jar \
+		${JAVAJARDIR}/${PORTNAME}.jar
+	@${ECHO_MSG} " [DONE]"
+.if !defined(NOPORTDOCS)
+	@${ECHO_MSG} -n ">> Installing documentation..."
+	@${MKDIR} ${DOCSDIR}
+	@cd ${WRKSRC}/dist/docs && ${FIND} api \
+	  | ${CPIO} -pdmu -R ${SHAREOWN}:${SHAREGRP} ${DOCSDIR} > /dev/null 2>&1
+	@${INSTALL_DATA} ${WRKSRC}/dist/LICENSE.txt \
+		${DOCSDIR}/
+	@${ECHO_MSG} " [DONE]"
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/jakarta-commons-dbutils/distinfo b/databases/jakarta-commons-dbutils/distinfo
new file mode 100644
index 000000000000..3588f268bc3e
--- /dev/null
+++ b/databases/jakarta-commons-dbutils/distinfo
@@ -0,0 +1,3 @@
+MD5 (commons-dbutils-1.0-src.tar.gz) = 811b2d6e5c8c519c6196464ab89252a9
+SHA256 (commons-dbutils-1.0-src.tar.gz) = 6bf5376457ca201d9086cd42d16a026ba0d2254912517bbbfeea64e806dd41a2
+SIZE (commons-dbutils-1.0-src.tar.gz) = 28707
diff --git a/databases/jakarta-commons-dbutils/files/patch-build.xml b/databases/jakarta-commons-dbutils/files/patch-build.xml
new file mode 100644
index 000000000000..5ce7dffed012
--- /dev/null
+++ b/databases/jakarta-commons-dbutils/files/patch-build.xml
@@ -0,0 +1,20 @@
+# use installed junit, instead of unnecessarily downloading and and building a custom one (which didn't work anyway)
+*** build.xml.old	Sun Jan  1 09:43:41 2006
+--- build.xml	Sun Jan  1 09:32:51 2006
+***************
+*** 139,152 ****
+      </javadoc>
+    </target>
+    <target name="get-deps" unless="noget" depends="init">
+-     <get dest="${libdir}/junit-3.8.1.jar" usetimestamp="true" ignoreerrors="true" src="http://www.ibiblio.org/maven/junit/jars/junit-3.8.1.jar">
+-     </get>
+-     <get dest="${libdir}/junit-3.8.1.jar" usetimestamp="true" ignoreerrors="true" src="http://www.ibiblio.org/maven/junit/jars/junit-3.8.1.jar">
+-     </get>
+-     <get dest="${libdir}/ant-1.5.jar" usetimestamp="true" ignoreerrors="true" src="http://www.ibiblio.org/maven/ant/jars/ant-1.5.jar">
+-     </get>
+-     <get dest="${libdir}/ant-optional-1.5.jar" usetimestamp="true" ignoreerrors="true" src="http://www.ibiblio.org/maven/ant/jars/ant-optional-1.5.jar">
+-     </get>
+    </target>
+    <target name="install-maven">
+      <get dest="${user.home}/maven-install-latest.jar" usetimestamp="true" src="${repo}/maven/maven-install-latest.jar">
+--- 139,144 ----
diff --git a/databases/jakarta-commons-dbutils/pkg-descr b/databases/jakarta-commons-dbutils/pkg-descr
new file mode 100644
index 000000000000..da293d64c72e
--- /dev/null
+++ b/databases/jakarta-commons-dbutils/pkg-descr
@@ -0,0 +1,6 @@
+DbUtils is a small set of classes designed to make working with JDBC easier.
+JDBC resource cleanup code is mundane, error prone work so these classes
+abstract out all of the cleanup tasks from your code leaving you with what
+you really wanted to do with JDBC in the first place: query and update data.
+
+WWW: http://jakarta.apache.org/commons/dbutils/