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: Datanucleus federated datastore creates correctly, queries incorrectly
Date Wed, 23 Jan 2019 11:19:13 GMT
Hi Brian,

this mail of yours has been languishing in my inbox for months, so sorry
about that.

Since 1.17.0 is out, could you put together an example app that
demonstrates the issue, then I'll take a look at it.

Thx
Dan



On Mon, 22 Oct 2018 at 19:42, Brian K <harvestmoon299@gmail.com> wrote:

> Hello,
>
> I'm hoping you can look at this apparent bug or tell me what I
> misconfigured.  I made github repo demonstrating this in 2.0.0-M1:
> https://github.com/bkalbfus/isis-federatedDS-2_0_0-M1
>
> I generated from this command:
> 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=federatedDS-2_0_0-M1 \
>     -D version=1.0-SNAPSHOT \
>     -B
>
> I copied the HelloWorldObject to make the HelloOtherWorldObject, using text
> replace to fix references.
> I configured the HelloOtherWorldObject with this annotation:
>     @Extension(vendorName = "datanucleus", key = "datastore", value =
> "other")
> I added this to end of isis.properties:
>    # For secondary datastore:
>
>
> isis.persistor.datanucleus.impl.datanucleus.datastore.other=datanucleus_other.properties
> I created the file src/main/java/datanucleus_other.properties with these
> contents:
>    javax.jdo.option.ConnectionDriverName=org.hsqldb.jdbcDriver
>    javax.jdo.option.ConnectionURL=jdbc:hsqldb:mem:test_other
>    javax.jdo.option.ConnectionUserName=sa
>    javax.jdo.option.ConnectionPassword=
>
> I am run the command:  mvn clean jetty:run
> I create three instances HelloWorldObject from the "Hello World Objects"
> menu, naming them "a", "b", and "c"
> I create three instances of HelloOtherWorldObject from the "Other" menu,
> naming them "1", "2", and "3"
> I can update the instance of HelloOtherWorldObject I just created to add a
> note text
> I can view the HelloWorldObject instances via HSQLDB manager at the default
> connection url: jdbc:hsqldb:mem:test
>   Note:  at this point, there is only a single table in the
> jdbc:hsqldb:mem:test database;  It is for HelloWorldObject
> I can view the HelloOtherWorldObject instances via HSQLDB manager by the
> HSQLDB manager's File menu - Connect, changing the connection url to:
> jdbc:hsqldb:mem:test_other
> I can list the HelloWorldObject instances via the "Hello World Objects"
> menu.  find by name also works as expected
> The update I made to HelloOtherWorldObject immediately after creating it is
> reflected correctly in jdbc:hsqldb:mem:test_other
>
> ***Now, this is where it goes wrong:
>
> If I list the HelloOtherWorldObject instances via the "Other" menu, it
> shows no results
> If I execute the menu command "Other" - "Find by Name" to find one of the
> HelloOtherWorldObject instances I just created it does not find anything
>    Now Note: there exists an additional table in the jdbc:hsqldb:mem:test
> database for HelloOtherWorldObject.  This has no data and is not used by
> additional inserts for HelloOtherWorldObject.
>
>
> I did this first with 1.16.2.  In brief:
>    * Create works for HelloWorldObject
>    * Create works for HelloOtherWorldObject but shows error when displaying
> the object just created
>    * HelloWorldObject List All throws error
> I can publish my test with 1.16.2 to github if it would help.
>
> Thanks!
> Brian
>

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