From users-return-6042-archive-asf-public=cust-asf.ponee.io@isis.apache.org Thu Jun 21 22:09:41 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 83F6518062B for ; Thu, 21 Jun 2018 22:09:40 +0200 (CEST) Received: (qmail 71842 invoked by uid 500); 21 Jun 2018 20:09:34 -0000 Mailing-List: contact users-help@isis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@isis.apache.org Delivered-To: mailing list users@isis.apache.org Received: (qmail 71830 invoked by uid 99); 21 Jun 2018 20:09:33 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Jun 2018 20:09:33 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 4E10AC87FB for ; Thu, 21 Jun 2018 20:09:33 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.119 X-Spam-Level: ** X-Spam-Status: No, score=2.119 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, T_DKIMWL_WL_MED=-0.01] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id 72l7n2Dg2X2c for ; Thu, 21 Jun 2018 20:09:32 +0000 (UTC) Received: from mail-it0-f66.google.com (mail-it0-f66.google.com [209.85.214.66]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 342ED5F2F0 for ; Thu, 21 Jun 2018 20:09:32 +0000 (UTC) Received: by mail-it0-f66.google.com with SMTP id k17-v6so3532966ita.0 for ; Thu, 21 Jun 2018 13:09:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=kAjSNYAdz2a3Krl8VggaKfnMGKaATiXDGg1QycnVlOo=; b=PFl7d6BLxuEjDtp2DFDvxXWsbFMk//x07O13M9s3CvYIEjRd+8fGV+upZWrmyI/oog kBIj1cMmI6Pm1sm6+hwAw5ALDRM4Fw2DvkYx/L1sH+u/bRQ88sjV5PY4wOooTgMxcTsZ xRbRClKiNeVmUJzpk4hddCm1PheSu6+WlU0LvFJxU+CYi9Vwvr9v72tftLRnLCrYcj7I uQfCugwjeMC4I5w9mAn9/G2HahU2Txyk54Rbf6GZux0SMiX3l7NOwY6jAh6ZcsHQpie+ Ee5PX+cBVc+M6Soq8mmAXXmc9p86nhPo4sZ2O83CWDnxXTGPaU6SqjvmbzrdGNmiAn59 BuKg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=kAjSNYAdz2a3Krl8VggaKfnMGKaATiXDGg1QycnVlOo=; b=edee0yD6NPHkOlJlKif4odNSKPaoJw1NZZ08mftzxGggPcwXQzBi8B8Og8ncKMRxNO 8QTfZtJ2bX/H/Xr2fv2yhz/utTcQZi9jRGc2VrL6B5CBwh+NafromnRnZ1W8tb/obTom YGmdvWeqR6jjAvG9kNk8rWBbrp8Fd6QgBrQJNzKzMl/WHccO1Rzze1XV8c9yiDHrk+j5 uin/3+Vh/T8GF8AEHlDRMRUuI2SRID+ATsk1wQEVQTM4pbg5BjAvw/KW/aHedt3Ki17w S5hJvOheTffglp072MDzKO15/3NIed0GLb6ylZHYLavCoa1bW7mSbTvaHFDvmqZOTyuv R2tg== X-Gm-Message-State: APt69E38dpi2q2ZBZJthQs6bi7IXrxoBpgWyvaSOW3A55R2SW3htxgXp g9sCFbGttG4n0pB7EFPGWeisHUoENOX1pYFjVBg= X-Google-Smtp-Source: ADUXVKK07soTQYsCVnoNlAECiSmDcG/Xcmz/EueCVeJSq0UH1G7R6TECFKRcbuBLHwBVohgkhETrF6HZUqDyRoym0Q8= X-Received: by 2002:a24:2453:: with SMTP id f80-v6mr6415224ita.151.1529611771305; Thu, 21 Jun 2018 13:09:31 -0700 (PDT) MIME-Version: 1.0 From: Brian K Date: Thu, 21 Jun 2018 12:09:20 -0800 Message-ID: Subject: Simple composite key of ansi padded strings To: users@isis.apache.org Content-Type: multipart/alternative; boundary="00000000000045e6d8056f2c7e60" --00000000000045e6d8056f2c7e60 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello, I=E2=80=99m modeling my domain objects over an existing sql server database= . One of my tables has a primary key that has two columns of type char(10). The values that come from columns like this appear with trailing spaces. The OID generated by Isis for a single column primary key works fine and shows urls such as http://localhost:8080/wicket/entity/dbo.courtcd:s_3AN-P%20%20%20%20%20 . When I have a table that has two fields like this as the primary key, I get this error: Could not parse OID 'dbo.crtprecx:domainapp.modules.simple.dom.impl.CourtPrecinct_PK_3AN-P :ANCHORAGE '; should match pattern: ^((([!*])?([^:~$\^#]+):([^:~$\^#]+))((~[^:~$\^#]+:[^:~$\^#]+)*))([$][^:~$\^= #]+)?([\^](\d+):([^:~$\^#]+)?:(\d+)?)?$ Do I have to now create a primary key class to use the trimmed values of the string fields in the primary key, or is there another way to handle this? Thank you! Brian --00000000000045e6d8056f2c7e60--