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>*'.
