Hmm so i'm looking at the code and it seems like it uses the TOP ? for HSQL. But it checks if it should use the TOP functionality based on the driver name ("HSQL"). I think I'll add MSSQL just to hack it right now . Seems that hibernate isn't being used for this query because it can't handle sorting by sum.
Uses LIMIT in
- 1. org\roller\business\hibernate\HibernateRefererManagerImpl.java
2. org\roller\business\utils\ConsistencyCheck.java
-Taken From http://jroller.com/page/benchristen/20050107#roller_with_ms_sql_2k1
Shaun.Farrugia. . [EMAIL PROTECTED]
perm. desk.734.887.2148. . .cell.313.363.5006
aim.dier0b0t . . .
07/20/2005 04:12 PM
|
|
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 . . .
