Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] TENANT_PER_TABLE Problem. Can't compile Named Query.

I retract my previous statement.... I accidentally switched back to 2.4.1.
Switching to 2.5.0-M6, your suggestion works with createNamedQuery() and
createQuery()!

So, the following results in an exception:

	@Override
	public List<Item> listActiveItems() {
		em.setProperty("customer_schema", "cust_tables");
		// em.find(Item.class, 1L);
		log.debug("listActiveItems()");
		TypedQuery<Item> query = em.createNamedQuery("listActiveItems",
Item.class);
		List<Item> results = query.getResultList();
		log.debug("listActiveItems() found {} items", results.size());
		return results;
	}


The following works:

	@Override
	public List<Item> listActiveItems() {
		em.setProperty("customer_schema", "cust_tables");
		em.find(Item.class, 1L);
		log.debug("listActiveItems()");
		TypedQuery<Item> query = em.createNamedQuery("listActiveItems",
Item.class);
		List<Item> results = query.getResultList();
		log.debug("listActiveItems() found {} items", results.size());
		return results;
	}



--
View this message in context: http://eclipse.1072660.n5.nabble.com/TENANT-PER-TABLE-Problem-Can-t-compile-Named-Query-tp157573p157603.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.


Back to the top