public class PSSQLPackage
{
  // some methods
  public void test (
    String pVar[])
  throws SQLException
  {
    #sql [getConnectionContext()] { CALL COLA.COLP_GLOBAL.TEST(
      :INOUT (pVar[0])) };
  }
  // some other methods
}

// first solution: doesn't create so many object instances of PSSQLPackage
// but when do I release the package
// and can I be sure that the next time I call getPackage() the connection is still safe to use?
public class MyAppModuleImplVersion1 extends ApplicationModuleImpl 
{
	private PSSQLPackage mMypackage;
	
	private synchronized PSSQLPackage getPackage() throws SQLException
	{
		if( mMypackage==null )
		{
			mMypackage = new PSSQLPackage( getDBTransaction().createStatement(1).getConnection() );
		}
	}
	
	public void test( String[] aInOutParam ) throws SQLException
	{
		getPackage().test(aInOutParam);
	}
	
	// but when do I release the package now
}

// second solution: creates for each call a new instance of PSSQLPackage
// but I can be sure, that the connection is every time valid and i do know exactly
// where I have to release the PSSQLPackage
public class MyAppModuleImplVersion2 extends ApplicationModuleImpl 
{
	private PSSQLPackage createPackage() throws SQLException
	{
		return new PSSQLPackage( getDBTransaction().createStatement(1).getConnection() );
	}
	
	public void test( String[] aInOutParam ) throws SQLException
	{
		PSSQLPackage pack = createPackage();
		try
		{
			return pack.test(aInOutParam);
		}
		finally
		{
			pack.release();
		}
	}
}

// are there any other solutions to my problem?