%global pomversion 2.3.0 Name: hsqldb Version: 2.3.1 Release: 5 Epoch: 1 Summary: HyperSQL Database Engine License: BSD URL: http://hsqldb.sourceforge.net/ Group: Databases BuildArch: noarch Source0: http://downloads.sourceforge.net/hsqldb/%{name}-%{version}.zip Source1: %{name}-1.8.0-standard.cfg Source2: %{name}-1.8.0-standard-server.properties Source3: %{name}-1.8.0-standard-webserver.properties Source4: %{name}-1.8.0-standard-sqltool.rc Source5: http://www.hsqldb.org/repos/org/hsqldb/hsqldb/%{pomversion}/hsqldb-%{pomversion}.pom # Custom systemd files - talking with upstream about incorporating them, see # http://sourceforge.net/projects/hsqldb/forums/forum/73673/topic/5367103 Source6: %{name}.systemd Source7: %{name}-wrapper Source8: %{name}-post Source9: %{name}-stop # Javadoc fails to create since apidocs folder is deleted and not recreated Patch0: %{name}-apidocs.patch # Package org.hsqldb.cmdline was only compiled with java 1.5 Patch1: %{name}-cmdline.patch BuildRequires: ant BuildRequires: jpackage-utils >= 0:1.5 BuildRequires: junit BuildRequires: systemd-units BuildRequires: servlet6 Requires: java Requires: servlet6 Requires(pre): shadow-utils Requires(post): systemd Requires(post): systemd-units Requires(preun): systemd-units Requires(postun): systemd-units %description HSQLdb is a relational database engine written in JavaTM , with a JDBC driver, supporting a subset of ANSI-92 SQL. It offers a small (about 100k), fast database engine which offers both in memory and disk based tables. Embedded and server modes are available. Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets or servlets, too) and a number of demonstration examples. Downloaded code should be regarded as being of production quality. The product is currently being used as a database and persistence engine in many Open Source Software projects and even in commercial projects and products! In it's current version it is extremely stable and reliable. It is best known for its small size, ability to execute completely in memory and its speed. Yet it is a completely functional relational database management system that is completely free under the Modified BSD License. Yes, that's right, completely free of cost or restrictions! %package manual Summary: Manual for %{name} %description manual Documentation for %{name}. %package javadoc Summary: Javadoc for %{name} Requires: jpackage-utils %description javadoc Javadoc for %{name}. %package demo Summary: Demo for %{name} Requires: %{name} = %{epoch}:%{version}-%{release} %description demo Demonstrations and samples for %{name}. %prep %setup -q -n %{name}-%{version}/%{name} # set right permissions find . -name "*.sh" -exec chmod 755 \{\} \; # remove all _notes directories for dir in `find . -name _notes`; do rm -rf $dir; done # remove all binary libs find . -name "*.jar" -exec rm -f {} \; find . -name "*.class" -exec rm -f {} \; find . -name "*.war" -exec rm -f {} \; # correct silly permissions chmod -R go=u-w * # Fix doc location sed -i -e 's/doc-src/doc/g' build/build.xml %patch0 -p1 %patch1 -p1 %build export CLASSPATH=$(build-classpath \ tomcat-servlet-api \ junit) pushd build export JAVA_TOOL_OPTIONS=-Dfile.encoding=UTF8 ant hsqldb popd %install # jar install -d -m 755 %{buildroot}%{_javadir} install -m 644 lib/%{name}.jar %{buildroot}%{_javadir}/%{name}.jar # bin install -d -m 755 %{buildroot}%{_bindir} # systemd install -d -m 755 %{buildroot}%{_unitdir} install -d -m 755 %{buildroot}%{_prefix}/lib/%{name} install -m 644 %{SOURCE6} %{buildroot}%{_unitdir}/%{name}.service install -m 755 %{SOURCE7} %{buildroot}%{_prefix}/lib/%{name}/%{name}-wrapper install -m 755 %{SOURCE8} %{buildroot}%{_prefix}/lib/%{name}/%{name}-post install -m 755 %{SOURCE9} %{buildroot}%{_prefix}/lib/%{name}/%{name}-stop # config install -d -m 755 %{buildroot}%{_sysconfdir}/sysconfig install -m 644 %{SOURCE1} %{buildroot}%{_sysconfdir}/sysconfig/%{name} # serverconfig install -d -m 755 %{buildroot}%{_localstatedir}/lib/%{name} install -m 644 %{SOURCE2} %{buildroot}%{_localstatedir}/lib/%{name}/server.properties install -m 644 %{SOURCE3} %{buildroot}%{_localstatedir}/lib/%{name}/webserver.properties install -m 600 %{SOURCE4} %{buildroot}%{_localstatedir}/lib/%{name}/sqltool.rc # lib install -d -m 755 %{buildroot}%{_localstatedir}/lib/%{name}/lib # javadoc install -d -m 755 %{buildroot}%{_javadocdir}/%{name} cp -r doc/apidocs/* %{buildroot}%{_javadocdir}/%{name} # data install -d -m 755 %{buildroot}%{_localstatedir}/lib/%{name}/data # manual install -d -m 755 %{buildroot}%{_docdir}/%{name}-%{version} cp -r doc/* %{buildroot}%{_docdir}/%{name}-%{version} cp index.html %{buildroot}%{_docdir}/%{name}-%{version} cd .. # Maven metadata install -pD -T -m 644 %{SOURCE5} %{buildroot}%{_mavenpomdir}/JPP-%{name}.pom # %add_maven_depmap %add_to_maven_depmap %{name} %{name} %{version} JPP %{name} pushd %{buildroot}%{_localstatedir}/lib/%{name}/lib # build-classpath can not be used as the jar is not # yet present during the build ln -s %{_javadir}/hsqldb.jar hsqldb.jar ln -s $(build-classpath tomcat-servlet-api) servlet.jar popd %preun %systemd_preun hsqldb.service %pre # Add the "hsqldb" user and group # we need a shell to be able to use su - later %{_sbindir}/groupadd -g 96 -f -r %{name} 2> /dev/null || : %{_sbindir}/useradd -u 96 -g %{name} -s /sbin/nologin \ -d %{_localstatedir}/lib/%{name} -r %{name} 2> /dev/null || : %post %systemd_post hsqldb.service %postun %systemd_postun_with_restart hsqldb.service %triggerun -- hsqldb < 1.8.1.3-9 # Save the current service runlevel info # User must manually run systemd-sysv-convert --apply httpd # to migrate them to systemd targets /usr/bin/systemd-sysv-convert --save hsqldb >/dev/null 2>&1 ||: # If the package is allowed to autostart: /bin/systemctl --no-reload enable hsqldb.service >/dev/null 2>&1 ||: # Run these because the SysV package being removed won't do them /sbin/chkconfig --del hsqldb >/dev/null 2>&1 || : /bin/systemctl try-restart hsqldb.service >/dev/null 2>&1 || : %files %defattr(-,root,root,-) %{_javadir}/* %config(noreplace) %{_sysconfdir}/sysconfig/%{name} %{_unitdir}/%{name}.service %{_prefix}/lib/%{name}/%{name}-wrapper %{_prefix}/lib/%{name}/%{name}-post %{_prefix}/lib/%{name}/%{name}-stop %attr(0700,hsqldb,hsqldb) %{_localstatedir}/lib/%{name}/data %{_localstatedir}/lib/%{name}/lib %{_localstatedir}/lib/%{name}/server.properties %{_localstatedir}/lib/%{name}/webserver.properties %attr(0600,hsqldb,hsqldb) %{_localstatedir}/lib/%{name}/sqltool.rc %dir %{_localstatedir}/lib/%{name} %{_mavendepmapfragdir}/* %{_mavenpomdir}/* %files manual %doc %{_docdir}/%{name}-%{version} %files javadoc %doc %{_javadocdir}/%{name} %files demo