I have the TDK working on Turbine-2.1, but had to jump through some hoops
(and pretend I was using sybase).
I ran into an apparent bug in table.vm when trying to use 'mssql' as the
specified database:
C:\home\jjones\tdk\webapps\newapp\WEB-INF\build\build.xml:207: Exception
thrown
by 'generator.parse'. For more information consult the velocity log.
velocity log shows:
Tue Mar 19 09:51:10 PST 2002 [info] ResourceManager : found
sql/base/mssql/unique.vm with loader
org.apache.velocity.runtime.resource.loader.FileResourceLoader
Tue Mar 19 09:51:10 PST 2002 [error] Method chop threw exception for
reference $strings in template sql/base/mssql/table.vm at [14,24]
Tue Mar 19 09:51:10 PST 2002 [error] Method parse threw exception for
reference $generator in template sql/base/Control.vm at [28,17]
I tried messing with table.vm a bit, to no avail (for example, I got the
tables created, but then the referential integrity constraint sql wouldn't
load). So I gave up on the mssql .vm's. Maybe a newer version of Torque
has fixed this.
I used the 'sybase' setting, and everything worked fine.
You do need to follow the instructions in the mssql-howto (about manual
database & user creation).
In addition, for the sample app to work, I had to mess with a line in
[project]-schema.xml:
change
<table name="RDF">
to
<table name="RDF" idMethod="idbroker">
to get the idBroker to handle that table's ID's. Without this change, the
sample app kept supplying 'null' for new RdfID's. I don't know how to get
torque to work with mssql's identity fields, but I prefer using the idBroker
anyway.
I had bad luck with Microsoft's 'beta' JDBC driver - I kept getting
transaction errors. Apparently manual transactions are on by default, and I
haven't taken the time to figure out the proper URL or setting to turn it
off.
I am using Ashna's JTurbo driver with no problems.
I tried this process on both Windows 2K and RedHat 7.2, with equal results
(as expected).
Hope that helps a bit.
Jeff
>
> On Tuesday, March 19, 2002, at 08:41 AM, [EMAIL PROTECTED] wrote:
>
> > Help is highly appreciated. Pointing me to resources/posts/post
> > headlines/post dates/sample code is appreciated, too.
>
> Have you looked at either of these?
>
> <http://jakarta.apache.org/turbine/turbine-2/howto/mssql-howto.html>
> <http://jakarta.apache.org/turbine/turbine-2/howto/sybase-howto.html>
>
> Some have reported that MSSQL will work with the
> sybase configuration stuff.
>
> Hope that helps.
> -Eric
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
