cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Mittendorf <>
Subject Running a query over multiple Databases?
Date Fri, 16 Mar 2007 15:26:02 GMT

I've found the mutiple database example on cayennes homepage:

That example is a pretty good resemblance of our current problem.

What we would like to do is to run a single query over both  
databases, like i.e.

SelectQuery select = new SelectQuery(Person.class);
Expression expression = ExpressionFactory.matchExp 
	"." + Department.NAME_PROPERTY, "IT Department");

But such a query runs into an exception with the following error  

Base table or view not found,  message from server: "Table ''  
doesn't exist"

Are such queries supported by Cayenne or do we have to split the task  
two single queries?


View raw message