More info, yes it seems the Volunteer table is not created at the same time
as the other tables, until I actually try to add an entry, Isis seems to
check for it, finds it missing and creates it.I am doing almost exactly the
same procedure successfully with another table that is already created,
participant.
Here is the current striped down Volunteer class defintion:
package au.com.scds.chats.dom.modules.volunteer;
import javax.jdo.annotations.Column;
import javax.jdo.annotations.IdentityType;
import org.apache.isis.applib.DomainObjectContainer;
import org.apache.isis.applib.annotation.MemberOrder;
import au.com.scds.chats.dom.modules.general.Person;
@javax.jdo.annotations.PersistenceCapable(identityType =
IdentityType.DATASTORE)
@javax.jdo.annotations.DatastoreIdentity(strategy =
javax.jdo.annotations.IdGeneratorStrategy.IDENTITY, column = "id")
public class Volunteer {
// {{ Person (property)
private Person person;
@Column(allowsNull="false")
@MemberOrder(sequence = "1")
public Person getPerson() {
return person;
}
public void setPerson(final Person person) {
this.person = person;
}
// }}
@javax.inject.Inject
@SuppressWarnings("unused")
private DomainObjectContainer container;
// endregion
}
On Fri, Jul 31, 2015 at 10:38 PM, Stephen Cameron <
[email protected]> wrote:
> Hi folks
>
> I have a problem that I cannot solve and hoping someone might have seen
> similar.
>
> When I create a new entity the server freezes, its just the one kind of
> entity.
>
> In the server console I see the following output.
>
> 22:13:26,989 [Schema 455726379@qtp-1318209130-0 DEBUG]
> ALTER TABLE "Activity" ADD CONSTRAINT "Activity_FK2" FOREIGN KEY
> ("activities_id_OID") REFERENCES "Participant" ("id")
> 22:13:26,991 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Execution Time = 2 ms
> 22:13:26,991 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Creating foreign key constraint : "Activity_FK1" in catalog "" schema ""
> 22:13:26,991 [Schema 455726379@qtp-1318209130-0 DEBUG]
> ALTER TABLE "Activity" ADD CONSTRAINT "Activity_FK1" FOREIGN KEY
> ("provider_id_OID") REFERENCES "Provider" ("id")
> 22:13:26,992 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Execution Time = 1 ms
> 22:13:26,993 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Creating index "Activity_N49" in catalog "" schema ""
> 22:13:26,993 [Schema 455726379@qtp-1318209130-0 DEBUG]
> CREATE INDEX "Activity_N49" ON "Activity" ("provider_id_OID")
> 22:13:26,993 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Execution Time = 0 ms
> 22:13:26,994 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Schema Transaction committing with connection
> "org.datanucleus.store.rdbms.datasource.dbcp.PoolingDataSource$PoolGuardConnectionWrapper@587ed84a
> "
> 22:13:26,994 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Schema Transaction closing with connection
> "org.datanucleus.store.rdbms.datasource.dbcp.PoolingDataSource$PoolGuardConnectionWrapper@587ed84a
> "
> 22:13:33,718 [PropertiesFactory 455726379@qtp-1318209130-0 INFO ]
> Loading properties files from
> jar:file:/C:/Users/stevec/.m2/repository/org/apache/wicket/wicket-extensions/6.17.0/wicket-extensions-6.17.0.jar!/org/apache/wicket/extensions/Initializer.properties
> with loader
> org.apache.wicket.resource.IsoPropertiesFilePropertiesLoader@723b0f4d
> 22:13:55,556 [PropertiesFactory 455726379@qtp-1318209130-0 INFO ]
> Loading properties files from
> jar:file:/C:/Users/stevec/.m2/repository/org/apache/isis/viewer/isis-viewer-wicket-ui/1.9.0-SNAPSHOT/isis-viewer-wicket-ui-1.9.0-SNAPSHOT.jar!/org/apache/isis/viewer/wicket/ui/components/actions/ActionParametersFormPanel.properties
> with loader
> org.apache.wicket.resource.IsoPropertiesFilePropertiesLoader@723b0f4d
> 1
> 2
> 3
> 22:14:05,008 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Column ""Volunteer"."id"" added to internal representation of table.
> 22:14:05,008 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Field [DATASTORE_ID] -> Column(s) ["Volunteer"."id"] using mapping of type
> "org.datanucleus.store.rdbms.mapping.java.DatastoreIdMapping"
> (org.datanucleus.store.rdbms.mapping.datastore.BigIntRDBMSMapping)
> 22:14:05,009 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Table "Volunteer" will manage the persistence of the fields for class
> au.com.scds.chats.dom.modules.volunteer.Volunteer (inheritance
> strategy="new-table")
> 22:14:05,009 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Column ""Volunteer"."person_id_OID"" added to internal representation of
> table.
> 22:14:05,009 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Field [au.com.scds.chats.dom.modules.volunteer.Volunteer.person] ->
> Column(s) ["Volunteer"."person_id_OID"] using mapping of type
> "org.datanucleus.store.rdbms.mapping.java.PersistableMapping"
> (org.datanucleus.store.rdbms.mapping.datastore.BigIntRDBMSMapping)
> 22:14:05,009 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Column ""Volunteer"."status"" added to internal representation of table.
> 22:14:05,010 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Field [au.com.scds.chats.dom.modules.volunteer.Volunteer.status] ->
> Column(s) ["Volunteer"."status"] using mapping of type
> "org.datanucleus.store.rdbms.mapping.java.EnumMapping"
> (org.datanucleus.store.rdbms.mapping.datastore.VarCharRDBMSMapping)
> 22:14:05,010 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Table/View "Volunteer" has been initialised
> 22:14:05,010 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Schema Transaction started with connection
> "org.datanucleus.store.rdbms.datasource.dbcp.PoolingDataSource$PoolGuardConnectionWrapper@1855dae"
> with isolation "serializable"
> 22:14:05,015 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Check of existence of "Volunteer" returned no table
> 22:14:05,015 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Creating table "Volunteer"
> 22:14:05,015 [Schema 455726379@qtp-1318209130-0 DEBUG]
> CREATE TABLE "Volunteer"
> (
> "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
> "person_id_OID" BIGINT NULL,
> "status" NVARCHAR(255) NOT NULL,
> CONSTRAINT "Volunteer_PK" PRIMARY KEY ("id")
> )
> 22:14:05,016 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Execution Time = 1 ms
> 22:14:05,020 [Schema 455726379@qtp-1318209130-0 DEBUG]
> Creating foreign key constraint : "Volunteer_FK1" in catalog "" schema ""
> 22:14:05,021 [Schema 455726379@qtp-1318209130-0 DEBUG]
> ALTER TABLE "Volunteer" ADD CONSTRAINT "Volunteer_FK1" FOREIGN KEY
> ("person_id_OID") REFERENCES "Person" ("id")
>
> I'm still no debugging properly yet, so the 1,2,3 are from the following
> routine
>
> public Volunteer create(
> final @ParameterLayout(named = "First name") String firstname,
> final @ParameterLayout(named = "Middle name(s)") String
> middlename,
> final @ParameterLayout(named = "Surname") String surname) {
> System.out.println("1");
> final Volunteer volunteer = container
> .newTransientInstance(Volunteer.class);
> final Person person = container.newTransientInstance(Person.class);
> person.setFirstname(firstname);
> person.setMiddlename(middlename);
> person.setSurname(surname);
> container.persistIfNotAlready(person);
> System.out.println("2");
> volunteer.setPerson(person);
> container.persistIfNotAlready(volunteer);
> System.out.println("3");
> return volunteer;
> }
>
> What seems strange in the output is that the table Volunteer doesn't seem
> to be created in the same way as other tables. In fact its after a
> transaction is committed:
>
> DEBUG] Schema Transaction closing with connection
> "org.datanucleus.store.rdbms.datasource.dbcp.PoolingDataSource$PoolGuardConnectionWrapper@587ed84a
> "
>
> Also, that Volunteer table is created after the calls to add an entry in
> the create method.
>
> HFH
> Steve
>
>
