ISolation levels

["Rios, Hector" <He...@de.rolandberger.com>]

Hi there,

I am relatively new to Sql Maps and was unsure of how to implement 
different isolation levels using Sql Maps

I need to implement Synchronized isolation level. Can anyone post an
example
of how I would do this.

I have something like this but I don't think this is exactly right.

		SqlMapClient client =
SqlMapClientFactory.getSqlMapInstance();
		Connection cn = null;				
		try
		{
		    cn = client.getDataSource().getConnection();
		    int defaultIsolation = cn.getTransactionIsolation();
	
cn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
		    client.setUserConnection(cn);
		    client.startTransaction();			
		    client.insert(queryName,input);			
		    client.commitTransaction();
		}
		finally
		{		    
			client.endTransaction();
			cn.close();
		}

TIA

-Hector
Please inform us immediately if this e-mail and/or any attachment was 
transmitted incompletely or was not intelligible.
______________________________________________________________

This e-mail and any attachment is for authorized use by the intended 
recipient(s) only. It may contain proprietary material, confidential 
information and/or be subject to legal privilege. It should not be
copied, 
disclosed to, retained or used by any other party. 
If you are not an intended recipient then please promptly delete this 
e-mail and any attachment and all copies and inform the sender.