isis-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian K <harvestmoon...@gmail.com>
Subject Wicket Viewer limitations with DataNucleus?
Date Tue, 25 Sep 2018 19:15:01 GMT
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