Hello,

Is there a way to specify TBP parameters in the JDBC URL string? Could you
provide an example for doing this for SNAPSHOT WAIT transaction isolation
level?

Thanks

On Thu, Apr 22, 2010 at 3:24 AM, Roman Rokytskyy <roman@...> wrote:

>
>
> > I want to use read-only read commited transaction for very long read-only
> > queries and snapshot transactions for reports, but I can't find how to
> set
> > these properties for transactions in Jaybird.
> >
> > Could you please show me the code example or give the link to
> > manual/javadoc?
>
> TransactionParameterBuffer tpb1 =
> connection1.createTransactionParameterBuffer();
>
> tpb1.addArgument(TransactionParameterBuffer.READ_COMMITTED);
> tpb1.addArgument(TransactionParameterBuffer.REC_VERSION);
> tpb1.addArgument(TransactionParameterBuffer.READ);
> tpb1.addArgument(TransactionParameterBuffer.WAIT);
>
> connection1.setTransactionParameters(tpb1);
>
> TransactionParameterBuffer tpb2 =
> connection2.createTransactionParameterBuffer();
>
> tpb2.addArgument(TransactionParameterBuffer.CONCURRENCY);
> tpb2.addArgument(TransactionParameterBuffer.WRITE);
> tpb2.addArgument(TransactionParameterBuffer.WAIT);
>
> connection2.setTransactionParameters(tpb);
>
> Please note, if you use
> setTransactionParameters(TransactionParameterBuffer tpb) method, it is
> only for the next transaction with that particular isolation level, if
> you want to change the TPB mapping (which will apply for all next
> transactions in the same VM with the same isolation level), you should
> use "setTransactionParameters(int isolationLevel,
> TransactionParameterBuffer tpb)", where isolationLevel is the constant
> from java.sql.Connection interface.
>
> Roman
>
>


[Non-text portions of this message have been removed]