Yes I did that. There was some talk around the net that I had to add aliases for the boolean variables but I'm not sure where to edit or add those in the hibernate.cfg.xml file.
What i'm doing now is takning the source code and looking at the preparedStatements that have the "limit" keyword in there to see if they are even fixed.
Shaun.Farrugia. . [EMAIL PROTECTED]
perm. desk.734.887.2148. . .cell.313.363.5006
aim.dier0b0t . . .
Allen Gilliland <[EMAIL PROTECTED]>
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 . . .
