----- 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]
