Hi Andrew,
from the error below it looks like you are missing two pieces:
1. DataNode DbAdapter is not set to SQLServerAdapter in the Modeler:
http://objectstyle.org/cayenne/modelerguide/common-tasks/create-data-
node.html
2. DB objects for automatic PK generation are not created on the
SQLServer: http://objectstyle.org/cayenne/modelerguide/common-tasks/
pksupport.html
Hope this helps.
Andrus
On Sep 3, 2005, at 9:09 PM, Andrew Pym wrote:
> I am new to Cayenne.
>
> Queries have been working with no problems
>
>
>
> I could not find an email search to see if this problem had been
> solved before.
>
> Could someone point me to an email search archive? – might be worth
> adding to the website as well.
>
>
>
> I have a problem creating an entry in a MS SQL 200 database
>
>
>
> The table has a primary key field which is set as an Entity field
> (an int – which is set to increment by 1 for each new value)
>
>
>
> I am using Cayenne v.1.2-dev-2005-8-23 August 23 2005
>
> Error log is below
>
> INFO QueryLogger: +++ Connecting: SUCCESS.
>
> INFO QueryLogger: --- transaction started.
>
> INFO QueryLogger: SELECT NEXT_ID FROM AUTO_PK_SUPPORT WHERE
> TABLE_NAME = 'Enter
>
> priseObjectAttributeTypes'
>
> INFO QueryLogger: *** error.
>
> java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]
> [SQLServer]The
>
> cursor was not declared.
>
> at com.microsoft.jdbc.base.BaseExceptions.createException
> (Unknown Source
>
> )
>
> at com.microsoft.jdbc.base.BaseExceptions.getException
> (Unknown Source)
>
> at
> com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
>
> Source)
>
>
>
> Can anyone point me in the right direction?
>
>
>
> Regards
>
> Andrew
>
>
This archive was generated by hypermail 2.0.0 : Sat Sep 03 2005 - 21:16:21 EDT