Import jdbc-postgresql74, JDBC driver for postgresql 7.4.x

Has local patch to (incompletely) work around an issue with the jdbc driver
erroneously leaving ';' on the end of tablenames resulting in it generating
SQL statments of the form "SELECT * FROM tablename; WHERE ..."

6 files changed, 95 insertions, 0 deletions

diff --git a/databases/jdbc-postgresql74/DESCR b/databases/jdbc-postgresql74/DESCR
new file mode 100644
index 00000000000..e197dad6c33
--- /dev/null
+++ b/databases/jdbc-postgresql74/DESCR
@@ -0,0 +1 @@
+This package contains a complete Type 4 JDBC driver for the Postgresql RDBMS.
diff --git a/databases/jdbc-postgresql74/Makefile b/databases/jdbc-postgresql74/Makefile
new file mode 100644
index 00000000000..fa73d82d8a7
--- /dev/null
+++ b/databases/jdbc-postgresql74/Makefile
@@ -0,0 +1,55 @@
+# $NetBSD: Makefile,v 1.1.1.1 2004/06/03 10:23:19 abs Exp $
+#
+
+DIST_VERS=		7.4.2
+DISTNAME=		postgresql-${DIST_VERS}
+PKGNAME=		jdbc-${DISTNAME}
+PKGREVISION=		1
+CATEGORIES=		databases java
+MASTER_SITES?=		http://www.postgresql.org/ftpsite/source/v${DIST_VERS}/ \
+			ftp://ftp.postgresql.org/pub/source/v${DIST_VERS}/ \
+			ftp://ftp.de.postgresql.org/pub/source/v${DIST_VERS}/ \
+			ftp://ch.postgresql.org/mirror/postgresql/source/v${DIST_VERS}/ \
+			ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/source/v${DIST_VERS}/ \
+			ftp://looking-glass.usask.ca/pub/postgresql/source/v${DIST_VERS}/ \
+			ftp://ftp.sunsite.auc.dk/mirrors/postgresql/source/v${DIST_VERS}/ \
+			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/source/v${DIST_VERS}/
+EXTRACT_SUFX=		.tar.bz2
+
+MAINTAINER=		jwise@NetBSD.org
+HOMEPAGE=		http://www.postgresql.org/
+COMMENT=		Pure Java JDBC driver for PostgreSQL 7.4.x
+
+# No, we don't depend on postgresql.  This code base stands alone.
+BUILD_DEPENDS+=		apache-ant-[0-9]*:../../devel/apache-ant
+
+EXTRACT_ELEMENTS=	${DISTNAME}/src/interfaces/jdbc
+
+WRKSRC=			${WRKDIR}/${DISTNAME}/src/interfaces/jdbc
+USE_GNU_TOOLS+=		make
+
+EXAMPLEDIR=		${PREFIX}/share/examples/java/jdbc-postgresql
+DOCDIR=			${PREFIX}/share/doc/java/jdbc-postgresql
+
+do-configure:
+	( ${ECHO} "VERSION=		${DIST_VERS}";			\
+	  ${ECHO} "ANT=			${LOCALBASE}/bin/ant";		\
+	  ${ECHO} "DEF_PGPORT=		5432";				\
+	  ${ECHO} "srcdir=		.";				\
+	) > ${WRKSRC}/../../../src/Makefile.global
+	${SED}  -e "s:@FULLVERSION@:${DIST_VERS}:" \
+		-e "s:@MAJOR@:${DIST_VERS:C/\..*//}:" \
+		-e "s:@MINOR@:${DIST_VERS:C/[0-9]*\.//:C/\..*//}:" \
+	${FILESDIR}/build.properties > ${WRKSRC}/build.properties
+
+do-install:
+	${INSTALL_DATA_DIR} ${PREFIX}/lib/java
+	${INSTALL_DATA} ${WRKSRC}/jars/postgresql.jar ${PREFIX}/lib/java
+	${INSTALL_DATA_DIR} ${EXAMPLEDIR}
+	${INSTALL_DATA} ${WRKSRC}/example/*.java ${EXAMPLEDIR}
+	${INSTALL_DATA} ${WRKSRC}/jars/postgresql-examples.jar ${EXAMPLEDIR}
+	${INSTALL_DATA_DIR} ${DOCDIR}
+	${INSTALL_DATA} ${WRKSRC}/README ${DOCDIR}
+
+.include "../../mk/java-vm.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/jdbc-postgresql74/PLIST b/databases/jdbc-postgresql74/PLIST
new file mode 100644
index 00000000000..52245fc8e13
--- /dev/null
+++ b/databases/jdbc-postgresql74/PLIST
@@ -0,0 +1,14 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2004/06/03 10:23:19 abs Exp $
+lib/java/postgresql.jar
+share/examples/java/jdbc-postgresql/postgresql-examples.jar
+share/examples/java/jdbc-postgresql/ImageViewer.java
+share/examples/java/jdbc-postgresql/Unicode.java
+share/examples/java/jdbc-postgresql/basic.java
+share/examples/java/jdbc-postgresql/blobtest.java
+share/examples/java/jdbc-postgresql/datestyle.java
+share/examples/java/jdbc-postgresql/metadata.java
+share/examples/java/jdbc-postgresql/psql.java
+share/examples/java/jdbc-postgresql/threadsafe.java
+share/doc/java/jdbc-postgresql/README
+@dirrm share/examples/java/jdbc-postgresql
+@dirrm share/doc/java/jdbc-postgresql
diff --git a/databases/jdbc-postgresql74/distinfo b/databases/jdbc-postgresql74/distinfo
new file mode 100644
index 00000000000..e26c2243578
--- /dev/null
+++ b/databases/jdbc-postgresql74/distinfo
@@ -0,0 +1,5 @@
+$NetBSD: distinfo,v 1.1.1.1 2004/06/03 10:23:19 abs Exp $
+
+SHA1 (postgresql-7.4.2.tar.bz2) = 52b8a8a3467298c659e424213b72a15b08be9d59
+Size (postgresql-7.4.2.tar.bz2) = 10100398 bytes
+SHA1 (patch-aa) = 3dea03b653408c0191959c9f2532f6150d7d5d95
diff --git a/databases/jdbc-postgresql74/files/build.properties b/databases/jdbc-postgresql74/files/build.properties
new file mode 100644
index 00000000000..8eeb65a9830
--- /dev/null
+++ b/databases/jdbc-postgresql74/files/build.properties
@@ -0,0 +1,7 @@
+# $NetBSD: build.properties,v 1.1.1.1 2004/06/03 10:23:19 abs Exp $
+# This file was based on that created by 'make build.properties'.
+major=@MAJOR@
+minor=@MINOR@
+fullversion=@FULLVERSION@
+def_pgport=5432
+enable_debug=no
diff --git a/databases/jdbc-postgresql74/patches/patch-aa b/databases/jdbc-postgresql74/patches/patch-aa
new file mode 100644
index 00000000000..436d5d12978
--- /dev/null
+++ b/databases/jdbc-postgresql74/patches/patch-aa
@@ -0,0 +1,13 @@
+$NetBSD: patch-aa,v 1.1.1.1 2004/06/03 10:23:19 abs Exp $
+
+--- org/postgresql/jdbc2/AbstractJdbc2ResultSet.java.orig	2004-05-21 12:54:29.000000000 +0100
++++ org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
+@@ -1448,7 +1450,7 @@ public abstract class AbstractJdbc2Resul
+ 			{
+ 				if (name.toLowerCase().equals("from"))
+ 				{
+-					tableName = st.nextToken();
++					tableName = st.nextToken().replaceAll(";", "");
+ 					tableFound = true;
+ 				}
+ 			}