New port: SQLiteJDBC is a Java JDBC driver for SQLite.

It runs using either a native code library or a 100% Pure Java driver
based on NestedVM emulation (but in this package only the native version
is installed).

PR:		124905
Submitted by:	Lapo Luchini

6 files changed, 82 insertions, 0 deletions

diff --git a/java/Makefile b/java/Makefile
index ed461cca59f3..95fcee5ee63d 100644
--- a/java/Makefile
+++ b/java/Makefile
@@ -156,6 +156,7 @@
     SUBDIR += shujit
     SUBDIR += simplicity
     SUBDIR += springframework
+    SUBDIR += sqlitejdbc
     SUBDIR += subversion-java
     SUBDIR += sun-wtk
     SUBDIR += trove4j
diff --git a/java/sqlitejdbc/Makefile b/java/sqlitejdbc/Makefile
new file mode 100644
index 000000000000..041fac723b2a
--- /dev/null
+++ b/java/sqlitejdbc/Makefile
@@ -0,0 +1,37 @@
+# New ports collection makefile for:   sqlitejdbc
+# Date created:        23 June 2008
+# Whom:                Lapo Luchini <lapo@lapo.it>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	sqlitejdbc
+PORTVERSION=	052
+DISTVERSIONPREFIX=	v
+DISTVERSIONSUFFIX=	-src
+CATEGORIES=	databases java
+MASTER_SITES=	http://files.zentus.com/sqlitejdbc/
+EXTRACT_SUFX=	.tgz
+
+MAINTAINER=	lapo@lapo.it
+COMMENT=	A Java JDBC driver for SQLite
+
+LIB_DEPENDS=	sqlite3:${PORTSDIR}/databases/sqlite3
+
+USE_JAVA=	yes
+JAVA_VERSION=	1.4+
+USE_GMAKE=	yes
+MAKE_ENV=	JAVA_HOME="${JAVA_HOME}"
+ALL_TARGET=	native
+USE_LDCONFIG=	yes
+
+PLIST_FILES=	%%JAVAJARDIR%%/sqlitejdbc-v${PORTVERSION}-native.jar lib/libsqlitejdbc.so
+
+post-patch:
+	${REINPLACE_CMD} 's|%%LOCALBASE%%|${LOCALBASE}|' ${WRKSRC}/Makefile
+
+do-install:
+	${INSTALL_DATA} ${WRKSRC}/build/sqlitejdbc-v${PORTVERSION}-native.jar ${JAVAJARDIR}/
+	${INSTALL_DATA} ${WRKSRC}/build/FreeBSD/libsqlitejdbc.so ${PREFIX}/lib/
+
+.include <bsd.port.mk>
diff --git a/java/sqlitejdbc/distinfo b/java/sqlitejdbc/distinfo
new file mode 100644
index 000000000000..324559d8fbe9
--- /dev/null
+++ b/java/sqlitejdbc/distinfo
@@ -0,0 +1,3 @@
+MD5 (sqlitejdbc-v052-src.tgz) = 4a98d52e522f4305b445e7b21daaf725
+SHA256 (sqlitejdbc-v052-src.tgz) = a35e8680d1be8f038f5f4019d0073faa08eff10ea949e61929f4136b7a56a97a
+SIZE (sqlitejdbc-v052-src.tgz) = 169043
diff --git a/java/sqlitejdbc/files/patch-Makefile b/java/sqlitejdbc/files/patch-Makefile
new file mode 100644
index 000000000000..52e98ff6f0de
--- /dev/null
+++ b/java/sqlitejdbc/files/patch-Makefile
@@ -0,0 +1,28 @@
+--- Makefile.orig	2008-06-18 01:39:02.000000000 +0200
++++ Makefile	2008-06-23 16:12:40.000000000 +0200
+@@ -16,6 +16,7 @@
+ #
+ 
+ include Makefile.common
++target := FreeBSD
+ 
+ default: test
+ 
+@@ -29,13 +30,15 @@
+ build/$(sqlitejdbc)-native.jar: $(native_classes)
+ 	cd build && jar cf $(sqlitejdbc)-native.jar $(java_classlist)
+ 
+-build/$(target)/$(LIBNAME): build/$(sqlite)-$(target)/sqlite3.o build/org/sqlite/NativeDB.class
++build/$(target)/$(LIBNAME): build/org/sqlite/NativeDB.class
+ 	@mkdir -p build/$(target)
+ 	$(JAVAH) -classpath build -jni -o build/NativeDB.h org.sqlite.NativeDB
+ 	$(CC) $(CFLAGS) -c -o build/$(target)/NativeDB.o \
++		-I%%LOCALBASE%%/include \
+ 		src/org/sqlite/NativeDB.c
+ 	$(CC) $(CFLAGS) $(LINKFLAGS) -o build/$(target)/$(LIBNAME) \
+-		build/$(target)/NativeDB.o build/$(sqlite)-$(target)/*.o
++		build/$(target)/NativeDB.o \
++		-L%%LOCALBASE%%/lib -lsqlite3
+ 	$(STRIP) build/$(target)/$(LIBNAME)
+ 
+ build/$(sqlite)-%/sqlite3.o: dl/$(sqlite)-amal.zip
diff --git a/java/sqlitejdbc/pkg-descr b/java/sqlitejdbc/pkg-descr
new file mode 100644
index 000000000000..4dd228f95fb8
--- /dev/null
+++ b/java/sqlitejdbc/pkg-descr
@@ -0,0 +1,7 @@
+SQLiteJDBC is a Java JDBC driver for SQLite.
+
+It runs using either a native code library or a 100% Pure Java driver 
+based on NestedVM emulation (but in this package only the native version 
+is installed).
+
+WWW: http://www.zentus.com/sqlitejdbc/
diff --git a/java/sqlitejdbc/pkg-message b/java/sqlitejdbc/pkg-message
new file mode 100644
index 000000000000..eecb4d63f0e1
--- /dev/null
+++ b/java/sqlitejdbc/pkg-message
@@ -0,0 +1,6 @@
+Warning: you need a sqlite3 port compiled with SQLITE_ENABLE_COLUMN_METADATA
+in order to use the following methods:
+  String ResultSetMetaData.getCatalogName(int column)
+  String ResultSetMetaData.getTableName(int column)
+any attemp to use them will close the JVM with an error of:
+  Undefined symbol "sqlite3_column_table_name16"