Roller MS SQL Server

Sorry, wrong link.  JTDS = http://jtds.sourceforge.
net/

G

-----Original Message-----
From: George Daswani [mailto:gdaswaniesri.com] 
Sent: Tuesday, March 28, 2006 2:32 PM
To: roller-userincubator.apache.org
Subject: RE: Roller MS SQL Server

I was the one that submitted the patch.

I've tested it on both the JTDS 1.2 (http://www.jtds.org) along
with
Microsoft's new SQL Server 2005 Driver (which also works
with SQL Server
2K).

Make sure your hibernate config file
(WEB-INF/classes/hibernate.cfg.xml)
is set to use the SQLServer Dialect, instead of the default
(MySQL
dialect)

From this

        <property
name="dialect">org.hibernate.dialect.MySQLDia
lect</property>


To this

<property
name="dialect">org.hibernate.dialect.SQLServe
rDialect</property>

George
-----Original Message-----
From: Davidm.JohnsonSun.COM [mailtoavidm.Jo
hnsonSun.COM] 
Sent: Tuesday, March 28, 2006 2:24 PM
To: roller-userincubator.apache.org
Subject: Re: Roller MS SQL Server

You might want to test the latest Roller 2.2 release
candidate and  
see how that works. We accepted a patch that added MS SQL
Server  
support.

There are database create scripts for MS SQL Server.
However, we  
don't have upgrade scripts so you might have to create
those yourself  
based on the other database ones.

Whatever you do, don't mess with your old database until
you've  
complete verified that you can upgrade safely. Make a copy
of your  
old database and use that to test.

> You can get the new RC here:
>      ht
tp://people.apache.org/~snoopdave/roller-2.2-rc/

- Dave



- Dave


On Mar 28, 2006, at 1:07 PM, Steele, Aaron wrote:
> Can anyone point me in the right direction to get
Roller working  
> with MS
> SQL Server? Thanks.
>
> Thank You,
>
> Aaron Steele
> YRI Enterprise Solutions
> https://ris.yumnet.com
> w: 972.338.6862
> c: 817.401.0831
>
>
>
>
> This communication is confidential and may be legally
privileged.   
> If you are not the intended recipient, (i) please do
not read or  
> disclose to others, (ii) please notify the sender by
reply mail,  
> and (iii) please delete this communication from your
system.   
> Failure to follow this process may be unlawful.  Thank
you for your  
> cooperation.