Hello,

I have a simple stored procedure for SQL Server 2000, that does not take any parameters and returns a scalar value, which is the result of "for XML AUTO" syntax in SQL Server. Basically, it returns rows of String values.

The problem is that the column name it assigns to the single column in the result set seems to be unpredictable and able to change from request to request. I cannot find a way to assign my own column name ("as" doesn work in cases like that).
Am I missing something here....?

So, it leaves an option of retrieving the scalar by index. Unfortunately, I cannot find a way to do that, "return-property" requires the column name.

I believe it is one of those few cases when one has to acquire direct hold of Connection... but maybe I'm wrong?

thanks,
Denis.

if the result is just a scalar and you don't get a real resultset nor a predicatable way of getting it via aliases - then yes, use raw jdbc