Hi Everyone, can anyone help me to fix my issue. ...
# lucee
n
Hi Everyone, can anyone help me to fix my issue. For one of my project I am using MongoDB version 7 with Lucee 6.2.1.122. I am using cbmongoDB module. Below is the code I am using
Copy code
//module injection

property name="MongoClient" inject="MongoClient@cbmongodb";
property name="MongoUtil"   inject="MongoUtil@cbmongodb";
property name="MongoIndexer" inject="MongoIndexer@cbmongodb";

//mycode
var MyDB = MongoClient.getDBCollection('myCollection');	
var criteriaQry = [
{
	   '$match':{
		'$and': [
			{ 'dealerId': { '$eq': Int(arguments.dealerId) } },
			 {'isDeleted': false},
             {'isDraft': false}
		]
	   }
},
{
	'$count': 'count'
}

];

var rrx = MyDB.aggregation(criteriaQry).asArray();
the 'MyDB.aggregation(criteriaQry).asArray();' results in error: class coldfusion.runtime.java.JavaProxy cannot be cast to class org.bson.conversions.Bson (coldfusion.runtime.java.JavaProxy is in unnamed module of loader org.apache.felix.framework.BundleWiringImpl$BundleClassLoader @2f218355; org.bson.conversions.Bson is in unnamed module of loader com.compoundtheory.classloader.NetworkClassLoader @70f1198a)class coldfusion.runtime.java.JavaProxy cannot be cast to class org.bson.conversions.Bson (coldfusion.runtime.java.JavaProxy is in unnamed module of loader org.apache.felix.framework.BundleWiringImpl$BundleClassLoader @2f218355; org.bson.conversions.Bson is in unnamed module of loader com.compoundtheory.classloader.NetworkClassLoader @70f1198a) Also I changed my code to use the JAVA liberaries directly
Copy code
//module injection

property name="jLoader" inject="id:loader@cbjavaloader";

//mycode
var mongoClientClass = jLoader.create("com.mongodb.client.MongoClients");
mongo = mongoClientClass.create("mongoDBConnectionString");
db = mongo.getDatabase("dataBaseName");
collection = db.getCollection("DbCollection");

dealerId = javacast("int", 32); // or hardcode for test
pipeline = createObject("java", "java.util.ArrayList");


var matchStage = jLoader.create('org.bson.Document');
matchStage.append("\$match", {
	dealerId: dealerId,
	isDeleted: false,
	isDraft: false
});

var countStage = jLoader.create('org.bson.Document');
countStage.append("\$count", "count");

pipeline.add(matchStage);
pipeline.add(countStage);

result = collection.aggregate(pipeline);

// Read result
resultList = [];
iterator = result.iterator();
while (iterator.hasNext()) {
	doc = iterator.next();
	arrayAppend(resultList, doc.toJson());
}

writeDump(resultList); abort;
I am getting the below error for the 'result.iterator();' class coldfusion.runtime.java.JavaProxy cannot be cast to class org.bson.conversions.Bson (coldfusion.runtime.java.JavaProxy is in unnamed module of loader org.apache.felix.framework.BundleWiringImpl$BundleClassLoader @30cd734b; org.bson.conversions.Bson is in unnamed module of loader com.compoundtheory.classloader.NetworkClassLoader @5fba4e7d)
z
The error you're encountering is a classic classloader conflict between different Java class loaders used in Lucee, especially when combining, the
cbmongodb
module (which uses
cbjavaloader
) and Lucee's internal classloader
👍 1