Wiki Testing/ServerInstallationGuide4 - Revision history

Ndp: /* Installing the OPeNDAP Relational Database Server */

2008-02-13T12:15:13Z

Installing the OPeNDAP Relational Database Server

← Older revision		Revision as of 12:15, 13 February 2008
Line 8:		Line 8:

	As of version 1.1, the DRDS cannot issue table join commands. This		As of version 1.1, the DRDS cannot issue table join commands. This
	means it cannot serve multiple tables connected by common keys ~~numbers~~. If		means it cannot serve multiple tables connected by common keys. If
	your DBMS supports views, you can use these to allow users to query		your DBMS supports views, you can use these to allow users to query
	multiple tables. If your DBMS does not support views, you need to put		multiple tables. If your DBMS does not support views, you need to put

Ndp: /* Installing the OPeNDAP Relational Database Server */

2008-02-13T12:15:02Z

Installing the OPeNDAP Relational Database Server

← Older revision		Revision as of 12:15, 13 February 2008
Line 8:		Line 8:

	As of version 1.1, the DRDS cannot issue table join commands. This		As of version 1.1, the DRDS cannot issue table join commands. This
	means it cannot serve multiple tables connected by ~~index~~ numbers. If		means it cannot serve multiple tables connected by common keys numbers. If
	your DBMS supports views, you can use these to allow users to query		your DBMS supports views, you can use these to allow users to query
	multiple tables. If your DBMS does not support views, you need to put		multiple tables. If your DBMS does not support views, you need to put

Yuan: /* Done */

2008-01-04T13:21:12Z

Done

← Older revision		Revision as of 13:21, 4 January 2008
Line 600:		Line 600:
	should be the same as the URL for the test server, using the "drds"		should be the same as the URL for the test server, using the "drds"
	directory instead of "dts," per the <font color='green'>servlet-mapping</font> direction		directory instead of "dts," per the <font color='green'>servlet-mapping</font> direction
	in the <font color='green'>web.xml</font> file. (See ([~~http:~~/~~/www <cite> server,drds,real-data</cite>~~]).)		in the <font color='green'>web.xml</font> file. (See ([[Wiki_Testing/ServerInstallationGuide4\|Section 4.3.2]]).)
	This should bring up a list of datasets you can select from.		This should bring up a list of datasets you can select from.

Yuan: /* Make an Info File */

2008-01-04T13:20:15Z

Make an Info File

← Older revision		Revision as of 13:20, 4 January 2008
Line 586:		Line 586:
	====Make an Info File====		====Make an Info File====


	~~\subj{Info files can make your data more useful to users.}~~
	This is entirely optional, but it can be helpful to users who want to		This is entirely optional, but it can be helpful to users who want to
	know more about your data. Create a file with HTML in it		know more about your data. Create a file with HTML in it
Line 595:		Line 594:
	See \DODSquick for information about the contents of the info		See \DODSquick for information about the contents of the info
	response.		response.



	====Done====		====Done====

Yuan: /* Make a DDS */

2008-01-04T13:19:46Z

Make a DDS

← Older revision		Revision as of 13:19, 4 January 2008
Line 526:		Line 526:

	In a file named for your table, in the directory nominated by the		In a file named for your table, in the directory nominated by the
	<font color='green'>dds_cache_dir</font> directive in the <font color='green'>web.xml</font> file ~~(see~~		<font color='green'>dds_cache_dir</font> directive in the <font color='green'>web.xml</font> file, put a DDS for your table. This
	~~\pageref{server,dodsini,example})~~, put a DDS for your table. This
	must contains declarations for each of the data types you expect a		must contains declarations for each of the data types you expect a
	user to ask for (or select over). The fields you don't list are		user to ask for (or select over). The fields you don't list are
Line 534:		Line 533:
	most closely correspond to the data in your tables.		most closely correspond to the data in your tables.

	~~\subj{Describe the structure of your dataset with the DDS.}~~
	The data served from a DRDS server is always enclosed in a DAP2 data		The data served from a DRDS server is always enclosed in a DAP2 data
	type called a "Sequence." Each instance of a Sequence corresponds		type called a "Sequence." Each instance of a Sequence corresponds
Line 542:		Line 541:
	introduction to these structures in \DODSquick.		introduction to these structures in \DODSquick.

	<blockquote>When writing your DDS, be sure the name of the top-level		<blockquote>NOTE: When writing your DDS, be sure the name of the top-level
	sequence matches the database table name. It is the sequence name,		sequence matches the database table name. It is the sequence name,
	rather than the dataset name, that is used in the SQL statement that		rather than the dataset name, that is used in the SQL statement that
