If you are not using MySQL then you will need to change the hibernate dialect to whatever sql server you use.
This is found in the file WEB-INF/classes/hibernate.cfg.xml And you want to change this line ... <property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property> to ... <property name="dialect">net.sf.hibernate.dialect.SQLServerDialect</property> try that and see if it works. -- Allen On Wed, 2005-07-20 at 13:04, Shaun Farrugia wrote: > So! I installed Roller 1.2 on Tomcat 5.0 and SQL Server 2000 using the > jtds JDBC Driver. I updated the HSQL database script so that it could run > properly on SQL Server. But i'm getting a problem with LIMIT in the > queries. I thought Roller 1.1 updated the jars so that it was compatible > with SQL. What other steps do I need to take so that I can run this on MS > SQL Server? > > > Shaun.Farrugia. . [EMAIL PROTECTED] > perm. desk.734.887.2148. . .cell.313.363.5006 > aim.dier0b0t . . .
