cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sudheer <sudheer.t...@gmail.com>
Subject Custom PK and Pagination
Date Fri, 26 Feb 2010 11:09:02 GMT

I have created custom type in Java by extending AbstractType and added same
to existing types (SQL Server). This is the primary key. Java type is
CustomUuid and DB type is Binary (16). Also I am performing select
operation. Everything worked fine till I started using pagination. I got
below error when I used pagination

INFO  QueryLogger: SELECT t0.amstat, t0.aorigin, t0.col1, t0.col2, t0.col3,
t0.col4, t0.id, t0.label, t0.lrundate, t0.ptstat, t0.rcstat, t0.sdstat,
t0.state, t0.tlevel, t0.usage_list FROM allcomputers t0 WHERE (t0.id = ?) OR
(t0.id = ?) [bind: [com.xx.cayenne.util.CustomUuid:
b06a638b06cca449bffd7049cc389847], [com.xx.cayenne.util.CustomUuid:
771a7f8b57006744b47d541bd5a796a5]]
INFO  QueryLogger: *** error.
com.microsoft.sqlserver.jdbc.SQLServerException: The Java type
com.ca.cayenne.util.CustomUuid is not a supported type.
        at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
Exception in thread "main" org.apache.cayenne.CayenneRuntimeException:
[v.2.0.4 October 8 2007] Query exception.
        at
com.microsoft.sqlserver.jdbc.AppDTVImpl$SetValueOp.executeDefault(Unknown
Source)
        at com.microsoft.sqlserver.jdbc.DTV.executeOp(Unknown
Source).............................

Am I missing something here???

Is pagination allowed when Custom type is set as primary key? 

I am using Cayenne 2.0 (latest). Thanks in advance.

-- 
View this message in context: http://n3.nabble.com/Custom-PK-and-Pagination-tp417066p417066.html
Sent from the Cayenne - User mailing list archive at Nabble.com.

Mime
View raw message