You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@isis.apache.org by ke...@apache.org on 2012/03/23 18:45:56 UTC
svn commit: r1304526 -
/incubator/isis/trunk/framework/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml
Author: kevin
Date: Fri Mar 23 17:45:56 2012
New Revision: 1304526
URL: http://svn.apache.org/viewvc?rev=1304526&view=rev
Log:
ISIS-219: Updated documentation to indicate use.
Modified:
incubator/isis/trunk/framework/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml
Modified: incubator/isis/trunk/framework/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml
URL: http://svn.apache.org/viewvc/incubator/isis/trunk/framework/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml?rev=1304526&r1=1304525&r2=1304526&view=diff
==============================================================================
--- incubator/isis/trunk/framework/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml (original)
+++ incubator/isis/trunk/framework/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml Fri Mar 23 17:45:56 2012
@@ -212,7 +212,7 @@
</simplelist></para>
<para><simplelist>
- <member>isis.persistor.sql.datatypes.password (VARCHAR(12))
+ <member>isis.persistor.sql.datatypes.password (VARCHAR(120))
[Password]</member>
</simplelist></para>
@@ -419,6 +419,41 @@
<para><property>isis.persistor.sql.default.versioning.members=false</property></para>
</sect1>
+
+ <sect1>
+ <title>Password values</title>
+
+ <para>The <code>JdbcPasswordValueMapper</code> value mapper has the
+ ability to (weakly) encode the password value strings stored in the
+ database tables.</para>
+
+ <para>By adding the following property values:</para>
+
+ <blockquote>
+ <para><property>isis.persistor.sql.default.password.seed=<random
+ string></property></para>
+
+ <para><property>isis.persistor.sql.default.password.length=<integer
+ length></property></para>
+ </blockquote>
+
+ <para>You can enable a weak password encoding/decoding scheme that will
+ obscure password values from casual browsers of your database
+ tables.</para>
+
+ <para>The length of all stored passwords is the same, and determined by
+ the <property>isis.persistor.sql.default.password.length</property>
+ property. This length must not exceed the SQL storage, as defined in
+ <xref linkend="sec.mappers.modifiable-values" />.</para>
+
+ <para>The passwords are convolved with the value of the string given by
+ the <property>isis.persistor.sql.default.password.seed</property>
+ property, and the resulting string is stored in the database
+ table.</para>
+
+ <para>If <property>isis.persistor.sql.default.password.seed</property>
+ is undefined (null), the passwords are stored as plain text.</para>
+ </sect1>
</chapter>
<chapter id="ch.supported.dbs">
@@ -505,8 +540,26 @@
<sect2>
<title>Microsoft SQL Server 2008</title>
- <para>Missing. Tested at the office, documentation at home!
- Argh.</para>
+ <para>The sourceforge driver seemed to work well enough for
+ testing.</para>
+
+ <para>The tested connection parameters were:</para>
+
+ <para><blockquote>
+ <para># SQL Server </para>
+
+ <para>#isis.persistence.sql.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver</para>
+
+ <para>isis.persistence.sql.jdbc.driver=net.sourceforge.jtds.jdbc.Driver</para>
+
+ <para>isis.persistence.sql.jdbc.connection=jdbc:jtds:sqlserver://<server>;databaseName=<database></para>
+
+ <para>isis.persistence.sql.jdbc.user=<user></para>
+
+ <para>isis.persistence.sql.jdbc.password=<password></para>
+ </blockquote></para>
+
+ <para></para>
</sect2>
<sect2>
@@ -514,7 +567,23 @@
<para>Beware! This version of DB2 has a very small limit on table and
column names. You will have to keep your domain class and property
- names short to suit, especially collections (see ..).</para>
+ names short to suit, especially collections!</para>
+
+ <para>The tested connection parameters were:</para>
+
+ <blockquote>
+ <para># DB2 test</para>
+
+ <para>
+ isis.persistence.sql.jdbc.driver=com.ibm.db2.jcc.DB2Driver</para>
+
+ <para>
+ isis.persistence.sql.jdbc.connection=jdbc:db2://<host>:50000/<database></para>
+
+ <para> isis.persistence.sql.jdbc.user=<user></para>
+
+ <para> isis.persistence.sql.jdbc.password=<password></para>
+ </blockquote>
</sect2>
</sect1>
@@ -547,15 +616,14 @@
</listitem>
<listitem>
- <para>blah Time, DateTime (DATETIME), java.sql.Time,
- java.util.Date, java.sql.Timestamp (DATETIME), TimeStamp
- (DATETIME) blah</para>
+ <para>Time, DateTime (DATETIME), java.sql.Time, java.util.Date,
+ java.sql.Timestamp (DATETIME), TimeStamp (DATETIME) blah</para>
</listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>blah</para>
+ <para></para>
</listitem>
</itemizedlist>