isis-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Haywood <...@haywood-associates.co.uk>
Subject Re: Wicket Viewer limitations with DataNucleus?
Date Wed, 26 Sep 2018 05:30:59 GMT
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