This component consists of a set of java library jars to help data owners publish their RDBMS catalog data to the International Virtual Observatory.
It currently provides the following IVOA interfaces:
The DSA/Catalog component can be configured to connect to any RDBMS system for which a JDBC driver is provided.
It uses an XSLT stylesheet to perform translation from the input ADQL/xml query language to the system-specific SQL required by the RDBMS, and a number of stylesheets are pre-embedded in the DSA distribution..
The table below shows the RDBMS, JDBC driver and embedded stylesheet combinations against which the DSA/Catalog has been known to operate succesfully (with any caveats listed).
|RDBMS||JDBC driver||XSLT stylesheet||Comments|
|PostgreSQL 7.2.3||pg72jdbc2.jar||POSTGRES-7.2.3.xsl||Works, but streaming data transfers from RDBMS don't work (so setting low return row limit recommended to avoid DSA running out of memory).|
|Microsoft SQL Server 8.00||mssqlserver.jar, msbase.jar, msutil.jar (unsure of provenance of these, presume from appropriate distro)||SQLSERVER-8.00.xsl||Works.|
|Microsoft SQL Server 2000||mssqlserver.jar, msbase.jar, msutil.jar (from SQL Server 2000 distro.)||SQLSERVER-8.00.xsl||Works.|
|Sybase ASR 15.0||jconnect55.jar||SYBASE-ASE-15.0.xsl||Doesn't work (JDBC driver too old)|
|Sybase ASR 15.0||jconnect60-exclude.jar||SYBASE-ASE-15.0.xsl||Works, but TRUNCATE() function not supported.|
|Sybase ASR 15.0||jconn3.jar||SYBASE-ASE-15.0.xsl||Works, but TRUNCATE() function not supported.|
We are always grateful to hear of other combinations of RDBMS, driver and XSLT stylesheet that have been shown to work / not work. We also welcome community contributions of stylesheets for other RDBMS systems.
The DSA/Catalog component is downloaded as a "web archive" (WAR) file, which should be installed into a tomcat container. By default, it is configured to run against a small sample dataset stored in an embedded HSQLDB RDBMS.
The documents on this website describe how to obtain and install the DSA/Catalog web application. Once installed, the application provides its own documentation explaining how to configure the web application to serve your own data.
You will need to do the following: