Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 19781 invoked from network); 26 Feb 2010 11:09:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 26 Feb 2010 11:09:32 -0000 Received: (qmail 37155 invoked by uid 500); 26 Feb 2010 11:09:32 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 37126 invoked by uid 500); 26 Feb 2010 11:09:31 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 37118 invoked by uid 99); 26 Feb 2010 11:09:31 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Feb 2010 11:09:31 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_HELO_PASS,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 216.139.236.158 is neither permitted nor denied by domain of sudheer.tech@gmail.com) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Feb 2010 11:09:23 +0000 Received: from ben.nabble.com ([192.168.236.152]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1Nky46-0004Jk-Gk for user@cayenne.apache.org; Fri, 26 Feb 2010 03:09:02 -0800 Date: Fri, 26 Feb 2010 03:09:02 -0800 (PST) From: Sudheer To: user@cayenne.apache.org Message-ID: <1267182542513-417066.post@n3.nabble.com> Subject: Custom PK and Pagination MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org 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.