cvs commit: jakarta-turbine/xdocs/howto mssql-howto.xml

[dj...@apache.org]

djpolito    01/07/09 13:35:18

  Added:       xdocs/howto mssql-howto.xml
  Log:
  Created MS SQL Server Howto based on
  Finn Smith's email message, subject:Turbine & MS SQL Server Howto.
  
  David Polito
  
  Revision  Changes    Path
  1.1                  jakarta-turbine/xdocs/howto/mssql-howto.xml
  
  Index: mssql-howto.xml
  ===================================================================
  <?xml version="1.0"?>
  <document>
  
   <properties>
   <title>Microsoft SQL Server&#x99; Howto</title>
   <author email="djpolito@apache.org"></author>
  </properties>
  
  <body>
  
  <section name="Microsoft SQL Server&#x99; Howto">
  
  <p>
  This howto contains configuration help on using MS SQL Server with Turbine.
  This Howto supplements the <a href="..\howto\tdk-howto.html">TDK Howto</a> page.
  </p>
  
  <p>
  We appreciate all <a href="http://jakarta.apache.org/site/source.html">patches
  and contributions</a> that improve this document.
  </p>
  
  </section>
  
  <section name="Create Microsoft SQL Server&#x99; Database">
  <p>
  Use the SQL Server Enterprise Manager to create the database. When using the TDK,
  it helps to name the database the same name as your project. If the name is not
  the same, you will need to manually change the database name in your properties
  files. After the database is created, you will need to create a new user, or
  give an existing user permissions to the new database. Create the new user with
  SQL Server Authentication, and assign the users default database to the newly
  created database. Make sure the database user has the db_owner role. Please
  refer to SQL Server documentation for further details.
  </p>
  
  </section>
  <section name="JDBC Driver">
  <p>
  Microsoft does not have a JDBC driver for MS SQL Server. You will need to
  either select from a commercial driver, see
  <a href="http://industry.java.sun.com/products/jdbc/drivers">JDBC(TM)
  Technology - Drivers</a>, the JDBC-ODBC bridge driver from Sun, or a free
  driver from <a href="http://www.freetds.org">FreeTDS</a>.
  </p>
  
  <p>
  The driver from FreeTDS, as of version 0.51, is unstable and buggy, and not
  recommended for production environments. Use at your own risk.
  </p>
  
  <p>
  The JDBC-ODBC bridge driver from Sun is included with the Java 2 SDK
  Standard Edition as package sun.jdbc.odbc. Sun's statement on this driver is,
  &quot;Note that the bridge driver included in the SDK is appropriate only for
  experimental use or when no other driver is available.&quot; So use at your own
  risk. Also, if you are using a non-windows box to run Turbine, you will need to
  find ODBC drivers for SQL server for that platform. For UNIX environments, you
  can use <a href="http://www.odbc.org">unixODBC</a>. Please follow the ODBC
  driver instructions and setup a DSN for the new database.
  </p>
  
  </section>
  <section name="Edit properity files">
  <p>
  In the ...\WEB-INF\build\build.properties file make sure that;
  </p>
  
  <source><![CDATA[
  database=mssql
  database.manual.creation = true
  ]]></source>
  
  <p>
  And set the JDBC connection information;
  </p>
  
  <source><![CDATA[
  databaseDriver = [JDBC Driver]
  databaseUser = [db username]
  databasePassword = [db password]
  databaseHost = [hostname]
  databaseUrl = [Follow JDBC Driver Docs]
  ]]></source>
  
  <p>
  If you are using the JDBC-ODBC bridge driver then;
  </p>
  
  <source><![CDATA[
  databaseUrl = jdbc:odbc:[DSN Name]
  databaseHost = [hostname]
  databaseDriver = sun.jdbc.odbc.JdbcOdbcDriver
  databaseUser = [db username]
  databasePassword = [db password]
  ]]></source>
  
  <p>
  In the ..\WEB-INF\conf\TurbineResources.properties file, set;
  </p>
  
  <source><![CDATA[
  services.DatabaseService.database.adaptor=DBMSSQL
  services.DatabaseService.database.adaptor.DBMSSQL=[JDBC Driver]
  ]]></source>
  
  
  </section>
  
  </body>
  </document>
  
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org