RE: Use of TSQLServer

From: Philippe Canal <>
Date: Thu, 07 Apr 2005 12:14:27 -0500


This new oracle plugin is still very much in development. GetRowCount is indeed not yet implemented. The rest should have worked :(. We will look into it as soon as possible.

Thanks for reporting this problem.


-----Original Message-----
From: [] On Behalf Of Marina Giunta
Sent: Wednesday, April 06, 2005 10:55 AM To: Roottalk
Subject: [ROOT] Use of TSQLServer

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 Thu Apr 07 2005 - 19:13:54 MEST

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