Jetspeed 1.4 b3 and MS Sql Server

[EP...@upstate.com]

Hi,

I noticed that in the new version of Jetspeed, the turbine and jetspeed
tables are using Identity columns.  This means that the insert statements
don't work, because they now need to be identity_insert statements.  Does
this jive with what other Jetspeed users have seen?  

What other pitfalls are there with Jetspeed and MSSQLServer?

I will submit the patches when I am done.

Eric

RE: Jetspeed 1.4 b3 and MS Sql Server

[David Sean Taylor <da...@bluesunrise.com>]

> -----Original Message-----
> From: EPugh@upstate.com [mailto:EPugh@upstate.com]
> Sent: Wednesday, December 18, 2002 1:54 PM
> To: jetspeed-dev@jakarta.apache.org
> Subject: Jetspeed 1.4 b3 and MS Sql Server
>
>
> Hi,
>
> I noticed that in the new version of Jetspeed, the turbine and jetspeed
> tables are using Identity columns.  This means that the insert statements
> don't work, because they now need to be identity_insert statements.  Does
> this jive with what other Jetspeed users have seen?
>
Yes, as of 1.4b2, the Torque schema and 'native' mode id generation are the
same for all db backends.
I thought I tested SQL Server back in October, guess I must've left
something out.
Patches welcome!



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>