dev.morphia.query.ValidationException: Could not resolve path '_id'

[NOTiFYcouk]

exception = dev.morphia.query.ValidationException: Could not resolve path '_id' against 'com.gostophandle.entity.morphia.Engine'. Unknown path element: '_id'.

EJB:

Query<Motorcycle> query = datastore.find(Motorcycle.class);
List<Motorcycle> motorcyclesList = query.iterator().toList();

Entity: Calls data from MongoDB for 1-6:

@Entity(value = "motorcycles", useDiscriminator = false)
@Indexes(@Index(options = @IndexOptions(name = "motorcycles")))
public class Motorcycle {

    private static final long serialVersionUID = 1L;

    private static final Logger LOGGER = LoggerFactory.getLogger(Motorcycle.class);

    @Id
    private ObjectId id;
    private String manufacturer; // 1
    private String model; // 2
    private String modelType; // 3
    private String typesOf; // 4
    private Date dateProductionStarted; // 5
    private Date dateProductionEnded; // 6

   @Reference("engine")
   private Engine engine;

If I add the Entity "engine":

@Entity(value = "engine", useDiscriminator = false)
@Indexes(@Index(options = @IndexOptions(name = "engine")))
public class Engine {

    private static final long serialVersionUID = 1L;

    private String type;

    private double displacement;

    private double cylinder;

    private String capacityUnit;

    private double bore;

    private String boreMeasurement;

    private double stroke;

    private String strokeMeasurement;

    private String distribution;

    private double maxiumPowerHp;

    private double maxiumPowerKilowatt;

    private double maxiumPowerRpm;

    private double maximumTorque;

    private String maximumTorqueUnit;

    private double maximumTorqueRpm;

