isis-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian K <harvestmoon...@gmail.com>
Subject Re: Wicket Viewer limitations with DataNucleus?
Date Wed, 26 Sep 2018 18:15:19 GMT
I created a ticket for the application identity issue and attached the
zipped files to it.
https://github.com/incodehq/incode-platform/issues/97


On Wed, Sep 26, 2018 at 9:53 AM Dan Haywood <dan@haywood-associates.co.uk>
wrote:

> 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, <harvestmoon299@gmail.com> 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 <
> dan@haywood-associates.co.uk>
> > 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, <harvestmoon299@gmail.com> 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 '*<WRONG DATABASE>*'.
> >> > com.microsoft.sqlserver.jdbc.SQLServerException: CREATE TABLE
> permission
> >> > denied in database '*<WRONG DATABASE>*'.
> >> >
> >>
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message