Roman Rokytskyy wrote:

>>The j2ee specs effectively require you to use thread locals in
>>several places, and indeed I haven't found any way to implement JTA
>>transactions without a thread local.
>>
>>
>
>Also, for your information, SQLJ requires to obtain context connection
>in Java method like this:
>
>public static void someProcedure(int valueA, String valueB) {
> Connection connection =
> DriverManager.getConnection("jdbc:default:connection");
>
> ...
>}
>
>So, the code first has to call the method (in our case reflection) and
>only then access to the connection happens. I see no chance to solve
>this without TLS in this case. But sure, this can be done already in
>Java code.
>
>

A better way to handle this would be to define your procedure as:

public static void someProcedure (Connection connect, int valueA,
String valueB)
{
}

If you do it this way, anyone can call the procedure with a connection
object an expect it to work.

--

Jim Starkey
Netfrastructure, Inc.
978 526-1376