Custom PK and Pagination

From: Sudheer (sudheer.tec..mail.com)
Date: Fri Feb 26 2010 - 06:09:02 EST

  • Next message: Michael Gentry: "Re: Custom PK and Pagination"

    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.

    This archive was generated by hypermail 2.0.0 : Fri Feb 26 2010 - 06:09:39 EST