This section lists the data resource products and databases which have been tested with OGSA-DAI.
![[Note]](images/note.gif) | Note |
|---|---|
Unless explicitly stated, OGSA-DAI may be compatible with other versions of these products and, indeed, other products. Users are encouraged in the first instance to just try their product with OGSA-DAI. |
| Database | Version | WWW |
|---|---|---|
| MySQL | 5.0.15 | http://www.mysql.com/downloads/ |
| IBM DB2 | 8.1 FixPack 5 (Express-C) | http://www-306.ibm.com/software/data/db2/ |
| Microsoft SQL Server | 2000 | http://www.microsoft.com/sql/ |
| Oracle | 10g Enterprise Edition Release 10.2.0.1.0 - Production | http://www.oracle.com/database/ |
| PostgreSQL | 8.1.4 | http://www.postgresql.org |
| eXist | 1.1.1 (1.0???) | http://exist.sourceforge.net |
| File system | Unix, Linux and Windows | - |
| OGSA-DAI resource group | - | This is an OGSA-DAI resource that contains the identities of other OGSA-DAI resources available in an OGSA-DAI deployment. |
Table 3.1. Compatible data resources.
This table provides details of the recommended database drivers for each database product.
| Database | Driver | JARs | Class |
|---|---|---|---|
| MySQL | MySQL Connector J/2 | mysql-connector-java-5.0.4-bin.jar | org.gjt.mm.mysql.Driver |
| IBM DB2 | DB2 JDBC Driver | db2jcc.jar, db2jcc_licence_cu.jar | com.ibm.db2.jcc.DB2Driver |
| Microsoft SQL Server | Microsoft SQL Server JDBC Driver | mssqlserver.jar, msbase.jar, msutil.jar
| com.microsoft.jdbc.sqlserver.SQLServerDriver |
| Oracle | Oracle JDBC Drivers for Java 1.2+ | ojdbc14.jar
(this may be
distributed in a file with a .zip -
the file can be renamed to have a
.jar extension).
| oracle.jdbc.driver.OracleDriver |
| PostgreSQL | Postgres JDBC Driver | postgresql-8.1-407.jdbc3.jar
| org.postgresql.Driver |
| eXist | eXist XMLDB driver |
exist.jar, xmlrpc-1.2-patched.jar,
xmldb.jar (xmldb.jar is
shipped with OGSA-DAI).
| org.exist.xmldb.DatabaseImpl |
| File system | None | None | None |
| Resource group | None | None | None |
Table 3.2. Data resource driver information.
This table shows example connection URIs for each product. Connection URIs are required when configuring OGSA-DAI to expose a data resource.
| Database | Example URI |
|---|---|
| MySQL | jdbc:mysql://myhost:3306/daitest |
| IBM DB2 |
jdbc:db2://myhost:50000/ogsadai
|
| Microsoft SQL Server |
jdbc:microsoft:sqlserver://myhost:1433;DatabaseName=ogsadai
|
| Oracle |
jdbc:oracle:thin:@myhost:1521:ogsadai
|
| PostgreSQL |
jdbc:postgresql://myhost:5432/ogsadai
|
| eXist |
xmldb:exist://myhost:9120/exist/xmlrpc/db/littleblackbook
|
| Unix/Linux File System |
/home/public/myDataResourceFiles
|
| Windows File System |
C:\Public\MyDataResourceFiles
|
| Resource group |
-
|
Table 3.3. Data resource connection URI examples.