> Does anyone know how I specify the SQL role to use for the user? I
> tried setting a config-property of "SqlRole" but that didn't work.

sqlRole property is not available when using FBManagedConnectionFactory.

You can set is by setting the connectionRequestInfo property in Java code,
but there is no chance to do this from config file.

That is our oversight, will be corrected in next version, though I currently
cannot tell approx. release time (originally we planned end of March -
beginning of April for first release candidates).

As a workaround, you should be able to use FBConnectionPoolDataSource as an
XADataSource implementation. That should give you approx. the same
functionality.

Roman