Use of TSQLServer

From: Marina Giunta <>
Date: Wed, 6 Apr 2005 17:55:25 +0200 (CEST)

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?



Marina Giunta 

Department of Physics, | At CERN UC Riverside, | OFF: 28-2-006 Riverside CA92521 USA | TEL: +41-22-76-78178
Received on Wed Apr 06 2005 - 17:55:30 MEST

This archive was generated by hypermail 2.2.0 : Tue Jan 02 2007 - 14:45:06 MET