Line 560:		Line 559:
	} b31; # Dataset name		} b31; # Dataset name
	</pre>		</pre>



	====Make a DAS====		====Make a DAS====

Yuan: /* Configure the Table Data Types */

2008-01-04T12:48:30Z

Configure the Table Data Types

← Older revision		Revision as of 12:48, 4 January 2008
Line 459:		Line 459:
	</center>		</center>

	~~\subj{Determine the DAP data types that most closely match yours.}~~
	First, determine the DAP data types that correspond with the JDBC		First, determine the DAP data types that correspond with the JDBC
	data types (see the data type mapping in		data types (see the data type mapping in

Yuan: /* Configure the Table Data Types */

2008-01-04T12:45:43Z

Configure the Table Data Types

← Older revision		Revision as of 12:45, 4 January 2008
Line 446:		Line 446:
	this (using Oracle):		this (using Oracle):

	{\|		<center>
			{\|border="3"
	! Name !! Null? !! Type		! Name !! Null? !! Type
	\|-		\|-
Line 456:		Line 457:

	\|}		\|}
			</center>

	\subj{Determine the DAP data types that most closely match yours.}		\subj{Determine the DAP data types that most closely match yours.}
Line 466:		Line 468:
	<font color='green'>info/b31</font> (if desired).		<font color='green'>info/b31</font> (if desired).

			<center>
	{\|		{\|border="3"
	! JDBC Data Type !! DAP2 Data Type		! JDBC Data Type !! DAP2 Data Type
	\|-		\|-
Line 509:		Line 511:
	\|}		\|}

	~~\caption{~~Mapping from JDBC Data Types to DAP2 Data Types}		Mapping from JDBC Data Types to DAP2 Data Types

			</center>

	<blockquote>The data types described in \tableref{tab,jdbc-mapping} are only		<blockquote>The data types described in \tableref{tab,jdbc-mapping} are only

Yuan: /* DODS Relational Database Server (DRDS) */

2008-01-04T12:43:15Z

DODS Relational Database Server (DRDS)

← Older revision		Revision as of 12:43, 4 January 2008
Line 266:		Line 266:


	#Microsoft SQL-Server 2000 JDBC Drivers: [[http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5\&DisplayLang=en<cite>		#Microsoft SQL-Server 2000 JDBC Drivers: [[http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5\&DisplayLang=en<cite> http://www.microsoft.com/</cite>]]
	http://www.microsoft.com/</cite>]]
	#Data Direct Technologies: [[http://www.datadirect.com/index.ssp<cite>http://www.datadirect.com/index.ssp</cite>]]		#Data Direct Technologies: [[http://www.datadirect.com/index.ssp<cite>http://www.datadirect.com/index.ssp</cite>]]

Yuan: /* DODS Relational Database Server (DRDS) */

2008-01-04T12:42:43Z

DODS Relational Database Server (DRDS)

← Older revision		Revision as of 12:42, 4 January 2008
Line 267:		Line 267:

	#Microsoft SQL-Server 2000 JDBC Drivers: [[http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5\&DisplayLang=en<cite>		#Microsoft SQL-Server 2000 JDBC Drivers: [[http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5\&DisplayLang=en<cite>
	http://www.microsoft.com/~~downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5\&DisplayLang=en~~</cite>]]		http://www.microsoft.com/</cite>]]
	#Data Direct Technologies: [[http://www.datadirect.com/index.ssp<cite>http://www.datadirect.com/index.ssp</cite>]]		#Data Direct Technologies: [[http://www.datadirect.com/index.ssp<cite>http://www.datadirect.com/index.ssp</cite>]]

Yuan: /* DODS Relational Database Server (DRDS) */

2008-01-04T12:41:53Z

DODS Relational Database Server (DRDS)

← Older revision		Revision as of 12:41, 4 January 2008
Line 266:		Line 266:


	#Microsoft SQL-Server 2000 JDBC Drivers: [http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5\&DisplayLang=en<cite>		#Microsoft SQL-Server 2000 JDBC Drivers: [[http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5\&DisplayLang=en<cite>
	http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5\&DisplayLang=en</cite>]		http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5\&DisplayLang=en</cite>]]
	#Data Direct Technologies: [http://www.datadirect.com/index.ssp<cite>http://www.datadirect.com/index.ssp</cite>]		#Data Direct Technologies: [[http://www.datadirect.com/index.ssp<cite>http://www.datadirect.com/index.ssp</cite>]]

	In this release the DRDS does not support SQL JOIN operations. Each database		In this release the DRDS does not support SQL JOIN operations. Each database