    etc ...

Errors with:

15:10:28,962 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (ServerService Thread Pool -- 90) ***** MotorcyclesEJB init exception = {}: dev.morphia.query.ValidationException: Could not resolve path '_id' against 'com.gostophandle.entity.morphia.Engine'.  Unknown path element: '_id'.
	at deployment.GoStopHandle.ear//dev.morphia.internal.PathTarget.failValidation(PathTarget.java:139)
	at deployment.GoStopHandle.ear//dev.morphia.internal.PathTarget.resolve(PathTarget.java:168)
	at deployment.GoStopHandle.ear//dev.morphia.internal.PathTarget.translatedPath(PathTarget.java:108)
	at deployment.GoStopHandle.ear//dev.morphia.query.filters.Filter.path(Filter.java:157)
	at deployment.GoStopHandle.ear//dev.morphia.query.filters.Filters$1.encode(Filters.java:215)
	at deployment.GoStopHandle.ear//dev.morphia.query.MorphiaQuery.lambda$getQueryDocument$2(MorphiaQuery.java:397)
	at deployment.GoStopHandle.ear//dev.morphia.aggregation.codecs.ExpressionHelper.document(ExpressionHelper.java:55)
	at deployment.GoStopHandle.ear//dev.morphia.query.MorphiaQuery.getQueryDocument(MorphiaQuery.java:394)
	at deployment.GoStopHandle.ear//dev.morphia.query.MorphiaQuery.toDocument(MorphiaQuery.java:279)
	at deployment.GoStopHandle.ear//dev.morphia.query.MorphiaQuery.iterable(MorphiaQuery.java:350)
	at deployment.GoStopHandle.ear//dev.morphia.query.MorphiaQuery.prepareCursor(MorphiaQuery.java:380)
	at deployment.GoStopHandle.ear//dev.morphia.query.MorphiaQuery.iterator(MorphiaQuery.java:243)
	at deployment.GoStopHandle.ear//dev.morphia.query.Query.iterator(Query.java:274)
	at deployment.GoStopHandle.ear//dev.morphia.mapping.experimental.SingleReference.get(SingleReference.java:80)
	at deployment.GoStopHandle.ear//dev.morphia.mapping.codec.references.ReferenceCodec.fetch(ReferenceCodec.java:352)
	at deployment.GoStopHandle.ear//dev.morphia.mapping.codec.references.ReferenceCodec.decode(ReferenceCodec.java:184)
	at deployment.GoStopHandle.ear//org.bson.codecs.DecoderContext.decodeWithChildContext(DecoderContext.java:96)
	at deployment.GoStopHandle.ear//dev.morphia.mapping.codec.pojo.EntityDecoder.decodeModel(EntityDecoder.java:58)
	at deployment.GoStopHandle.ear//dev.morphia.mapping.codec.pojo.EntityDecoder.decodeProperties(EntityDecoder.java:79)
	at deployment.GoStopHandle.ear//dev.morphia.mapping.codec.pojo.EntityDecoder.decode(EntityDecoder.java:38)
	at deployment.GoStopHandle.ear//dev.morphia.mapping.codec.pojo.MorphiaCodec.decode(MorphiaCodec.java:69)
	at deployment.GoStopHandle.ear//dev.morphia.mapping.codec.pojo.EntityDecoder.decode(EntityDecoder.java:43)
	at deployment.GoStopHandle.ear//dev.morphia.mapping.codec.pojo.MorphiaCodec.decode(MorphiaCodec.java:69)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.CommandResultArrayCodec.decode(CommandResultArrayCodec.java:52)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.CommandResultDocumentCodec.readValue(CommandResultDocumentCodec.java:60)
	at deployment.GoStopHandle.ear//org.bson.codecs.BsonDocumentCodec.decode(BsonDocumentCodec.java:87)
	at deployment.GoStopHandle.ear//org.bson.codecs.BsonDocumentCodec.decode(BsonDocumentCodec.java:42)
	at deployment.GoStopHandle.ear//org.bson.internal.LazyCodec.decode(LazyCodec.java:48)
	at deployment.GoStopHandle.ear//org.bson.codecs.BsonDocumentCodec.readValue(BsonDocumentCodec.java:104)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.CommandResultDocumentCodec.readValue(CommandResultDocumentCodec.java:63)
	at deployment.GoStopHandle.ear//org.bson.codecs.BsonDocumentCodec.decode(BsonDocumentCodec.java:87)
	at deployment.GoStopHandle.ear//org.bson.codecs.BsonDocumentCodec.decode(BsonDocumentCodec.java:42)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.ReplyMessage.<init>(ReplyMessage.java:51)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.InternalStreamConnection.getCommandResult(InternalStreamConnection.java:535)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:420)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:337)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.UsageTrackingInternalConnection.sendAndReceive(UsageTrackingInternalConnection.java:116)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.sendAndReceive(DefaultConnectionPool.java:644)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.CommandProtocolImpl.execute(CommandProtocolImpl.java:71)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:240)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:226)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:126)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:116)
	at deployment.GoStopHandle.ear//com.mongodb.internal.connection.DefaultServer$OperationCountTrackingConnection.command(DefaultServer.java:345)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.CommandOperationHelper.createReadCommandAndExecute(CommandOperationHelper.java:232)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.FindOperation.lambda$execute$1(FindOperation.java:695)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.OperationHelper.lambda$withSourceAndConnection$2(OperationHelper.java:575)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.OperationHelper.withSuppliedResource(OperationHelper.java:600)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.OperationHelper.lambda$withSourceAndConnection$3(OperationHelper.java:574)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.OperationHelper.withSuppliedResource(OperationHelper.java:600)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.OperationHelper.withSourceAndConnection(OperationHelper.java:573)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.FindOperation.lambda$execute$2(FindOperation.java:690)
	at deployment.GoStopHandle.ear//com.mongodb.internal.async.function.RetryingSyncSupplier.get(RetryingSyncSupplier.java:65)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.FindOperation.execute(FindOperation.java:722)
	at deployment.GoStopHandle.ear//com.mongodb.internal.operation.FindOperation.execute(FindOperation.java:86)
	at deployment.GoStopHandle.ear//com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:191)
	at deployment.GoStopHandle.ear//com.mongodb.client.internal.MongoIterableImpl.execute(MongoIterableImpl.java:135)
	at deployment.GoStopHandle.ear//com.mongodb.client.internal.MongoIterableImpl.iterator(MongoIterableImpl.java:92)
	at deployment.GoStopHandle.ear//dev.morphia.query.MorphiaQuery.prepareCursor(MorphiaQuery.java:381)
	at deployment.GoStopHandle.ear//dev.morphia.query.MorphiaQuery.iterator(MorphiaQuery.java:243)
	at deployment.GoStopHandle.ear//dev.morphia.query.Query.iterator(Query.java:274)

morphia-core-2.3.0-SNAPSHOT
classgraph-4.8.147

mongodb-driver-core-4.6.1
bson-4.6.1
mongodb-driver-sync-4.6.1

MongoDB 5.0.7

[evanchooly]

There's no @Id field on Engine. If you're going to use Engine as a referenced type, you need an ID field. Looks like maybe I should add a validator for that one.

[evanchooly]

Are they references or embedded types?

[NOTiFYcouk]

With Hibernate & ORM/OGM the 'Motorcycle' etc. entities were all 'Embedded':

@Entity(name = GoStopHandle.MOTORCYCLES_ENTITY)
@Indexed
@Table(name = GoStopHandle.MOTORCYCLES_TABLE)
public class Motorcycle implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     *
     */
    private static final Logger LOGGER = LoggerFactory.getLogger(Motorcycle.class);

