hibernate.connection.dialect=net.hibernate.sf.dialect.SQLServerDialect
when i use hilo or native id generator with sqlserver 2003 I see

FOR UPDATE clause allowed only for DECLARE CURSOR."
in hilo generator

this is similar to
http://forum.hibernate.org/viewtopic.ph ... are+cursor
where the user was advised to use SybaseDialect for SQLServer
Is the SQLServer dialect incorrect and is anyone using hilo (or native) generator swith sqlserver???

I think you need to specify the following parameter to the driver properties:
selectMethod=cursor

OK - this is a real newbie question but how and where do I specify the driver properties???

OK answering my own question d'oh it is in the FAQs that
the property is in the connestion string

http://www.hibernate.org/120.html#A6

What JDBC Drivers are you using (and hence, will this fix work for)?

Are you trying to do a SELECT FOR UPDATE? I am having a similar problem.

-Nick

I am trying everything
native and hilo give
FOR UPDATE clause allowed only for DECLARE CURSOR.
for
net.sourceforge.jtds.jdbc.Driver and
com.microsoft.jdbc.sqlserver.SQLServerDriver
I am not wild about a $800 driver for development as with the jtds
drivern
Does anyone have create working with int keys and SQL server and what do you use???