Re: Use of TSQLServer

Hi Marina,

  which ROOT Oracle plugin do you use? The one from GSI or the new one in ROOT?

Cheers, Fons.

Marina Giunta wrote:
> Hello,
> I am trying to use ROOT with data stored in an Oracle db.
>
> I perform a query using:
> TSQLResult *res=db->Query(SELECT element_id, element_name FROM elements);
> I know the query returns the right number of rows, because by looping over
> them I get the right total number,but using:
>
> int rowNr = res->GetRowCount();
>
> I obtain as result -1.
>
> Then, res->GetFieldCount() gives as result 2, but then, if I try to get
> the contents of the fields using TSQLRow::GetField(Int_t field), if I use
> row->GetField(0)
> root crashes without any error message, with
> row->GetField(1)
> I get a result that I tried to convert to a string, but I get only
> strange outputs and with
> row->GetField(2) I get the message:
> Error in <TOracleRow::IsValid>: field index out of bounds
>
> How do I get the contents of my two fields?
>
> Thanks
> Marina
>

-- 
Org:    CERN, European Laboratory for Particle Physics.
Mail:   1211 Geneve 23, Switzerland
E-Mail: Fons.Rademakers_at_cern.ch              Phone: +41 22 7679248
WWW:    http://www.rademakers.org/fons/      Fax:   +41 22 7679480