    @Id
    @Type(type = "objectid")
    private String id;

    @Expose(deserialize = true, serialize = true)
    private String manufacturer; // 1

    @Expose(deserialize = true, serialize = true)
    private String model; // 2

    @Expose(deserialize = true, serialize = true)
    private String modelType; // 3

    @Expose(deserialize = true, serialize = true)
    private String typesOf; // 4

    @Expose(deserialize = true, serialize = true)
    private Date dateProductionStarted; // 5

    @Expose(deserialize = true, serialize = true)
    private Date dateProductionEnded; // 6

    @Expose(deserialize = true, serialize = true)
    @Embedded
    private Engine engine;

    @Expose(deserialize = true, serialize = true)
    @Embedded
    private Performance performance;

    @Embedded
    private ChassisBrakesSuspensionWheels chassisBrakesSuspensionWheels;

    @Embedded
    private DimensionsWeights dimensions;

    @Embedded
    //private com.gostophandle.kotlin.entity.Transmission transmission;
    private Transmission transmission;

    @Embedded
    //private com.gostophandle.kotlin.entity.Instruments instruments;
    private Instruments instruments;

    //@Embedded
    //private com.gostophandle.kotlin.entity.Weights weights;

    @Embedded
    private Electrics electrics;

    @Expose(deserialize = true, serialize = true)
    @ElementCollection(fetch = FetchType.EAGER)
    private Set<Colour> colours;

    @ElementCollection(fetch = FetchType.EAGER)
    private Set<Accessory> accessories;

    @Embedded
    private Image image;

[evanchooly]

Then they probably need to be here as well. If they're supposed to live in another collection, use @Reference.

[NOTiFYcouk]

Added two of my nine Entity as:

import javax.persistence.Embedded;

@Entity(value = "motorcycles", useDiscriminator = false)
@Indexes(@Index(options = @IndexOptions(name = "motorcycles")))
public class Motorcycle {

   @Embedded
   private Engine engine;

   @Embedded
   private Performance performance;

   etc ...
}

@Entity(value = "engine", useDiscriminator = false)
@Indexes(@Index(options = @IndexOptions(name = "engine")))
public class Engine {
   ...
}

@Entity(value = "performance", useDiscriminator = false)
@Indexes(@Index(options = @IndexOptions(name = "performance")))
public class Performance {
   ...
}

Now works fine. Rough data is:

22:41:44,038 INFO [com.gostophandle.ejb.MotorcyclesEJB] (ServerService Thread Pool -- 91) ***** 5 MotorcyclesEJB = Motorcycle{id='627b8b9589034bb0c0d3c318', manufacturer='Moto Guzzi', model='Le Mans', modelType='II', typesOf='Sport', dateProductionStarted=Sun Jan 01 00:00:00 GMT 1978, dateProductionEnded=Mon Jan 01 00:00:00 GMT 1979, engine=Engine{type='Four-Stroke', displacement=850.0, cylinder=2.0, capacityUnit='cc', bore=80.0, boreMeasurement='mm', stroke=74.0, strokeMeasurement='mm', distribution='null', maxiumPowerHp=85.0, maxiumPowerKilowatt=38.0, maxiumPowerRpm=6200.0, maximumTorque=60.0, maximumTorqueUnit='Nm', maximumTorqueRpm=4900.0}}

Perfect. Thanks very much.

[evanchooly]

Morphia doesn't use or know about the Java/Jakarta EE annotations for what it's worth. So that javax.persistence.Embedded annotation isn't doing anything as far as Morphia is concerned.