From users-return-6123-archive-asf-public=cust-asf.ponee.io@isis.apache.org Wed Sep 26 19:53:48 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 00695180629 for ; Wed, 26 Sep 2018 19:53:47 +0200 (CEST) Received: (qmail 33232 invoked by uid 500); 26 Sep 2018 17:53:47 -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 33220 invoked by uid 99); 26 Sep 2018 17:53:46 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Sep 2018 17:53:46 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 0655BC1A8E for ; Wed, 26 Sep 2018 17:53:46 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.838 X-Spam-Level: ** X-Spam-Status: No, score=2.838 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, KAM_COUK=0.85, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, T_DKIMWL_WL_MED=-0.01] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=haywood-associates-co-uk.20150623.gappssmtp.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id CCVN4yBrmuEp for ; Wed, 26 Sep 2018 17:53:43 +0000 (UTC) Received: from mail-it1-f180.google.com (mail-it1-f180.google.com [209.85.166.180]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 6B2D15F3E2 for ; Wed, 26 Sep 2018 17:53:43 +0000 (UTC) Received: by mail-it1-f180.google.com with SMTP id w200-v6so4066886itc.4 for ; Wed, 26 Sep 2018 10:53:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=haywood-associates-co-uk.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=VhPgnMqNRjtgSFVo4Y/wq72/xPsS1GitYYmpscJcFRQ=; b=gXimGoiftAt3WyRfqwhDF/uBJBEQVJC6qivO5q6G/vjcLrEe744h1Spw4fIl581qDc Te0UIK7HqlpXXPoHf8LRwPBvnQYIQ6OV7hzwt0b3G6qw1kzinL6KtHme88TTdgz0Pam0 GvT4jnoLlKDw1KedLkkcEiFJryNyE+hXNs+xkgDRkhmr9t5YfmK7/GRfffLefNtEzJ7u ZY7TLJVJ5tBtg3paj1v7kMPAfhOlg1l9tonnYrQJs3qcJmUMGzmlL+G/+0SMl6X/1hFh h9v911ScxE7yB/nY2q8r0x93Q20ncFzVqDwhJaPs9BdmSvjWdnAR6wXgODIY1gHA9ujQ yj8Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=VhPgnMqNRjtgSFVo4Y/wq72/xPsS1GitYYmpscJcFRQ=; b=QVsaljkVucpeSru1hNOg8UaQZIWLKJ18mrs+w3ot8LpSxL8LDTmVEAJS88JiCFprJz yUIjlJRyhAAuMlm3zp2nluVHpz5L8h32kRpnRJhQytxbbUewQKeV7q+oJf8NYa+Y4jss quR3gLLV5UbH5XPX398/XwZKS/sIN8CJhPRaquhn3N38VsH+Hp0U34KQr+K5+RLc3Tmf g2KOh23eG6aq7tQ1BQ/VrDrD+oSuk2v1QdQd8iCijPDlxh8h+P37GJoYf+/MqdN3nNOj 9dRtMXjerKHppg0oJgUc2JjIBTFUbF91YnZGYQaV7WAm5Ig0sutHrskTnxFYwWKnKlz9 Y3AA== X-Gm-Message-State: ABuFfogBsuRz0X0f2+7gBd8RTwU84Pg1DxnKL61EXbA0qhg+3L8kgsdN r3OocfrcJE4weZvyQlgYt5lOPYPpsWKKdP7ba2t+qxvdGBEU4A== X-Google-Smtp-Source: ACcGV63vNXPhrd8kV9yW4rq73F+Y/n3XBZAdmBojJysEq8XNxrXkSTlls17gTcX6ocBpg9QNKxxHI7EunOFMl8YGfKU= X-Received: by 2002:a02:4d1b:: with SMTP id l27-v6mr6666274jab.86.1537984422309; Wed, 26 Sep 2018 10:53:42 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dan Haywood Date: Wed, 26 Sep 2018 19:53:30 +0200 Message-ID: Subject: Re: Wicket Viewer limitations with DataNucleus? To: users Content-Type: multipart/alternative; boundary="000000000000299aaa0576c9e721" --000000000000299aaa0576c9e721 Content-Type: text/plain; charset="UTF-8" Hi Brian, The Asf mailing lists don't allow attachments. Could you perhaps push your code to a github repo and reference that? Thx Dan. On Wed, 26 Sep 2018, 19:48 Brian K, wrote: > Hi Dan, > > I ran: > mvn archetype:generate \ > -D archetypeGroupId=org.apache.isis.archetype \ > -D archetypeArtifactId=helloworld-archetype \ > -D archetypeVersion=2.0.0-M1 \ > -D groupId=com.mycompany \ > -D artifactId=myapp \ > -D version=1.0-SNAPSHOT \ > -B > > ...and made the changes to HelloWorldObject shown in the attached patch > file (ignore the file dates - I had to diff manually because I didn't use > git) > ...and added the the attached HelloWorldPrimaryKey.java to the same folder. > > Swagger-UI is able to handle this just fine, but the wicket viewer is > getting errors when I bring up a created HelloWorldObject. > > -Brian > > On Tue, Sep 25, 2018 at 9:31 PM Dan Haywood > wrote: > >> Hi Brian, >> To answer your last question first, yes we are working on a new rest >> viewer, but it's still far from ready. I expect the wicket viewer to be >> maintained for the foreseeable future (for the lifetime of Isis v2, >> certainly). >> >> With respect to the two limitations you've uncovered, could you raise a >> jira ticket for both and could you also create a small helloworld app >> based >> off 2.0.0-M1 that demonstrates the issue. Well certainly try to fix the >> issues in v2 and we'll back portion to 1.x if practicable. >> >> Thanks >> Dan. >> >> >> >> On Tue, 25 Sep 2018, 21:15 Brian K, wrote: >> >> > Hi, >> > >> > It seems that the wicket viewer does not support some features of >> > DataNucleus: >> > 1. Application Identity - I posted earlier about this ( >> > https://isis.markmail.org/thread/jm72jzykqnzjdqp6) >> > 2. Federated Datastore. Following instructions at >> > >> > >> http://www.datanucleus.org/products/datanucleus/jdo/persistence.html#_defining_primary_and_secondary_datastores >> > , I now can use Swagger-UI to query the secondary datastore [1], but >> Wicket >> > viewer keeps on keying on to primary datastore and throwing an error >> [2]. >> > >> > I noticed in your roadmap at >> > >> > >> https://cwiki.apache.org/confluence/display/ISIS/Roadmap+to+Version+2#RoadmaptoVersion2-Extendingpersistencelayersupport >> > that Wicket may be replaced soon. >> > >> > Is this something that we could fix with the Wicket viewer or should I >> wait >> > for the UI rewrite in 2.0? Would the best work-around be to create a >> view >> > model that proxies all the properties? >> > >> > Thanks! >> > Brian >> > >> > [1]: I added this to isis.properties: >> > >> > >> isis.persistor.datanucleus.impl.datanucleus.datastore.oq=datanucleus_oq.properties >> > >> > and created the datanucleus_oq.properties file in the src/main/java >> folder >> > of the webapp module (it works when there is no >> > isis.persistor.datanucleus.impl prefixes to the properties): >> > >> > >> javax.jdo.option.ConnectionDriverName=com.microsoft.sqlserver.jdbc.SQLServerDriver >> > javax.jdo.option.ConnectionURL=jdbc:sqlserver://... >> > javax.jdo.option.ConnectionUserName=username >> > javax.jdo.option.ConnectionPassword=password >> > >> > >> > [2]: (my annotations in *bold*) >> > REST Viewer looking up an object by its id (via Swagger-UI): >> > 10:50:23,803 [Native qtp1238209644-16 DEBUG] SELECT >> > 'domainapp.modules.simple.dom.impl.J300eSession' AS NUCLEUS_TYPE, >> *.....*, >> > WHERE A0.id = <321> >> > >> > Wicket Viewer doing the same via the web page menu: >> > 10:50:40,578 [Native qtp1238209644-22 DEBUG] SELECT >> > 'domainapp.modules.simple.dom.impl.J300eSession' AS NUCLEUS_TYPE, >> > *...*WHERE >> > A0.id = <321> >> > 10:50:40,748 [Schema qtp1238209644-16 DEBUG] Column " >> > dbo.j300e_session.id" added to internal representation of table. >> > 10:50:40,749 [Schema qtp1238209644-16 DEBUG] Field [ >> > domainapp.modules.simple.dom.impl.J300eSession.id] -> Column(s) [ >> > dbo.j300e_session.id] using mapping of type >> > "org.datanucleus.store.rdbms.mapping.java.IntegerMapping" >> > (org.datanucleus.store.rdbms.mapping.datastore.IntegerRDBMSMapping) >> > 10:50:40,749 [Schema qtp1238209644-16 DEBUG] Table >> > dbo.j300e_session will manage the persistence of the fields for class >> > domainapp.modules.simple.dom.impl.J300eSession (inheritance >> > strategy="new-table") >> > *...* >> > 10:50:40,760 [Schema qtp1238209644-16 DEBUG] CREATE >> TABLE >> > dbo.j300e_session >> > ( >> > id int NOT NULL, >> > *...* >> > 10:50:40,764 [Datastore qtp1238209644-16 ERROR] Error >> thrown >> > executing CREATE TABLE dbo.j300e_session >> > *...* >> > ) : CREATE TABLE permission denied in database '**'. >> > com.microsoft.sqlserver.jdbc.SQLServerException: CREATE TABLE permission >> > denied in database '**'. >> > >> > --000000000000299aaa0576c9e721--