Announcement

**Isomorphic** · 13 Jul 2011, 09:41

You're doing manual transaction management, so in this instance, you want to disable auto-joining transactions on the RPCManager - just for this request - add an RPCManager to your DMI method's arguments to get access to it.

**claudiobosticco** · 14 Jul 2011, 07:58

I've just tried adding:
dsRequest.setJoinTransaction(false);

as the first line in my DMI method, but I get this warning:
Request processing has started; join transactions setting cannot be changed

I've also tried:
rpcManager.setTransactionPolicy(TransactionPolicy.NONE);

but I get a similar warning:
Queue processing has started; transaction policy cannot be changed

what am I doing wrong?

**Isomorphic** · 14 Jul 2011, 08:47

Sorry, to clarify, two ways to do this:

1. don't manually initiate a transaction, one is already ongoing. Instead, for your manually created dsRequests, call setJoinTransaction(true) and setRPCManager() with the current RPCManager. No calls to SQLTransaction at all, it's automatic. This is the preferred approach.

2. disable automatic transactions via RPCManager.setTransactionPolicy(), but this must be done before any DSRequests start executing, so for example, in a replacement IDACall servlet. Then manually manage the transaction as you are doing below.

**claudiobosticco** · 14 Jul 2011, 09:31

I'm trying approach n. 1:
- as you can see in my sample code, I already have a RPCManager parameter
- I already set it on my manually created dsRequests
- I've removed every SQLTransaction operation
- I've added setJoinTransactions (btw I have got autoJoinTransactions: true in server.properties)

my new sample code is:

Code:

	public static DSResponse printLabel(DSRequest dsRequest, RPCManager rpcManager, HttpServletResponse httpServletResponse,
			HttpServletRequest httpServletRequest) throws Exception {
		DSRequest dsRequestInvitiFetch = new DSRequest("INVITI", "fetch");
		dsRequestInvitiFetch.setJoinTransaction(true);
		dsRequestInvitiFetch.setAdvancedCriteria(dsRequest.getAdvancedCriteria());
		dsRequestInvitiFetch.setRPCManager(rpcManager);
		DSResponse dsResponseInvitiFetch = dsRequestInvitiFetch.execute();
		List<Map<String, Object>> inviti = dsResponseInvitiFetch.getDataList();
		updateDataStampaEtichette(rpcManager, inviti);
		Servlets.downloadAsAttachment(httpServletResponse,
				httpServletRequest.getServletContext().getResourceAsStream("./reports/report1.pdf"), "etichette.pdf");
		httpServletResponse.getOutputStream().flush();
		httpServletResponse.getOutputStream().close();
		SQLTransaction.commitTransaction(rpcManager, "dbInviti");
		DSResponse dsResponse = new DSResponse();
		rpcManager.doCustomResponse();
		return dsResponse;
	}

	@SuppressWarnings("unchecked")
	private static void updateDataStampaEtichette(RPCManager rpcManager, List<Map<String, Object>> inviti) throws Exception {
		Map<String, Date> values = DataTools.buildMap("DATA_STAMPA_ETICHETTA", new Date());
		for (Map<String, Object> invito : inviti) {
			DSRequest dsRequestInvitiUpdate = new DSRequest("INVITI", "update");
			dsRequestInvitiUpdate.setJoinTransaction(true);
			dsRequestInvitiUpdate.setFieldValue("ID_INVITO", invito.get("ID_INVITO"));
			dsRequestInvitiUpdate.setValues(values);
			dsRequestInvitiUpdate.setRPCManager(rpcManager);
			DSResponse dsResponseInvitiUpdate = dsRequestInvitiUpdate.execute();
			dsResponseInvitiUpdate.getAffectedRows();
		}
	}

but I get the same warning...

Announcement

SQLTransaction warning

Comment

Comment

Comment

Comment