Hi Andi,
Thanks for pointing that out! I was retrofitting my code that used a
String field in its primary key. The good news is that, after copying part
of my code to the 2.0.0-M1 HelloWorld project and altering to fit the new
2.0 classes, I no longer get the error that I reported in my email a while
back. But, I haven't reproduced the error in the 1.16.2 code base yet from
the SimpleApp archetype. This gives me a good start to getting my domain
code working with the 2.0 version with hopes that the error will not
occur. I'll let you know if it does.
Thanks again!
Brian
On Wed, Sep 26, 2018 at 12:46 PM Andi Huber <ahu...@apache.org> wrote:
> When trying to reproduce the issue, I found that you did not properly
> implement the HelloWorldPrimaryKey: the second public constructor should be
> (according to DN-5.2 spec) ...
>
> public HelloWorldPrimaryKey(String s) {
> this.id = Integer.parseUnsignedInt(s);
> }
>
> Let us know, if that solves the issue!
>
> Cheers
>
> On 2018/09/26 18:15:19, Brian K <harvestmoon...@gmail.com> wrote:
> > 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 <
> d...@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, <harvestmoon...@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 <
> > > d...@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, <harvestmoon...@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>*'.
> > > >> >
> > > >>
> > > >
> > >
> >
>
