You can also find more information in the MS SQL Server Howto
that was added to the web site last week:
http://jakarta.apache.org/turbine/howto/mssql-howto.html
-Eric
On Thursday, July 12, 2001, at 03:55 AM, Pere Torrodellas wrote:
> ----- Mensaje original -----
> De: Santosh Thakur <[EMAIL PROTECTED]>
> Para: <[EMAIL PROTECTED]>
> Enviado: jueves 12 de julio de 2001 9:12
> Asunto: Can turbine be connected to Sql server?
>
>
> It certainly can. We did it by using the sybase definitions, because
> they are
> mostly (if not all ?) compatible, and it works.
>
> Alternatively, the following is an append by Finn Smith that explains
> how to do
> it properly (you would have found it in the mailing list much sooner):
>
> --------------------------------------------
>
> Here's a document that should be useful for new users with Windows who
> want
> to get TDK 2.1 up and running with MS SQL Server. It should be relevant
> until the small template changes are made for later releases (maybe in
> 2.1.1?). It contains everything you need to get TDK 2.1 running on
> Windows.
> It assumes you are working with the "TDK Howto" page on the turbine
> website.
>
> This document is specifically about JDK 1.2.1, TDK 2.1, MS SQL Server
> 7.0
> and the JSQLConnect 2.25 driver from NetDirect <http://www.j-
> netdirect.com/>
> (they have a free 30 day trial for the driver). All of these are
> running on
> Windows. The assumption here is that you're using the default webapp
> name of
> "newapp".
>
> Follow the instructions in the TDK Howto. However, before step 3 (i.e.
> before you run ant) under "Creating your first Turbine application" do
> the
> following:
>
> in the file <tdk
> root>/share/conf/torque/templates/sql/base/mssql/unique.vm
> :
> Remove the blank line at the end of this file. It should now be just
> three lines long.
>
> in the directory <tdk root>/share/conf/database/ :
> Create a text file named mssql. Put the following line in it:
> database.adaptor = DBMSSQL
>
> in the file <tdk root>/share/sample/conf/newapp-schema.xml
> change <table name="RDF"> to <table name="RDF"
> idMethod="idbroker">
>
> (Note: You only need to make these changes once, when you first
> download the
> TDK. Now the template files used to create new webapps are configured
> correctly. You should be able to make as many different webapps with
> different names as you want simply by editing the <tdk
> root>/build.properties file and changing "newapp" to the name of the
> project
> that you want to use.)
>
> Run ant as described in step 3.
>
> Now during step 4, make these changes:
>
> in <tdk root>/webapps/newapp/WEB-INF/build/build.properties :
> * set the variable: database=mssql
> * uncomment the line: database.manual.creation = true
> * set the database variables:
> databaseDriver = com.jnetdirect.jsql.JSQLDriver
> databaseUser = sa
> databasePassword =
> databaseHost = 127.0.0.1
> databaseUrl =
> jdbc:JSQLConnect://${databaseHost}/database=${project}&user=$
> {databaseUser}
>
> Copy the JSQLDriver.jar file (download from http://www.j-netdirect.com/)
> into the lib directory as described.
>
> After step 4:
> * create a database in SQL Server for Turbine to connect to. make
> sure
> the database name
> matches the project name (in this case, "newapp").
>
> Follow the rest of the instructions in the TDK Howto. They seem to work
> fine.
>
> I think that this covers all of the changes to get this up and running
> on
> Windows. Hopefully this will save people some wasted time making the
> little
> tweaks necessary to use the TDK with SQL Server.
>
> -F
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
