incubator-ooo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ksch...@apache.org
Subject svn commit: r1204746 [6/8] - in /incubator/ooo/ooo-site/trunk/content/dba: FAQ/ QA/ QA/pics/ QA/testfolder/ QA/testfolder/ooQAReloaded/ __modules/ bugs/ css/ development/ downloads/ drivers/ drivers/mdb/ drivers/postgresql/ drivers/sqlite/ howto/ image...
Date Mon, 21 Nov 2011 23:16:13 GMT
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,306 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
+<HTML>
+<HEAD>
+	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
+	<TITLE></TITLE>
+	<META NAME="GENERATOR" CONTENT="StarOffice 6.0  (Win32)">
+	<META NAME="AUTHOR" CONTENT="Ocke Janssen">
+	<META NAME="CREATED" CONTENT="20020710;8345700">
+	<META NAME="CHANGEDBY" CONTENT="Ocke Janssen">
+	<META NAME="CHANGED" CONTENT="20020729;8060399">
+	<STYLE>
+	<!--
+		@page { margin: 2cm }
+		TD P { margin-bottom: 0.21cm }
+		H1 { margin-bottom: 0.21cm }
+		H1.western { font-family: "Albany", sans-serif; font-size: 16pt }
+		H1.cjk { font-size: 16pt }
+		H1.ctl { font-size: 16pt }
+		P { margin-bottom: 0.21cm }
+		H2 { margin-bottom: 0.21cm }
+		H2.western { font-family: "Albany", sans-serif; font-size: 14pt; font-style: italic }
+		H2.cjk { font-size: 14pt; font-style: italic }
+		H2.ctl { font-size: 14pt; font-style: italic }
+		H3 { margin-bottom: 0.21cm }
+		H3.western { font-family: "Albany", sans-serif }
+		H4 { margin-bottom: 0.21cm }
+		H4.western { font-family: "Albany", sans-serif; font-size: 11pt; font-style: italic }
+		H4.cjk { font-size: 11pt; font-style: italic }
+		H4.ctl { font-size: 11pt; font-style: italic }
+		TH P { margin-bottom: 0.21cm; font-style: italic }
+	-->
+	</STYLE>
+</HEAD>
+<BODY LANG="en-US">
+<H1 CLASS="western" ALIGN=CENTER>The creation and retrieving of auto
+increment values</H1>
+<P><BR><BR>
+</P>
+<P>Version History</P>
+<TABLE WIDTH=100% BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
+	<COL WIDTH=128*>
+	<COL WIDTH=128*>
+	<THEAD>
+		<TR VALIGN=TOP>
+			<TH WIDTH=50%>
+				<P>What/When</P>
+			</TH>
+			<TH WIDTH=50%>
+				<P>Who</P>
+			</TH>
+		</TR>
+	</THEAD>
+	<TBODY>
+		<TR VALIGN=TOP>
+			<TD WIDTH=50%>
+				<P>Draft---July 18, 2002</P>
+			</TD>
+			<TD WIDTH=50%>
+				<P>Ocke Janssen</P>
+			</TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=50%>
+				<P>GUI string review---July 25, 2002</P>
+			</TD>
+			<TD WIDTH=50%>
+				<P>Elizabeth Matthis</P>
+			</TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=50%>
+				<P>GUI change---July 26, 2002</P>
+			</TD>
+			<TD WIDTH=50%>
+				<P>Ocke Janssen</P>
+			</TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=50%>
+				<P>Final--- July 26, 2002fill in date 
+				</P>
+			</TD>
+			<TD WIDTH=50%>
+				<P>Ocke Janssen</P>
+			</TD>
+		</TR>
+	</TBODY>
+</TABLE>
+<H1 CLASS="western"><BR><BR>
+</H1>
+<H2 CLASS="western">Problem description</H2>
+<P>At the moment it is not possible to create auto increment columns
+and to retrieve the value of an auto increment column when a new row
+was inserted. 
+</P>
+<H4 CLASS="western">Creation of auto increment columns</H4>
+<P>Due to the fact that there exists no standard way on defining auto
+increment columns when creating a new table, a general approach is
+not possible. For example: MySQL identifies an auto increment
+definition of a column with the key word &ldquo;auto_increment&rdquo;,
+the MS SQL Server on the other side uses the keyword &ldquo;increment(1,1)&rdquo;
+to identify the auto increment column. 
+</P>
+<H4 CLASS="western">Retrieving of auto increment column's values</H4>
+<P>The retrieving of an auto increment column's value, when inserting
+a new row, is already defined in the JDBC API 3.0. There the
+statement supports an additional method which returns a result set to
+access the new inserted auto increment column's value. This result
+set also supports meta data. To check if the statement supports this
+mechanism, the database meta data is extended by new support method
+which simply returns true or false.</P>
+<H2 CLASS="western">Solution</H2>
+<P>To allow a general approach of defining/retrieving auto increment
+columns/values, the user must have the possibility to define a
+statement which should be appended at the column definition when
+creating a table or should be called when fetching the new value of
+the auto increment column.</P>
+<H4 CLASS="western">Creation of auto increment columns</H4>
+<P>When creating tables for any kind of database, the current
+handling at the moment is that we use a general SDBCX layer for all
+database drivers which do not support the layer by their self. In
+other words the user has to take no action when the database driver
+supports already the SDBCX layer. For the case that the driver
+doesn't support the SDBCX layer and the user creates a new table, the
+generated SQL statement may look like this:</P>
+<P>CREATE TABLE &ldquo;table1&rdquo; (&ldquo;id&rdquo; INTEGER)</P>
+<P>The &ldquo;CREATE TABLE&rdquo; statement doesn't support any auto
+increment features, so that it isn't possible to create such columns.
+For MySQL this statement for an auto increment column looks like
+this:</P>
+<P>CREATE TABLE &ldquo;table1&rdquo; (&ldquo;id&rdquo; INTEGER
+AUTO_INCREMENT)</P>
+<P>Like this examples shows the user must have the opportunity to add
+the missing part of the statement to the &ldquo;CREATE TABLE&rdquo;
+statement. This can be done in two different ways which mustn't
+exclude each other.</P>
+<OL>
+	<LI><P>The data source stores in their info property an additional
+	string which should be appended to the column part when creating an
+	auto increment column. To allow the user to insert this string the
+	data source administration dialog could be extended by a simple text
+	field and may be an additional checkbox which enables this text
+	field.</P>
+	<LI><P>The table design offers an additional field on the column
+	properties area when an auto increment type was selected. This field
+	can be used by the user to define a string which should be appended
+	to the &ldquo;CREATE TABLE&rdquo; statement. 
+	</P>
+	<LI><P>The points 1. and 2. are both used and under point 2, the
+	string which the user inserted under point 1 will be displayed in
+	the extra field.</P>
+</OL>
+<P>The 3<SUP>rd</SUP> approach would be the one which allows the user
+the most flexibility to get a predefined string which he could change
+if necessary. The best place to store the value for the data source
+would be the data source administration dialog. To be more precise
+this would be implemented for the JDBC and the ODBC drivers (they
+don't support the SDBCX layer). All other drivers support the SDBCX
+layer.</P>
+<H4 CLASS="western">Retrieving of auto increment column's values</H4>
+<P>As mentioned in the problem description JDBC 3.0 already defines
+methods to accomplish the task but it is not possible just to forward
+this to the used drivers. Many drivers as also APIs like ODBC don't
+support this feature. To fit near all databases, a method has to be
+implemented that allows to fetch the new inserted auto increment
+value. Many databases support a special SQL statement which allows to
+fetch this value. Mostly these statements are database specific and
+not SQL conform. So a similar approach as for the creation of auto
+increment columns should be chosen. The data source should also store
+a SQL string which allows to fetch the auto increment values. This
+string will then be executed by the statement when asked for the auto
+increment values after inserting a new row. To be compatible as
+possible to any kind of database the SQL string, stored in the data
+source, must fulfill some additional specifications to be valid for
+different tables. In other words, the SQL string must contain some
+keywords like $column1 or $table1 which will be replaced with the
+auto increment column name or with the used table. A general string
+could already be inserted into the data source dialog which is not
+the best solution but works for a lot of drivers:</P>
+<P>&ldquo;select count($column1)+1 from $table1&rdquo;</P>
+<P>If the supporting of this feature should be disabled the string
+could be cleared by the user or an additional checkbox must be
+inserted into to the dialog to enable or disable this feature. When
+this feature is enabled the database meta data object implemented by
+the driver will return false when asking the general support method
+for the feature &ldquo;AutoRetrievingEnabled&rdquo; otherwise true.
+When true was returned the statement object implemented by the driver
+allows the creation of a result set to fetch the auto increment
+values.</P>
+<H2 CLASS="western" STYLE="page-break-before: always">Data source
+administration dialog</H2>
+<P><IMG SRC="AutoIncrementValues_html_m243b4459.gif" NAME="Graphic1" ALIGN=LEFT WIDTH=643 HEIGHT=391 BORDER=0><BR CLEAR=LEFT><BR><BR>
+</P>
+<P><BR><BR>
+</P>
+<TABLE WIDTH=100% BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
+	<COL WIDTH=85*>
+	<COL WIDTH=85*>
+	<COL WIDTH=85*>
+	<THEAD>
+		<TR VALIGN=TOP>
+			<TH WIDTH=33%>
+				<P>English</P>
+			</TH>
+			<TH WIDTH=33%>
+				<P>German</P>
+			</TH>
+			<TH WIDTH=33%>
+				<P>Comment</P>
+			</TH>
+		</TR>
+	</THEAD>
+	<TBODY>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P>~Retrieve generated values</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Generierte Werte ~ber&uuml;cksichtigen</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Checkbox to enable this feature</P>
+			</TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P>~Auto-increment statement</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>~Auto-Increment-Ausdruck</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>FixedText which contains the statement which should be
+				appended after each column definition</P>
+			</TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P>~Query of generated values</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Abfrage der generierten ~Werte</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>FixedText which contains the statement which will be called
+				after an &ldquo;INSERT&rdquo; statement</P>
+			</TD>
+		</TR>
+	</TBODY>
+</TABLE>
+<P><BR><BR>
+</P>
+<H3 CLASS="western">Table design</H3>
+<P><IMG SRC="AutoIncrementValues_html_2f28066b.gif" NAME="Graphic2" ALIGN=LEFT WIDTH=642 HEIGHT=372 BORDER=0><BR CLEAR=LEFT><BR><BR>
+</P>
+<TABLE WIDTH=100% BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
+	<COL WIDTH=85*>
+	<COL WIDTH=85*>
+	<COL WIDTH=85*>
+	<THEAD>
+		<TR VALIGN=TOP>
+			<TH WIDTH=33%>
+				<P>English</P>
+			</TH>
+			<TH WIDTH=33%>
+				<P>German</P>
+			</TH>
+			<TH WIDTH=33%>
+				<P>Comment</P>
+			</TH>
+		</TR>
+	</THEAD>
+	<TBODY>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P>Auto-increment statement</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>~Auto-Increment-Ausdruck</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>FixedText which contains the same value as the 2<SUP>nd</SUP>
+				FixedText in data source administration dialog</P>
+			</TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P>Enter an SQL statement for the auto-increment field.\n\nThis
+				statement will be directly transferred to the database when the
+				table is created.</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Geben Sie hier einen SQL Ausdruck f&uuml;r das
+				Auto-Increment-Feld an.\n\nDieser Ausdruck wird beim Erzeugen der
+				Tabelle direkt an die Datenbank &uuml;bertragen.</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>HelpText for this field which appears in the left side control</P>
+			</TD>
+		</TR>
+	</TBODY>
+</TABLE>
+<P><BR><BR>
+</P>
+</BODY>
+</HTML>
\ No newline at end of file

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_2f28066b.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_2f28066b.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_2f28066b.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_m243b4459.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_m243b4459.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_m243b4459.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Conditional Formatting.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Conditional%20Formatting.odt?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Conditional Formatting.odt
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Data_Source_Property_Dialog.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Data_Source_Property_Dialog.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Data_Source_Property_Dialog.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_Registration.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_Registration.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_Registration.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_application.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_application.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_application.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_AssignAlias.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_AssignAlias.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_AssignAlias.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_FieldSelection.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_FieldSelection.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_FieldSelection.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Filtercriteria.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Filtercriteria.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Filtercriteria.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Sorting.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Sorting.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Sorting.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Drag_Drop_DSBrowser.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Drag_Drop_DSBrowser.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/specifications/Drag_Drop_DSBrowser.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/specifications/Drag_Drop_DSBrowser.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,137 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
+<HTML>
+<HEAD>
+	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
+	<TITLE></TITLE>
+	<META NAME="GENERATOR" CONTENT="StarOffice 6.0  (Win32)">
+	<META NAME="AUTHOR" CONTENT="Ocke Janssen">
+	<META NAME="CREATED" CONTENT="20020408;15591366">
+	<META NAME="CHANGEDBY" CONTENT="Ocke Janssen">
+	<META NAME="CHANGED" CONTENT="20020408;16013755">
+	<STYLE>
+	<!--
+		TH P { margin-bottom: 0.21cm; font-style: italic }
+	-->
+	</STYLE>
+</HEAD>
+<BODY LANG="de-DE">
+<H1>Drag and Drop in the Datasource Browser 
+</H1>
+<P>This document shows what should be possible to drag and what
+should be happen when droped inside the datasource browser. 
+</P>
+<TABLE WIDTH=100% BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
+	<COL WIDTH=85*>
+	<COL WIDTH=85*>
+	<COL WIDTH=85*>
+	<THEAD>
+		<TR VALIGN=TOP>
+			<TH WIDTH=33%>
+				<P>Source</P>
+			</TH>
+			<TH WIDTH=33%>
+				<P>Destination</P>
+			</TH>
+			<TH WIDTH=33%>
+				<P>Effect</P>
+			</TH>
+		</TR>
+	</THEAD>
+	<TBODY>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P>Table object</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Table container</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Opens Wizard, whole table and data will be copied. See 1</P>
+			</TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P>Query object</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Table container</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Opens Wizard, whole query (as table or as view) and data will
+				be copied. See 2</P>
+			</TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P>Qurey object</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Query container</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Copies the query object</P>
+			</TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P>Grid-control</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Table container</P>
+			</TD>
+			<TD WIDTH=33%>
+				<P>Opens Wizard, only selection will be copied. See 3</P>
+			</TD>
+		</TR>
+	</TBODY>
+</TABLE>
+<P STYLE="margin-top: 0.42cm; margin-bottom: 0.21cm; page-break-after: avoid">
+<FONT FACE="Albany, sans-serif"><FONT SIZE=4>1 The table object as
+drag source</FONT></FONT></P>
+<P>Inside the datasorce browser, the table object can only be copied
+onto the table container. When copied all properties must also be
+copied. That means that the following properties have to look for if
+they are copied too.</P>
+<UL>
+	<LI><P>Columns</P>
+	<LI><P>Keys</P>
+	<LI><P>Indexes</P>
+	<LI><P>table settings, like color, filter and filter applied,
+	sorting 
+	</P>
+	<LI><P>column settings, like number format</P>
+	<LI><P>and the data</P>
+</UL>
+<P>Outside the datasource browser, the table should be exported in
+HTML and RTF format. Additionally the writer should support extra
+functionality.</P>
+<P STYLE="margin-top: 0.42cm; margin-bottom: 0.21cm; page-break-after: avoid">
+<FONT FACE="Albany, sans-serif"><FONT SIZE=4>2 The query object as
+drag source</FONT></FONT></P>
+<P>The query object can be copied onto the query container. It should
+be a 1:1 copy. All properties have to be copied, the same as for the
+table object. When copied onto the table container, the user could
+choise between a table object to be created or an view object when
+the database supports it.</P>
+<UL>
+	<LI><P>the SQL statement</P>
+	<LI><P>the column settings as by a table</P>
+	<LI><P>the query settings, like color</P>
+</UL>
+<P STYLE="margin-top: 0.42cm; margin-bottom: 0.21cm; page-break-after: avoid">
+<FONT FACE="Albany, sans-serif"><FONT SIZE=4>4 The grid-control as
+drag source</FONT></FONT></P>
+<P>The grid control shows the current selection of the tree view.
+This view can be sorted and filtered. At this reason it is possible
+that the source contains a filter which has to be include when coping
+data. Additionally it is possible to do a multiselection on the rows.
+When this selection is copied on the table container, only the
+selected rows have to be copied and not the whole rows. Another point
+to mention is that the rows must also be dragable to other
+applications like the writer, this is also valid for the column
+header. 
+</P>
+<P><BR><BR>
+</P>
+</BODY>
+</HTML>
\ No newline at end of file

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Drag_Drop_DSBrowser.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Embedded_Database.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Embedded_Database.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Embedded_Database.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Navigator_DnD.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Navigator_DnD.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Navigator_DnD.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Navigator_DnD.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,371 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+	
+  <meta http-equiv="CONTENT-TYPE"
+ content="text/html; charset=windows-1252">
+  <title>Form Navigator Data Exchange Functional Spec</title>
+	 	
+  <meta name="GENERATOR" content="StarOffice 6.0  (Win32)">
+	
+  <meta name="CREATED" content="20020513;14164900">
+	
+  <meta name="CHANGEDBY" content="Frank Schönheit">
+	
+  <meta name="CHANGED" content="20020521;16011356">
+</head>
+<body lang="de-DE">
+<div id="Table of Contents1">
+<div style="text-align: center;"> 	</div>
+<div id="Table of Contents1_Head">
+<div style="text-align: center;"> 		<font size="+3"><span
+ style="font-weight: bold;">Data Exchange in the Form Navigator</span></font><br>
+<font size="+1"><span style="font-style: italic; font-weight: bold;">Functional
+specification</span></font><br>
+</div>
+<br>
+This document describes the data exchange functionality in the form
+navigator. This is the small floater which can be switched on when
+designing a form document, and visualizes the logical structure of the
+form components (forms, sub forms, control models). <br>
+<br>
+Data exchange means Drag and Drop functionality as well as Clipboard
+activities.
+<h2><a name="mozTocId51302" class="mozTocH2"></a>Table 		of Contents</h2>
+	</div>
+	 	 	 	 	
+<ul id="mozToc">
+<!--mozToc h3 3 h4 4 h5 5--><li><a href="#mozTocId975628">1 Acceptance
+Rules</a></li>
+  <ul>
+    <li><a href="#mozTocId24028">1.1 Actions for different Component</a></li>
+    <li><a href="#mozTocId581363">1.2 Move</a></li>
+    <li><a href="#mozTocId244433">1.3 Copy</a></li>
+  </ul>
+    <li><a href="#mozTocId125168">2 Functionality</a>
+      <ul>
+        <li><a href="#mozTocId665767">2.1 Drag and Drop</a>
+          <ul>
+            <li><a href="#mozTocId134648">2.1.1 Activation</a><br></li>
+            <li><a href="#mozTocId658958">2.1.2 Mode selection</a></li>
+          </ul>
+		</li>
+        <li><a href="#mozTocId547415">2.2 Clipboard</a>
+          <ul>
+		    <li><a href="#mozTocId4311">2.2.1 Activation</a></li>
+		    <li><a href="#mozTocId14953">2.2.2 Cutting Entries</a></li>
+          </ul>
+		</li>
+      </ul>
+	</li>
+	<li><a href="#mozTocId620921">3 Clipboard formats</a>
+      <ul>
+        <li><a href="#mozTocId563632">3.1 Hidden controls</a></li>
+        <li><a href="#mozTocId166879">3.2 Control paths</a></li>
+        <li><a href="#mozTocId755191">3.3 Tree list entries</a></li>
+      </ul>
+    </li>
+    <li><a href="#mozTocId320803">4 Test cases</a>
+      <ul>
+        <li><a href="#mozTocId929325">4.1 Hidden controls</a></li>
+        <li><a href="#mozTocId985204">4.2 Non-Hidden Controls</a></li>
+        <li><a href="#mozTocId970357">4.3 More to come .....</a></li>
+      </ul>
+    </li>
+  </ul>
+</ul>
+<p style="margin-bottom: 0cm;"><br>
+</p>
+</div>
+<p class="western"><br>
+</p>
+<h3><a name="mozTocId975628" class="mozTocH3"></a>1 Acceptance Rules</h3>
+<p class="western">When doing a copy or move operation, given a set of
+source components (e.g. the drag source) and a target component (the
+drop target), the operation is rejected according to the rules below. If
+and only neither of the rules applies, the operation is accepted.<br>
+In general and by default, the source can be an arbitrary mixture of
+hidden controls, "normal" controls, and forms, while the destination can
+be any valid entry in the form navigator.</p>
+<h4><a name="mozTocId24028" class="mozTocH4"></a>1.1 Actions for
+different Component</h4>
+<p class="western">Allowed actions differ for the different types of
+components: (hidden/non-hidden controls, and forms). Additionally, there
+is a difference if the data exchange is in-place (within the same
+navigator instance) or if it crosses document boundaries.</p>
+<p class="western">The following table shows the acceptance matrix
+under these aspects.</p>
+<table width="642" border="1" bordercolor="#000000" cellpadding="4"
+ cellspacing="0">
+	<col width="126"> 	<col width="119"> 	<col width="119"> 	<col width="119">
+	<col width="118"> 	<thead> 		<tr valign="top">
+			<th width="126"> 				
+    <p class="western" style="">control \ action</p>
+			</th>
+			<th width="119"> 				
+    <p class="western" style="">copy, in-place</p>
+			</th>
+			<th width="119"> 				
+    <p class="western" style="">move, in-place</p>
+			</th>
+			<th width="119"> 				
+    <p class="western" style="">copy, crossing</p>
+			</th>
+			<th width="118"> 				
+    <p class="western" style="">move, crossing</p>
+			</th>
+		</tr>
+	</thead> 	<tbody>
+		<tr valign="top">
+			<td width="126"> 				
+      <p class="western">hidden control</p>
+			</td>
+			<td width="119"> 				
+      <p class="western" align="center">+</p>
+			</td>
+			<td width="119"> 				
+      <p class="western" align="center">+</p>
+			</td>
+			<td width="119"> 				
+      <p class="western" align="center">+</p>
+			</td>
+			<td width="118"> 				
+      <p class="western" align="center">-</p>
+			</td>
+		</tr>
+		<tr valign="top">
+			<td width="126"> 				
+      <p class="western">non-hidden control</p>
+			</td>
+			<td width="119"> 				
+      <p class="western" align="center">-</p>
+			</td>
+			<td width="119"> 				
+      <p class="western" align="center">+</p>
+			</td>
+			<td width="119"> 				
+      <p class="western" align="center">-</p>
+			</td>
+			<td width="118"> 				
+      <p class="western" align="center">-</p>
+			</td>
+		</tr>
+		<tr valign="top">
+			<td width="126"> 				
+      <p class="western">forms</p>
+			</td>
+			<td width="119"> 				
+      <p class="western" align="center">-</p>
+			</td>
+			<td width="119"> 				
+      <p class="western" align="center">+</p>
+			</td>
+			<td width="119"> 				
+      <p class="western" align="center">-</p>
+			</td>
+			<td width="118"> 				
+      <p class="western" align="center">-</p>
+			</td>
+		</tr>
+	
+  </tbody>
+</table>
+<p class="western"><br>
+<br>
+</p>
+<p class="western">If the source of a data exchange operation contains
+a mixed set of different types, the weakest rules determine the result.
+Means if you mix for instance a hidden control with a form, then the
+acceptance rules for the form apply.</p>
+<p class="western">There are additional rules which may restrict the
+operation even further, they are explained in the next paragraphs.</p>
+<h4><a name="mozTocId581363" class="mozTocH4"></a>1.2 Move</h4>
+<p class="western">In addition to the rules from chapter 1.1, a move
+operation is rejected if one of the following points applies:</p>
+<ol>
+	<li>
+    <p class="western">The target does not exist, i.e. 	the components
+were dropped onto empty space.</p>
+	</li>
+  <li>
+    <p class="western">The root entry is part of the 	source components
+– you can't move the root</p>
+	</li>
+  <li>
+    <p class="western">One of the source components</p>
+	
+    <ol type="a">
+		<li>
+        <p class="western">is a child of the target 		component</p>
+		</li>
+      <li>
+        <p class="western">equals the target component</p>
+		</li>
+      <li>
+        <p class="western">is a form, and at the same time 		an
+ancestor of the target</p>
+		</li>
+      <li>
+        <p class="western">is a control, and the target is 		the root
+component</p>
+	</li>
+    </ol>
+	</li>
+  <li>
+    <p class="western">The target component is a 	control</p>
+  </li>
+</ol>
+<h4><a name="mozTocId244433" class="mozTocH4"></a>1.3 Copy</h4>
+<p class="western">In addition to the rules from chapter 1.1, a copy
+operation is rejected if and only if one of the following points applies:</p>
+<ol>
+	<li>
+    <p class="western">The target does not exist, i.e. 	the components
+were dropped onto empty space.</p>
+	</li>
+  <li>
+    <p class="western">The target component is no form</p>
+  </li>
+</ol>
+<h3><a name="mozTocId125168" class="mozTocH3"></a>2 Functionality</h3>
+<h4><a name="mozTocId665767" class="mozTocH4"></a>2.1 Drag and Drop</h4>
+<h5><a name="mozTocId134648" class="mozTocH5"></a>2.1.1 Activation</h5>
+<p class="western">as usual: Select an arbitrary set of entries in the
+navigator, and start dragging them.</p>
+<h5><a name="mozTocId658958" class="mozTocH5"></a>2.1.2 Mode selection</h5>
+<p class="western">The default mode is "move", i.e. if you do a DnD
+operation without any modifier keys, a move will be triggered.<br>
+You can use the usual platform-dependent (e.g. on Windows: Ctrl)
+modifier key(s) to force copying</p>
+<h4><a name="mozTocId547415" class="mozTocH4"></a>2.2 Clipboard</h4>
+<h5><a name="mozTocId4311" class="mozTocH5"></a>2.2.1 Activation</h5>
+<p class="western">as usual: Select an arbitrary set of entries in the
+navigator, open the context menu (no matter if by mouse or keyboard),
+and choose "Copy" or "Cut" therein. Alternatively, press the usual,
+platform-dependent keyboard shortcuts (e.g. on Windows: Ctrl-C for copy,
+Ctrl-X for cut).</p>
+<p class="western" style="font-style: normal;">The Paste aka Insert
+functionality is reachable when via context menu and usual shortcut,
+too. It is not available if no entry is selected, if more than one entry
+is selected, or if the selected entry does not fullfill the acceptance
+rules from chapter 1.</p>
+<h5><a name="mozTocId14953" class="mozTocH5"></a>2.2.2 Cutting Entries</h5>
+<p class="western">If you started a cut, the entries in question will
+get a brighter icon, indicating that they are to be moved once the move
+operation is finished. This means they are not removed from the model
+when you do the cut, but only when you do the paste from the clipboard.</p>
+<h3><a name="mozTocId620921" class="mozTocH3"></a>3 Clipboard formats</h3>
+<p class="western">This chapter is for completeness. It describes the
+internal clipboard formats used.</p>
+<p class="western">The following formats are used for transfering data
+within one or more instances of the form navigator.</p>
+<h4><a name="mozTocId563632" class="mozTocH4"></a>3.1 Hidden controls</h4>
+<ul>
+	<li>
+    <p class="western">format name:
+	application/x-openoffice;windows_formatname="svxform.HiddenControlModelsExchange"</p>
+	</li>
+  <li>
+    <p class="western" style="font-style: normal;">content: 	a
+Sequence&lt; XPropertySet &gt;, denoting the models of the hidden
+	controls to transfer</p>
+  </li>
+</ul>
+<h4><a name="mozTocId166879" class="mozTocH4"></a>3.2 Control paths</h4>
+<ul>
+	<li>
+    <p class="western">format 	name:
+	application/x-openoffice;windows_formatname="svxform.ControlPathExchange"</p>
+	</li>
+  <li>
+    <p class="western" style="font-style: normal;"> 	content:
+Sequence&lt; Any &gt;, 2 elements</p>
+	
+    <ul>
+		<li>
+        <p class="western" style="font-style: normal;"> 		first element:
+Reference&lt; XNameContainer &gt; which 		represents the collections of
+all forms</p>
+		</li>
+      <li>
+        <p class="western" style="font-style: normal;"> 		second
+element: Sequence&lt; Sequence&lt; int &gt; &gt;: 		Every element
+describes a "path“ to a control model, 		relative to the container in
+the container above.<br>
+        <br>
+E.g., if 		the sequence is "( ( 0, 2 ), (1, 3, 2) )", then two
+		elements with the paths "(0, 2)" and "(1, 3, 2)" 		are described.
+Means the first element is the third (2!) children 		of the first (0!)
+children of the container, and the second element 		is the third
+children of the forth children of the second children 		of the container.</p>
+	</li>
+    </ul>
+  </li>
+</ul>
+<h4><a name="mozTocId755191" class="mozTocH4"></a>3.3 Tree list entries</h4>
+<ul>
+	<li>
+    <p class="western">format name:
+	application/x-openoffice;windows_formatname="svxform.FieldNameExchange"</p>
+	</li>
+  <li> content: 	Virtually nothing :). This is not really transfered via
+the usual 	exchange mechanisms, it is just a shortcut for instances
+where the 	drag source is the same as the drop target; in this case the
+latter 	does not need to rebuild all the internal information from the
+	persistent format 2.<br>
+In particular, this means the format does 	not supply data, it acts as
+placeholder only. </li>
+</ul>
+<h3><a name="mozTocId320803" class="mozTocH3"></a>4 Test cases</h3>
+<h4><a name="mozTocId929325" class="mozTocH4"></a>4.1 Hidden controls</h4>
+<ul>
+	<li>
+    <p class="western">Create a form containing a hidden control.
+	Create a new sub form below the first form.</p>
+	
+    <ul>
+		<li>
+        <p class="western">Try to DnD this control to itself, to it's
+		parent, to the sub form, to a free place in the navigator. Check
+		that moving is allowed (and works) on the sub form, and nowhere 		else.</p>
+		</li>
+      <li>
+        <p class="western">Try the same actions with the first modifier
+		key (Ctrl). This should be a copy operation, thus it should be
+		allowed (and work) on the forms, but nowhere else.</p>
+	</li>
+    </ul>
+	</li>
+  <li>
+    <p class="western">Create a second document, and a form therein</p>
+	
+    <ul>
+		<li>
+        <p class="western">Try to DnD the hidden control from the first
+		document to the form in the second document. Only copying to a form
+		should work.</p>
+	</li>
+    </ul>
+  </li>
+</ul>
+<h4><a name="mozTocId985204" class="mozTocH4"></a>4.2 Non-Hidden
+Controls</h4>
+<ul>
+	<li>
+    <p class="western">Create a form with some controls (except than
+	hidden controls)</p>
+	
+    <ul>
+		<li>
+        <p class="western">mark an arbitrary set of controls, and try
+		to DnD them in the navigator. Should be refused all times: Movement
+		is not allowed (as the only existent form is the parent of the
+		controls), and copy is not allowed in general for non-hidden
+		controls.</p>
+	</li>
+    </ul>
+  </li>
+</ul>
+<h4><a name="mozTocId970357" class="mozTocH4"></a>4.3 More to come .....</h4>
+</body>
+</html>

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Navigator_DnD.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Save_Dialog_Spec.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Save_Dialog_Spec.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Save_Dialog_Spec.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Function_Property_Browser.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Function_Property_Browser.odt?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Function_Property_Browser.odt
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Ldap_authentication.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Ldap_authentication.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Ldap_authentication.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Link_CSV_Text_files_into_HSQL_databases.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Link_CSV_Text_files_into_HSQL_databases.odt?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Link_CSV_Text_files_into_HSQL_databases.odt
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,245 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
+<HTML>
+<HEAD>
+	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
+	<TITLE>MySQL driver page</TITLE>
+	<META NAME="GENERATOR" CONTENT="StarOffice 6.0  (Win32)">
+	<META NAME="AUTHOR" CONTENT="Ocke Janssen">
+	<META NAME="CREATED" CONTENT="20020306;7403200">
+	<META NAME="CHANGEDBY" CONTENT="Ocke Janssen">
+	<META NAME="CHANGED" CONTENT="20021122;10010893">
+</HEAD>
+<BODY LANG="en-US" LINK="#0000cc">
+<P ALIGN=CENTER><FONT FACE="Albany"><FONT SIZE=5><B>MySQL driver page</B></FONT></FONT></P>
+<P ALIGN=CENTER><FONT FACE="Albany"><FONT SIZE=3><I><SPAN LANG="en-US">applies</SPAN>
+to StarOffice 6.1 <BR>status: finished, last modified: <SDFIELD TYPE=DOCINFO SUBTYPE=CHANGE FORMAT=DATE SDNUM="1033;1033;D. MMM. YYYY">22. Nov. 2002</SDFIELD></I></FONT></FONT></P>
+<H1><FONT FACE="Albany"><FONT SIZE=4>Version History</FONT></FONT></H1>
+<TABLE WIDTH=586 BORDER=1 CELLPADDING=4 CELLSPACING=0 FRAME=HSIDES RULES=ROWS>
+	<COL WIDTH=99>
+	<COL WIDTH=32>
+	<COL WIDTH=129>
+	<COL WIDTH=294>
+	<THEAD>
+		<TR>
+			<TD WIDTH=99 VALIGN=BOTTOM SDVAL="37570" SDNUM="1033;0;MM/DD/YY">
+				<P ALIGN=RIGHT><FONT FACE="Albany"><FONT SIZE=2>11/10/02</FONT></FONT></TD>
+			<TD WIDTH=32 VALIGN=TOP>
+				<P ALIGN=LEFT><BR>
+			</TD>
+			<TD WIDTH=129 VALIGN=TOP>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Ocke Janssen</FONT></FONT></TD>
+			<TD WIDTH=294 VALIGN=TOP>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>first draft</FONT></FONT></TD>
+		</TR>
+	</THEAD>
+	<TBODY>
+		<TR>
+			<TD WIDTH=99 VALIGN=BOTTOM SDVAL="37581" SDNUM="1033;0;MM/DD/YY">
+				<P ALIGN=RIGHT><FONT FACE="Albany"><FONT SIZE=2>11/21/02</FONT></FONT></TD>
+			<TD WIDTH=32 VALIGN=TOP>
+				<P ALIGN=LEFT><BR>
+			</TD>
+			<TD WIDTH=129 VALIGN=TOP>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Elizabeth Matthis</FONT></FONT></TD>
+			<TD WIDTH=294 VALIGN=TOP>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>GUI string review</FONT></FONT></TD>
+		</TR>
+	</TBODY>
+</TABLE>
+<H1><FONT FACE="Albany"><FONT SIZE=4>Abstract</FONT></FONT></H1>
+<P ALIGN=JUSTIFY><FONT FACE="Thorndale">To create a new data source
+with the new MySQL driver, the data source administration dialog must
+be extended. A new page will be inserted where the user can fill in
+all necessary   information which are needed to connect to a  MySQL
+database.</FONT></P>
+<DIV ID="Table of Contents1">
+	<DIV ID="Table of Contents1_Head">
+		<H1><FONT FACE="Albany"><FONT SIZE=4>Contents</FONT></FONT></H1>
+	</DIV>
+	<DL>
+		<DT><FONT FACE="Albany"><FONT SIZE=2>1  MySQL driver page	1</FONT></FONT><DT>
+		<FONT FACE="Albany"><FONT SIZE=2>1.1  The driver page in detail	1</FONT></FONT><DT>
+		<FONT FACE="Albany"><FONT SIZE=2>1.2  String List	1</FONT></FONT></DL>
+</DIV>
+<H1><FONT FACE="Albany"><FONT SIZE=4>1  MySQL driver page</FONT></FONT></H1>
+<P ALIGN=JUSTIFY><FONT FACE="Thorndale">The new driver page fort
+MySQL allows the user to select between two different kinds of 'how
+to connect to the MySQL database'. The first possibility is to use an
+existing MyODBC<A CLASS="sdfootnoteanc" NAME="sdfootnote1anc" HREF="#sdfootnote1sym"><SUP>1</SUP></A>
+data source which must be defined in the used system. The second kind
+is to use the JDBC<A CLASS="sdfootnoteanc" NAME="sdfootnote2anc" HREF="#sdfootnote2sym"><SUP>2</SUP></A>
+version from MySQL named &ldquo;connector/J&rdquo;. </FONT>
+</P>
+<H2><FONT FACE="Albany"><FONT SIZE=4>1.1  The driver page in detail</FONT></FONT></H2>
+<P ALIGN=JUSTIFY><IMG SRC="./MySQL_data_source_page_html_17ee6536.gif" NAME="Rahmen1" ALT="Rahmen1" ALIGN=LEFT HSPACE=8 VSPACE=8><BR CLEAR=LEFT><FONT FACE="Thorndale">In
+the first group box the user can select which kind of connection he
+would like to use. Either an existing ODBC data source which must be
+defined in the used system or to connect to the database via the JDBC
+interface. To allow the user to specify different driver classes, an
+extra edit field is enabled when the JDBC was selected, where the
+name of the driver class can be inserted<A CLASS="sdfootnoteanc" NAME="sdfootnote3anc" HREF="#sdfootnote3sym"><SUP>3</SUP></A>.
+In the second group box  information about the data source, the user
+name, if a password is required and which character set the MySQL
+server should use, can be defined. The URL field contains different
+meaning depending on the type of connection. In the case of ODBC, it
+contains the name of the ODBC data source; in the case of JDBC it
+contains the host name, a port number and the database name. To give
+the user a hint, the URL field will contain a default value for a
+JDBC kind of connection, where the user has to substitute only the
+fields in the brackets.</FONT></P>
+<H2><FONT FACE="Albany"><FONT SIZE=4>1.2  String List</FONT></FONT></H2>
+<TABLE WIDTH=100% BORDER=1 CELLPADDING=4 CELLSPACING=0>
+	<COL WIDTH=85*>
+	<COL WIDTH=85*>
+	<COL WIDTH=85*>
+	<THEAD>
+		<TR VALIGN=TOP>
+			<TH WIDTH=33%>
+				<P><FONT FACE="Albany"><FONT SIZE=2>String</FONT></FONT></TH>
+			<TH WIDTH=33%>
+				<P><FONT FACE="Albany"><FONT SIZE=2>German translation</FONT></FONT></TH>
+			<TH WIDTH=33%>
+				<P><FONT FACE="Albany"><FONT SIZE=2>comment</FONT></FONT></TH>
+		</TR>
+	</THEAD>
+	<TBODY>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Type of connection</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P><FONT FACE="Albany"><FONT SIZE=2>Art der Verbindung</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Fixed line;
+				Separates the kind of connection from the general information. No
+				mnemonic necessary.</FONT></FONT></TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Use existing
+				My~ODBC data source</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P><FONT FACE="Albany"><FONT SIZE=2>Existierende My~ODBC
+				Datenquelle verwenden</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Radio button
+				label; Will be marked by the user when he wants to use an
+				existing ODBC system data source. &ldquo;MyODBC&rdquo; is product
+				name and not to translate.</FONT></FONT></TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Use Connector/~J3</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Connector/~J3
+				verwenden</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Radio button
+				label; Connector/J3 is the JDBC driver from MySQL. Do not
+				translate or change &ldquo;Connector/J3&rdquo;-- it is a product
+				name.</FONT></FONT></TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>MySQL JDBC d~river
+				class</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>MySQL JDBC
+				~Treiberklasse</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>The label for the
+				edit (text box), where the user can insert the JDBC driver class
+				for MySQL</FONT></FONT></TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>General</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Allgemein</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Fixed line; A
+				separator. No mnemonic necessary.</FONT></FONT></TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Data source URL</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>D~atenquellen-URL</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Text box label;
+				The url for the connection.</FONT></FONT></TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~User name</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Benutzername</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Text box label;
+				The user name needed to connect to the  database.</FONT></FONT></TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Password r~equired</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Kennwort
+				~erforderlich</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Check box label;
+				Indicates that a password is needed to connect to the database.</FONT></FONT></TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Character set</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Zeichensatz</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Text box label;
+				The character set.</FONT></FONT></TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>&lt;host&gt;:&lt;3306&gt;/&lt;DBNAME&gt;</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>&lt;Rechnername&gt;:&lt;3306&gt;/&lt;DBNAME&gt;</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>String; will be
+				inserted into the URL field when choosing the Connector/J3 to
+				give the user a clue about what is needed.</FONT></FONT></TD>
+		</TR>
+		<TR VALIGN=TOP>
+			<TH WIDTH=33%>
+				<P><BR>
+			</TH>
+			<TH WIDTH=33%>
+				<P><FONT FACE="Albany"><FONT SIZE=2>General Page</FONT></FONT></TH>
+			<TH WIDTH=33%>
+				<P><BR>
+			</TH>
+		</TR>
+		<TR VALIGN=TOP>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>To adjust the
+				settings, go to the MySQL tab page.</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Wechseln Sie zur
+				MySQL-Registerseite um die Einstellungen vorzunehmen.</FONT></FONT></TD>
+			<TD WIDTH=33%>
+				<P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>This text will be
+				shown on the general page when the type MySQL is selected.</FONT></FONT></TD>
+		</TR>
+	</TBODY>
+</TABLE>
+<P ALIGN=JUSTIFY><BR><BR>
+</P>
+<DIV ID="sdfootnote1">
+	<P><FONT FACE="Thorndale"><FONT SIZE=2><A CLASS="sdfootnotesym" NAME="sdfootnote1sym" HREF="#sdfootnote1anc">1</A>Open
+	database connectivity</FONT></FONT></DIV>
+<DIV ID="sdfootnote2">
+	<P><FONT FACE="Thorndale"><FONT SIZE=2><A CLASS="sdfootnotesym" NAME="sdfootnote2sym" HREF="#sdfootnote2anc">2</A>Java
+	database connectivity</FONT></FONT></DIV>
+<DIV ID="sdfootnote3">
+	<P><FONT FACE="Thorndale"><FONT SIZE=2><A CLASS="sdfootnotesym" NAME="sdfootnote3sym" HREF="#sdfootnote3anc">3</A>The
+	driver class will be searched for in the jar files which can be
+	added under tools-&gt;options-&gt;Security.</FONT></FONT></DIV>
+</BODY>
+</HTML>

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page_html_17ee6536.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page_html_17ee6536.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page_html_17ee6536.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/ProgressPanel.bmp
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/ProgressPanel.bmp?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/ProgressPanel.bmp
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Queries_in_Queries_.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Queries_in_Queries_.odt?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Queries_in_Queries_.odt
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/ReportDesigner.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/ReportDesigner.odt?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/ReportDesigner.odt
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Thunderbird_ab.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Thunderbird_ab.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Thunderbird_ab.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Database.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Database.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Database.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Form.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Form.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Form.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Query.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Query.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Query.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Report.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Report.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Report.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Table.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Table.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Table.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Write_Access_To_AddressBooks.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Write_Access_To_AddressBooks.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Write_Access_To_AddressBooks.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/ab_architecture.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/ab_architecture.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/ab_architecture.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif



Mime
View raw message