You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by dj...@apache.org on 2001/07/09 22:34:46 UTC
cvs commit: jakarta-turbine/docs/howto mssql-howto.html
djpolito 01/07/09 13:34:45
Added: docs/howto mssql-howto.html
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/docs/howto/mssql-howto.html
Index: mssql-howto.html
===================================================================
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- Content Stylesheet for Site -->
<!-- start the processing -->
<!-- ====================================================================== -->
<!-- Main Page Section -->
<!-- ====================================================================== -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<meta name="author" value="">
<meta name="email" value="djpolito@apache.org">
<title>Turbine - Microsoft SQL Server� Howto</title>
</head>
<body bgcolor="#ffffff" text="#000000" link="#525D76">
<table border="0" width="100%" cellspacing="0">
<!-- TOP IMAGE -->
<tr>
<td align="left">
<a href="http://jakarta.apache.org"><img src="http://jakarta.apache.org/images/jakarta-logo.gif" border="0"/></a>
</td>
<td align="right">
<a href="http://jakarta.apache.org/turbine/"><img src="../images/logo.gif" alt="Turbine" border="0"/></a>
</td>
</tr>
</table>
<table border="0" width="100%" cellspacing="4">
<tr><td colspan="2">
<hr noshade="" size="1"/>
</td></tr>
<tr>
<!-- LEFT SIDE NAVIGATION -->
<td valign="top" nowrap="true">
<p><strong>Essentials</strong></p>
<ul>
<li> <a href="../index.html">Overview</a>
</li>
<li> <a href="../features.html">Features</a>
</li>
<li> <a href="../fsd.html">Specification</a>
</li>
<li> <a href="../getting-started.html">Getting Started</a>
</li>
<li> <a href="../further-reading.html">Further Reading</a>
</li>
</ul>
<p><strong>Get Involved</strong></p>
<ul>
<li> <a href="../contributors.html">Contributors</a>
</li>
<li> <a href="http://jakarta.apache.org/site/cvsindex.html">CVS Repos</a>
</li>
<li> <a href="../faq.html">FAQ</a>
</li>
<li> <a href="http://jakarta.apache.org/site/mail.html">Mailing Lists</a>
</li>
<li> <a href="../powered.html">Powered by Turbine</a>
</li>
<li> <a href="../license.html">License</a>
</li>
<li> <a href="../issue-tracking.html">Issue Tracking</a>
</li>
</ul>
<p><strong>Documentation</strong></p>
<ul>
<li> <a href="../turbine-documentation-project.html">Turbine Documentation</a>
</li>
<li> <a href="../turbine-schema.html">Core Schema</a>
</li>
<li> <a href="../j2ee-integration.html">J2EE Integration</a>
</li>
<li> <a href="../model2+1.html">Model 2+1</a>
</li>
<li> <a href="../pullmodel.html">Pull MVC Model</a>
</li>
<li> <a href="../comma-dot-slash.html">Comma Dot Slash</a>
</li>
<li> <a href="../services.html">Services</a>
</li>
</ul>
<p><strong>Howto Guides</strong></p>
<ul>
<li> <a href="../howto/action-event-howto.html">Action Events Howto</a>
</li>
<li> <a href="../howto/criteria-howto.html">Criteria Howto</a>
</li>
<li> <a href="../howto/jboss-howto.html">JBoss Howto</a>
</li>
<li> <a href="../howto/jsp-howto.html">JSP Howto</a>
</li>
<li> <a href="../howto/mssql-howto.html">MS SQL Server Howto</a>
</li>
<li> <a href="../howto/oracle-howto.html">Oracle 8i Howto</a>
</li>
<li> <a href="../howto/peers-howto.html">Peers Howto</a>
</li>
<li> <a href="../howto/postgres-howto.html">Postgres Howto</a>
</li>
<li> <a href="../howto/python-howto.html">Python Howto</a>
</li>
<li> <a href="../howto/security-howto.html">Security Howto</a>
</li>
<li> <a href="../howto/sybase-howto.html">Sybase Howto</a>
</li>
<li> <a href="../howto/tdk-howto.html">TDK Howto</a>
</li>
<li> <a href="../howto/torque-howto.html">Torque Howto</a>
</li>
<li> <a href="../howto/velocity-site-howto.html">Velocity Site Howto</a>
</li>
<li> <a href="../howto/context-howto.html">Velocity Context Howto</a>
</li>
<li> <a href="../howto/webmacro-site-howto.html">Webmacro Site Howto</a>
</li>
</ul>
<p><strong>Development</strong></p>
<ul>
<li> <a href="../active-developers.html">Active Developers</a>
</li>
<li> <a href="../changes.html">Changes</a>
</li>
<li> <a href="../code-standards.html">Coding Specification</a>
</li>
<li> <a href="../branches.html">CVS Branches</a>
</li>
<li> <a href="../db-adapters.html">DB Adapters</a>
</li>
<li> <a href="../deprecation.html">Deprecation Rules</a>
</li>
<li> <a href="../project-map.html">Project Map</a>
</li>
<li> <a href="../proposals.html">Proposals</a>
</li>
<li> <a href="../todo.html">Todo</a>
</li>
</ul>
</td>
<td align="left" valign="top">
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<tr><td bgcolor="#525D76">
<font color="#ffffff" face="arial,helvetica,sanserif">
<a name="Microsoft SQL Server� Howto"><strong>Microsoft SQL Server� Howto</strong></a>
</font>
</td></tr>
<tr><td><br/></td></tr>
<tr><td>
<blockquote>
<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>
</blockquote>
</p>
</td></tr>
<tr><td><br/></td></tr>
</table>
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<tr><td bgcolor="#525D76">
<font color="#ffffff" face="arial,helvetica,sanserif">
<a name="Create Microsoft SQL Server� Database"><strong>Create Microsoft SQL Server� Database</strong></a>
</font>
</td></tr>
<tr><td><br/></td></tr>
<tr><td>
<blockquote>
<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>
</blockquote>
</p>
</td></tr>
<tr><td><br/></td></tr>
</table>
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<tr><td bgcolor="#525D76">
<font color="#ffffff" face="arial,helvetica,sanserif">
<a name="JDBC Driver"><strong>JDBC Driver</strong></a>
</font>
</td></tr>
<tr><td><br/></td></tr>
<tr><td>
<blockquote>
<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,
"Note that the bridge driver included in the SDK is appropriate only for
experimental use or when no other driver is available." 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>
</blockquote>
</p>
</td></tr>
<tr><td><br/></td></tr>
</table>
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<tr><td bgcolor="#525D76">
<font color="#ffffff" face="arial,helvetica,sanserif">
<a name="Edit properity files"><strong>Edit properity files</strong></a>
</font>
</td></tr>
<tr><td><br/></td></tr>
<tr><td>
<blockquote>
<p>
In the ...\WEB-INF\build\build.properties file make sure that;
</p>
<div align="left">
<table cellspacing="4" cellpadding="0" border="0">
<tr>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
<tr>
<td bgcolor="#023264" width="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#ffffff"><pre>
database=mssql
database.manual.creation = true
</pre></td>
<td bgcolor="#023264" width="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
<tr>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
</table>
</div>
<p>
And set the JDBC connection information;
</p>
<div align="left">
<table cellspacing="4" cellpadding="0" border="0">
<tr>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
<tr>
<td bgcolor="#023264" width="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#ffffff"><pre>
databaseDriver = [JDBC Driver]
databaseUser = [db username]
databasePassword = [db password]
databaseHost = [hostname]
databaseUrl = [Follow JDBC Driver Docs]
</pre></td>
<td bgcolor="#023264" width="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
<tr>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
</table>
</div>
<p>
If you are using the JDBC-ODBC bridge driver then;
</p>
<div align="left">
<table cellspacing="4" cellpadding="0" border="0">
<tr>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
<tr>
<td bgcolor="#023264" width="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#ffffff"><pre>
databaseUrl = jdbc:odbc:[DSN Name]
databaseHost = [hostname]
databaseDriver = sun.jdbc.odbc.JdbcOdbcDriver
databaseUser = [db username]
databasePassword = [db password]
</pre></td>
<td bgcolor="#023264" width="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
<tr>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
</table>
</div>
<p>
In the ..\WEB-INF\conf\TurbineResources.properties file, set;
</p>
<div align="left">
<table cellspacing="4" cellpadding="0" border="0">
<tr>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
<tr>
<td bgcolor="#023264" width="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#ffffff"><pre>
services.DatabaseService.database.adaptor=DBMSSQL
services.DatabaseService.database.adaptor.DBMSSQL=[JDBC Driver]
</pre></td>
<td bgcolor="#023264" width="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
<tr>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
<td bgcolor="#023264" width="1" height="1"><img src="/images/void.gif" width="1" height="1" vspace="0" hspace="0" border="0"/></td>
</tr>
</table>
</div>
</blockquote>
</p>
</td></tr>
<tr><td><br/></td></tr>
</table>
</td>
</tr>
<!-- FOOTER -->
<tr><td colspan="2">
<hr noshade="" size="1"/>
</td></tr>
<tr><td colspan="2">
<div align="center"><font color="#525D76" size="-1"><em>
Copyright © 1999-2001, Apache Software Foundation
</em></font></div>
</td></tr>
</table>
</body>
</html>
<!-- end the processing -->
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org